Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Migrate Sql 2000 Enterprice SP3 To SQL 2008 Std, Side By Side Expand / Collapse
Author
Message
Posted Tuesday, March 23, 2010 10:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, December 11, 2014 5:08 AM
Points: 35, Visits: 260
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 .
My main issue right now is, do I need SP4 first..

/Michael

Post #888326
Posted Tuesday, October 16, 2012 8:11 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, October 27, 2014 5:37 AM
Points: 28, Visits: 164
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
Posted Tuesday, October 16, 2012 8:20 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Thursday, December 11, 2014 12:22 PM
Points: 1,446, Visits: 3,232
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
Posted Thursday, October 18, 2012 4:54 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, October 27, 2014 5:37 AM
Points: 28, Visits: 164
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
Posted Friday, October 19, 2012 4:13 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, December 11, 2014 5:08 AM
Points: 35, Visits: 260
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
Posted Friday, October 19, 2012 5:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, October 27, 2014 5:37 AM
Points: 28, Visits: 164
Thanks for the reply, Michael.
That is very reassuring.
Cheers
Glenn
Post #1374755
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse