我正在尝试将sql Azure数据库的备份(.bacpac)还原到另一个sql Azure数据库,但由于以下错误而无法执行此操作：
Error encountered during the service operation. Could not import
package. 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_x_xx”. The conflict occurred in database
“x”,table “dbo.x”. Error sql72045: Script execution error. The
executed script: PRINT N’Checking constraint: FK_x_xx[dbo].[x]’; ALTER
TABLE [dbo].[x] WITH CHECK CHECK CONSTRAINT [FK_x_xx];
我还试图在本地恢复但没有成功使用mscorlib异常(我将再次尝试它,并将很快更新确切的错误消息.
我检查了实时数据库,我看不出为什么这个密钥被违反了.
