February 11, 2009 at 8:35 am
I have restored 120 SQL 2000 databases to SQL 2005. They are in 8.0 mode now. If we change them to 9.0 mode and find applications issues, is it ok to switch compability mode back to 8.0? Are there any issues? Should we actually restore the SQL 2000 db again?
February 11, 2009 at 8:44 am
I actually had a SQL 7 database that was moved to SQL 2000. I then changed the compatibility to 80 and some of the procs stopped working so we changed the compatibility back to 70 and it worked fine. The procs were just SELECT statments that used an old mthod of JOINING tables and so did not work. It seems the compatibility changes the environment in which things run. They will either work or not and the database compatibility can be changed up or down. The impact is in what happens if that proc failed. I would suggest running the Upgrade Advisor tool which will point out potential issues prior to upgrading.
Francis
February 11, 2009 at 8:50 am
ok thanks, most of our code are in the applications so Upgrade Advisor probably won't help.
February 11, 2009 at 9:28 am
you can switch compatibility mode back and forth. It doesn't change the structures or data, it just changes how things are interpreted.
February 11, 2009 at 9:36 am
Thanks. I ended up running the Upgrade Advisor. It did find several stored procs that need to be changed to OUTER JOINs.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply