Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
I have run a script to move all Umbraco data from SQL Server 2008 to 2014.
The script was successful and all data moved over. I can load up the site but when I try to add an image to the media store I get an error.
The log is as follows with 4 errors in a row, not sure they are all related to adding the image though.
Does anyone have any advice about what this might mean or what might have gone wrong?
How did you move the database from one server to another?
Did you make a backup on older and restore on newer?
Hello, you must have generated a script by management studio with the option to insert the primary keys. I have tried several times to do this method and it does not work with Umbraco, has always presented this error.
It also did not run with export data from management studio.
The best way is to backup the database, or if you do not need to keep the content versions, use Usync
Thanks for answering my query.
I did generate a script from Management Studio which is what gave me these errors.
I have just tried a backup and restore but now when I try to login or get to the site Umbraco tries to redirect me to AuthorizeUpgrade and my login does not work at all.
I am going to give uSync a go and see how I get on but if you have any other suggestions I will always be grateful.
OK just in case it might help someone else.
I used uSync to move everything over. seems to have worked well so thanks for that.
However I now get intermittent SQL timeout errors...
Umbraco.Core.Persistence.UmbracoDatabase - Database exception occurred
System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
It seems to be mostly with loading the Media store (a lot of child folders) or one Content node that has a lot of children.
Appreciate any more feedback on this.
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted