Migrate Sql 2000 Enterprice SP3 To SQL 2008 Std, Side By Side

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Migrate Sql 2000 Enterprice SP3 To SQL 2008...

Migrate Sql 2000 Enterprice SP3 To SQL 2008 Std, Side By Side

Rate Topic

Display Mode

Topic Options

Author

Message

Michael Torsson

Posted Tuesday, March 23, 2010 10:44 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, October 19, 2012 8:00 AM
Points: 29, Visits: 192

Hi

I am starting "the" upgrade and have found out that the server is only on SP3. I have only one migrationwindow :-( as it looks now.
I am only using databases and DTS.
I know the best practice says SP4, but has anyone succeeded migrating on SP3?
My first thought is Backup/restore, I believe that that is the best solution.
I will run the upgrade wizard for SQL 2008 next week. I have read in a couple of threads that you should also run the upgrade wizard for 2005 as well, is that necessary?

I will also dig in the the massive dokumentation when I get my hands on the server.
Does anyone have any information/suggestions what not to do or do Smile

.
My main issue right now is, do I need SP4 first..

/Michael

Post #888326

glennhill

Posted Tuesday, October 16, 2012 8:11 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 1:46 AM
Points: 25, Visits: 134

Michael

Did you ever get an answer to this?

I am in a similar postion. We have a SQL2000 installation to SP3a.

I want to do a side-by-side upgraded to SQL2008R2.

I can't see why I should I have to upgrade to SP4 before doing this. I know it works from SP3a but are there any caveats? I suspect the SP3a to SP4 upgrade makes little difference to the databases - just the software, but cannot find anything conclusive to confirm.

Any advice that you have would be appreciated.

Thanks
Glenn

Post #1373291

sturner

Posted Tuesday, October 16, 2012 8:20 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:27 AM
Points: 1,314, Visits: 2,882

Guys, you should go ahead and perform a trial upgrade so you know where you stand.

If it were me, I'd try restoring a backup to the newer version and run some tests. You might even try restoring to a 2005 edition first.

The probability of survival is inversely proportional to the angle of arrival.

Post #1373303

glennhill

Posted Thursday, October 18, 2012 4:54 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 1:46 AM
Points: 25, Visits: 134

I think I might have answered my own question.

Neither of the following two Microsoft articles:-

"How to: Upgrade a Database Using Detach and Attach (Transact-SQL)"
http://msdn.microsoft.com/en-us/library/ms189625(v=sql.105).aspx

"How to: Restore a Database Backup (SQL Server Management Studio)"
http://technet.microsoft.com/en-us/library/ms177429(v=sql.105).aspx

make any reference to Service Pack level - suggesting to me that SP4 is NOT a requirement for upgrading a database from SQL2000 to SQL2008R2.

Post #1374268

Michael Torsson

Posted Friday, October 19, 2012 4:13 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, October 19, 2012 8:00 AM
Points: 29, Visits: 192

Hi

I did not get into trouble, it went very smood. I did a backup/restore and changed all the compability levels and started monitoring the performance to find the bottlenecks.

I didn't find any function that I used that was dependent on SP4.

Good luck the the migration

Post #1374715

glennhill

Posted Friday, October 19, 2012 5:40 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 1:46 AM
Points: 25, Visits: 134

Thanks for the reply, Michael.
That is very reassuring.
Cheers
Glenn

Post #1374755

« Prev Topic | Next Topic »

Permissions