Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Bo Jacobsen 605 posts 2403 karma points
    Jun 16, 2023 @ 09:38
    Bo Jacobsen
    0

    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:

    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'.
    
  • Bo Jacobsen 605 posts 2403 karma points
    Jun 16, 2023 @ 12:03
    Bo Jacobsen
    100

    After we emptyed the trashcan on Content and Media and made a new Export Data-tier Application... The error was gone.

Please Sign in or register to post replies

Write your reply to:

Draft