SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
Michael Torsson
Michael Torsson
SSC Veteran
SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)

Group: General Forum Members
Points: 223 Visits: 316
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
glennhill
glennhill
SSC-Enthusiastic
SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)

Group: General Forum Members
Points: 142 Visits: 171
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
sturner
sturner
SSCertifiable
SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)

Group: General Forum Members
Points: 5286 Visits: 3259
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.
glennhill
glennhill
SSC-Enthusiastic
SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)

Group: General Forum Members
Points: 142 Visits: 171
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.
Michael Torsson
Michael Torsson
SSC Veteran
SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)

Group: General Forum Members
Points: 223 Visits: 316
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
glennhill
glennhill
SSC-Enthusiastic
SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)SSC-Enthusiastic (142 reputation)

Group: General Forum Members
Points: 142 Visits: 171
Thanks for the reply, Michael.
That is very reassuring.
Cheers
Glenn
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search