Are you ready to migrate?
The next release of SQL Server is drawing closer to release. My mind naturally turns towards upgrades.
The SQL Server migration tools of the last couple releases have made the transition much easier to make. The database files themselves were much easier to handle than modifications to Reporting Services or Integration Services.
For those still running on SQL Server 2000, the effort for migration is going to be much higher due to the greater differences in the features from that release to any release following.
Even if you are prepared to upgrade your software, are you going to have to replace your hardware? If you don’t replace it, how are you going to deal with backups you have prior to the upgrade? You still need to have an instance of the previous version of SQL Server capable of restoring your older backups (if they are still significant in your disaster recovery policy).
Are you even thinking about upgrades yet? Are there features in the next release that are a must have? Do you think you might only do partial upgrades singling out one or more features of SSRS, SSIS, SSAS, or the data engine?
Drop me a note with your thoughts at btaylor@sswug.org.
Cheers,
Ben
$$SWYNK$$
Featured White Paper(s)
How to Implement an Effective SharePoint Governance Plan
Written by AvePoint
Moving past the "what" and "why" of governance, an even… (read more)
Featured Script
sp_random
Random number generator code snippet…. (read more)