December 16, 2011 at 8:18 am
Hello all,
Is it possible to migrate from SQL standard edition to SQL 2008 web edition, without having 2005 never used/installed in the system. In the DB there are stored procedures and tables.
How do we come across log shipping when there is downtime? what is the best way to do this?
Is mirroring possible from SQL 2000 to 2008?
I have gone through lot of google links but dint come across a perfect method for this. Did someone ever performed this type of migration ?
If so can you please post scripts for this. Thanks any help is appreciated.
December 16, 2011 at 7:24 pm
pk2011 (12/16/2011)
Hello all,Is it possible to migrate from SQL standard edition to SQL 2008 web edition, without having 2005 never used/installed in the system. In the DB there are stored procedures and tables.
How do we come across log shipping when there is downtime? what is the best way to do this?
Is mirroring possible from SQL 2000 to 2008?
I have gone through lot of google links but dint come across a perfect method for this. Did someone ever performed this type of migration ?
If so can you please post scripts for this. Thanks any help is appreciated.
Migrate yes, upgrade no: http://msdn.microsoft.com/en-us/library/ms143393.aspx
You can install a SQL2008 instance on the same where your 2000 instance reside but ideally you would have a second server available. Either way you can migrate your SQL2000 databases to theSQL2008 instance (which upgrades the database in the process) using any number of methods. I like the backup/restore method for migrating but you can also use the Copy Database Wizard or the detach/attach method.
Mirroring is not a feature in SQL2000 so that is not an option in your scenario.
It is worth your time to read this Whitepaper in its entirety: http://download.microsoft.com/download/2/0/B/20B90384-F3FE-4331-AA12-FD58E6AB66C2/SQL%20Server%202000%20to%202008%20Upgrade%20White%20Paper.docx.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply