No se puede importar SQL Azure bacpac a 2016 CTP
Estoy muy familiarizado con el proceso de exportar desde Azure SQL V12 a mi cuadro de desarrollo y luego importarlo a mi instancia local de sql (2014). Estoy girando una nueva caja de Win10 y he instalado el SQL 2016 CTP. Me estoy conectando a esa misma instancia de Azure y puedo operar contra ella, y puedo exportar un .bacpac como en 2014.
Pero cuando trato de importar a local obtengo:
Could not import package.
Warning SQL72012: The object [FOO33_Data] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box.
Warning SQL72012: The object [FOO33_Log] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box.
Error SQL72014: .Net SqlClient Data Provider: Msg 547, Level 16, State 0, Line 3 The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_dbo.Address_dbo.User_idUser". The conflict occurred in database "FOO33", table "dbo.User", column 'idUser'.
Error SQL72045: Script execution error. The executed script:
PRINT N'Checking constraint: FK_dbo.Address_dbo.User_idUser [dbo].[Address]';
ALTER TABLE [dbo].[Address] WITH CHECK CHECK CONSTRAINT [FK_dbo.Address_dbo.User_idUser];