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
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)
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
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
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
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
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
is working on a reply...