The SQL Server 2000 SP4 extended support period is ending in 9th April. If your company still have SQL Server 2000 databases you should migrate them quickly.
Don't forget that you can't migrate SQL Server 2000 databases to SQL Server 2012 in one single step. You need to add an extra step that is migrate from SQL Server 2000 to SQL Server 2005 or 2008 or 2008R2.
If you want to upgrade the full instance, remember that SQL Server 2000 instance need to be with SP4 before you start. And if you are upgrading to SQL Server 2012, in the additional step, SQL Server 2005 should be at least with SP4 and SQL Server 2008 with SP2 and SQL Server 2008R2 with SP1 or later.
In-place migration will be more complex because you may also need to migrate the operating system for supporting earlier versions of SQL Server, so I always recommend side by side migrations.
I also recommend you to visit this MSDN article before you start the migration plan.
Have a nice migration :)
No comments:
Post a Comment
Comente aqui