How to conquer the SQL Server 2005 migration challenge

Moving SQL Server 2005 data will be the easy part compared to the app migrations.

Microsoft SQL Server 2005
Beshef via Flickr (Creative Commons BY or BY-SA)

If you still have SQL Server 2005 anywhere in your firm, you now have four months to get a migration program going before Microsoft pulls the plug on support for the aging database. April 12 will be the last day any patches or fixes will be issued. The product will still work, it just won't be fixed if a new flaw or exploit is found. 

As we discussed when we outlined the challenges of migration, it's believed most enterprises have long since moved off the old database in favor of something newer, either on-premises or possible in the cloud. At best, SQL Server 2005 has been relegated to simple report generation on noncritical data. 

But if it hasn't, there's good news and not-so-good news. The good news is if you just have to migrate the data, and that can be done in as little as 30 minutes, so long as you don't store your data on the same server as the database app. The not so good news is if you have a lot of apps running on top of the database, your migration could take a little or a lot longer. 

To continue reading this article register now

Security vs. innovation: IT's trickiest balancing act