August 17, 2008 at 6:21 pm
Hi All,
If I restore a 2000 db to a 2005 instance will the database options be transferred too?
August 17, 2008 at 6:29 pm
They should be.
August 18, 2008 at 5:31 am
I know you didn't specifically ask, but you may want to look into changing the compatibility level of the database once restored in order to take advantage of all of the new 2005 features.
Before you attempt this, check that your DB doesn't conatain any new reserved words etc. You can check this by running the SQL 2005 upgrade advisor against the database.
August 18, 2008 at 4:45 pm
thanks for checking Andrew - I have done that
August 21, 2008 at 7:02 am
make sure, you do a
dbcc updateusage('{databasename}')
and a
sp_updatestats
on your migrated database
Wilfred
The best things in life are the simple things
August 25, 2008 at 9:51 pm
thank you - I would not have done that if you didn't tell me 🙂
August 28, 2008 at 7:09 am
While its great to ask, really you should test and review. I highly suggest that you have the db options documented, perhaps in a wiki, and after upgrading on a test server, run the comparison.
The more you are prepared, the less you need it.
August 29, 2008 at 1:45 am
Run the SQL 2005 upgrade advisor if you are planning to do an in place upgrade.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply