Copied to clipboard

Flag this post as spam?

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


  • Phil Crowe 192 posts 256 karma points
    Aug 20, 2010 @ 17:46
    Phil Crowe
    0

    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.

  • Phil Crowe 192 posts 256 karma points
    Aug 20, 2010 @ 17:53
    Phil Crowe
    0

    thought id mention this is v 4.0.4.2

  • Phil Crowe 192 posts 256 karma points
    Aug 23, 2010 @ 09:32
    Phil Crowe
    0

    Hi I just wanted to get this bumped up the forum list. Still havent got a solution to it.

  • Matt Brailsford 4125 posts 22223 karma points MVP 9x c-trib
    Aug 23, 2010 @ 09:38
    Matt Brailsford
    0

    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

  • Hendy Racher 863 posts 3849 karma points MVP 2x admin c-trib
    Aug 23, 2010 @ 09:46
    Hendy Racher
    1

    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

  • Phil Crowe 192 posts 256 karma points
    Aug 23, 2010 @ 10:07
    Phil Crowe
    0

    Hi Hendy, Im giving your suggestion a try now. Its taking ages to execute the query.

  • Jon R. Humphrey 164 posts 455 karma points c-trib
    Sep 10, 2011 @ 01:58
    Jon R. Humphrey
    1

    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!

     

  • Cleyton 7 posts 27 karma points
    Mar 02, 2012 @ 17:05
    Cleyton
    0

    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

  • Cleyton 7 posts 27 karma points
    Mar 02, 2012 @ 17:13
    Cleyton
    0

    Nevermind.

    I checked the tables and the DTS did not created the Identity of the tables... that's the problem.

Please Sign in or register to post replies

Write your reply to:

Draft