Sign in Register
Go to solution
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 597 posts 2395 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

    Using Umbraco And Getting Started
    Umbraco 7

    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'.
    Copy Link
  • Bo Jacobsen 597 posts 2395 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.

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft