downgrading from sql server 2008 to sql server 2005
Hi my company has built a website for a client, it was developed on sql server 2008. The client wanted the site to run off of their server that uses sql server 2005. I had an email saying they were able to convert the database into 2005 using some conversion wizard in sql server(i didnt know what they were referring to). Everything seemed to be working ok until i tried to create a new page. Basically i right clicked on the parent node, selected my document type and specified what i wanted to call the new page, hit create and got this error:
Cannot insert the value NULL into column 'id', table 'MyDatabase.dbo.umbracoNode'; column does not allow nulls. INSERT fails. The statement has been terminated.
When they did this conversion it did strip out the stored procedures that i had created so i had to recreate them.
I found the easiest way to move a database from 2008 to 2005 was to generate it as a script from SQL Management Studio (remembering to set the flag to include data, and targeting 2005).
I know this post is over a year old, but you saved what little hair I have left with this!
For everyone else, follow Hendy's advice and you should be good. If you're renaming the database just do a search and replace ( one by one ) on the old to new name just to be sure!
Thank you as well to Phil for posting the original question!
downgrading from sql server 2008 to sql server 2005
Hi my company has built a website for a client, it was developed on sql server 2008. The client wanted the site to run off of their server that uses sql server 2005. I had an email saying they were able to convert the database into 2005 using some conversion wizard in sql server(i didnt know what they were referring to). Everything seemed to be working ok until i tried to create a new page. Basically i right clicked on the parent node, selected my document type and specified what i wanted to call the new page, hit create and got this error:
Cannot insert the value NULL into column 'id', table 'MyDatabase.dbo.umbracoNode'; column does not allow nulls. INSERT fails.
The statement has been terminated.
When they did this conversion it did strip out the stored procedures that i had created so i had to recreate them.
thought id mention this is v 4.0.4.2
Hi I just wanted to get this bumped up the forum list. Still havent got a solution to it.
Hi Phil,
Have you tried looking in the umbracoLog table to see if you can find more info on what/where is causing the problem?
Matt
Hi Phil,
I found the easiest way to move a database from 2008 to 2005 was to generate it as a script from SQL Management Studio (remembering to set the flag to include data, and targeting 2005).
This has worked for me in the past with 4.0.3.
HTH,
Hendy
Hi Hendy, Im giving your suggestion a try now. Its taking ages to execute the query.
Hendy,
I know this post is over a year old, but you saved what little hair I have left with this!
For everyone else, follow Hendy's advice and you should be good.
If you're renaming the database just do a search and replace ( one by one ) on the old to new name just to be sure!
Thank you as well to Phil for posting the original question!
Slainte!
Hello, I'm using umbraco 4.7.1 and I have the same problem.
The fact is I did a DTS from SQL 2008 to 2005 copying tables and the data and I can't access the Sql Server of the client due internal politics.
There is any script DML to fix this?
What is the root cause of the problem?
Thanks
Nevermind.
I checked the tables and the DTS did not created the Identity of the tables... that's the problem.
is working on a reply...