upgrade DATABASE from SQL 2000 to SQL2005

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

upgrade DATABASE from SQL 2000 to SQL2005

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> upgrade DATABASE from SQL 2000 to SQL2005

Page: [1]

Message

<< Older Topic Newer Topic >>

upgrade DATABASE from SQL 2000 to SQL2005 - 9/16/2008 6:00:50 AM

joeltje

Posts: 14
Score: -4
Joined: 9/16/2008
Status: offline

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?

Post #: 1

RE: upgrade DATABASE from SQL 2000 to SQL2005 - 9/17/2008 5:21:43 AM

iglatz

Posts: 848
Score: 23
Joined: 9/21/2001
From: Erding, Bavaria - Germany
Status: offline

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.

(in reply to joeltje)

Post #: 2

RE: upgrade DATABASE from SQL 2000 to SQL2005 - 9/17/2008 8:51:34 AM

skissinger

Posts: 2115
Score: 134
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline

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.

_____________________________

mofmaster@smsexpert.com (version 2007) | http://www.smsexpert.com | http://www.sccmexpert.com
My Blog
Microsoft MVP - ConfigMgr

(in reply to iglatz)

Post #: 3

RE: upgrade DATABASE from SQL 2000 to SQL2005 - 9/17/2008 9:20:11 AM

rspinelli682

Posts: 266
Score: 12
Joined: 1/24/2006
Status: offline

Looks like Brian Mason did this:

http://www.myitforum.com/forums/m_129606/mpage_1/key_sql%252C2005/tm.htm#155415

(in reply to skissinger)

Post #: 4

RE: upgrade DATABASE from SQL 2000 to SQL2005 - 9/17/2008 11:42:30 AM

joemonkey

Posts: 202
Score: 2
Joined: 2/28/2007
From: Kentucky
Status: offline

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.