Copied to clipboard

Flag this post as spam?

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


  • Davide Balosetti 37 posts 218 karma points
    Sep 27, 2019 @ 10:35
    Davide Balosetti
    0

    Umbraco migration on other Server

    Dear all, i've chosen to move my website built in umbraco 7.15.3 to a new provider for better performance and features, i've copied all the files but when i was ready to restore the database i've seen that on the new server was running an old version of sql server

    The database was backed up on a server running version 14.00.3192. That version is incompatible with this server, which is running version 13.00.5426

    So i've followed this procedure for migrate data and schema https://dba.stackexchange.com/questions/4906/restoring-a-backup-to-an-older-version-of-sql-server/64804#64804 but when i've restored data i get the following errors

        Messaggio 547, livello 16, stato 0, riga 20
    The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "MSSql139030", table "MSSql139030.umbracoNode", column 'id'.
    The statement has been terminated.
    Messaggio 547, livello 16, stato 0, riga 21
    The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "MSSql139030", table "MSSql139030.umbracoNode", column 'id'.
    The statement has been terminated.
    Messaggio 547, livello 16, stato 0, riga 22
    The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "MSSql139030", table "MSSql139030.umbracoNode", column 'id'.
    The statement has been terminated.
    Messaggio 547, livello 16, stato 0, riga 23
    The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "MSSql139030", table "MSSql139030.umbracoNode", column 'id'.
    The statement has been terminated.
    Messaggio 547, livello 16, stato 0, riga 24
    The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "MSSql139030", table "MSSql139030.umbracoNode", column 'id'.
    The statement has been terminated.
    Messaggio 547, livello 16, stato 0, riga 25
    The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "MSSql139030", table "MSSql139030.umbracoNode", column 'id'.
    The statement has been terminated.
    Messaggio 547, livello 16, stato 0, riga 26
    The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "MSSql139030", table "MSSql139030.umbracoNode", column 'id'.
    The statement has been terminated.
    Messaggio 547, livello 16, stato 0, riga 27
    The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "MSSql139030", table "MSSql139030.umbracoNode", column 'id'.
    The statement has been terminated.
    Messaggio 547, livello 16, stato 0, riga 28
    The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "MSSql139030", table "MSSql139030.umbracoNode", column 'id'.
    The statement has been terminated.
    Messaggio 547, livello 16, stato 0, riga 29
    The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "MSSql139030", table "MSSql139030.umbracoNode", column 'id'.
    The statement has been terminated.
    Messaggio 547, livello 16, stato 0, riga 30
    The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "MSSql139030", table "MSSql139030.umbracoNode", column 'id'.
    The statement has been terminated.
    Messaggio 547, livello 16, stato 0, riga 31
    The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "MSSql139030", table "MSSql139030.umbracoNode", column 'id'.
    The statement has been terminated.
    Messaggio 547, livello 16, stato 0, riga 32
    The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "MSSql139030", table "MSSql139030.umbracoNode", column 'id'.
    The statement has been terminated.
    Messaggio 547, livello 16, stato 0, riga 33
    The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "MSSql139030", table "MSSql139030.umbracoNode", column 'id'.
    The statement has been terminated.
    Messaggio 547, livello 16, stato 0, riga 34
    The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "MSSql139030", table "MSSql139030.umbracoNode", column 'id'.
    The statement has been terminated.
    Messaggio 547, livello 16, stato 0, riga 35
    The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "MSSql139030", table "MSSql139030.umbracoNode", column 'id'.
    The statement has been terminated.
    Messaggio 547, livello 16, stato 0, riga 36
    The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "MSSql139030", table "MSSql139030.umbracoNode", column 'id'.
    The statement has been terminated.
    Messaggio 547, livello 16, stato 0, riga 37
    The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "MSSql139030", table "MSSql139030.umbracoNode", column 'id'.
    The statement has been terminated.
    Messaggio 547, livello 16, stato 0, riga 38
    The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "MSSql139030", table "MSSql139030.umbracoNode", column 'id'.
    The statement has been terminated.
    Messaggio 547, livello 16, stato 0, riga 39
    The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "MSSql139030", table "MSSql139030.umbracoNode", column 'id'.
    The statement has been terminated.
    

    Now i can access to umbraco interface and i can see al my items with the right data but when i try to access the website i canno't see any data from umbraco (images, texts, ect)

    Any suggestion?

    Thanks in advance Davide

  • Jonathan Distenfeld 105 posts 618 karma points
    Sep 27, 2019 @ 10:43
    Jonathan Distenfeld
    0

    Hi,

    try using the Microsoft Data Migration Assistant: https://docs.microsoft.com/sql/dma/dma-overview?view=sql-server-2017

    Its pretty easy to use and migrates correctly. This tool saved me a lot of time!

    ~ Jonathan

  • Davide Balosetti 37 posts 218 karma points
    Sep 30, 2019 @ 09:12
    Davide Balosetti
    100

    Hi Jonathan, thanks for your suggestion, in the end i've follow the following link

    https://our.umbraco.com/forum/using-umbraco-and-getting-started/86554-how-to-move-an-umbraco-sql-server-2014-database-to-sql-server-2012

    and it works fine

    Thanks for your help!

    Best regards Davide

Please Sign in or register to post replies

Write your reply to:

Draft