When we try and Import Data-tier Application through the MSSQL Server Mangement Studio we encounter this error:
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_cmsContent_umbracoNode_id".
The conflict occurred in database "newDB", table "dbo.umbracoNode", column 'id'.
Import Data-tier Application gives the error: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
Hi all.
We are using Umbraco Cloud 7.15.7 and tring to install the database on our MSSQL Server 15.0.2000.
We have used the Export Data-tier Application following this guide https://docs.umbraco.com/umbraco-cloud/databases/backups
When we try and Import Data-tier Application through the MSSQL Server Mangement Studio we encounter this error:
After we emptyed the trashcan on Content and Media and made a new Export Data-tier Application... The error was gone.
is working on a reply...