upgrade DATABASE from SQL 2000 to SQL2005

upgrade DATABASE from SQL 2000 to SQL2005 (Full Version)

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003

Message

joeltje -> upgrade DATABASE from SQL 2000 to SQL2005 (9/16/2008 6:00:50 AM)
hi, Has anyone moved their SMS2003 db to a SQL2005 db server (not an upgrade of the SQL server itself!!) and continued working in the SMS2003 infrastructure?

iglatz -> RE: upgrade DATABASE from SQL 2000 to SQL2005 (9/17/2008 5:21:43 AM)
I doubt that you can use a SQL 2000 DB with SQL 2005. I think that an upgrade will do a couple of changes in the db structure. But I've heard rumours that it might be possible. You might give it a try to copy the db files to the new SQL server and attach them. Then you'll have to change the SMS provider. I'm not quite sure if this provider needs to reside on the server where the database can be found or if this is independent. At least, the provider can't be used on a clustered SQL server. There's the new SQL Server management studio that you might use to move the database, but I've never worked with it. I've done upgrades but never moved the database in between different versions.

skissinger -> RE: upgrade DATABASE from SQL 2000 to SQL2005 (9/17/2008 8:51:34 AM)
I've never done that either. But just thinking as I type... If you want to take a slower, more cautious, but probably higher chance of success without wierdness route... Can you build up a temporary SQL 2000 instance on a server that you can update? Perhaps first move the database from SQL2k server #1 to Temp SQL2k Server #2. Once you have that working & tested for a while (hours vs. days of testing is your call), upgrade it from SQL 2k to SQL 2005, test again. Now that it's SQL 2005, move it to the final destination.

rspinelli682 -> RE: upgrade DATABASE from SQL 2000 to SQL2005 (9/17/2008 9:20:11 AM)
Looks like Brian Mason did this: http://www.myitforum.com/forums/m_129606/mpage_1/key_sql%252C2005/tm.htm#155415

joemonkey -> RE: upgrade DATABASE from SQL 2000 to SQL2005 (9/17/2008 11:42:30 AM)
I've done it too, but it's been a while. Just make sure the SQL 2005 box is 32 bit and that it was installed with default instance name.

Page: [1]

Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.3515625