Microsoft SQL Server version migrations are one of the more difficult activities for a DBA to execute, yet they are a very common change to the infrastructure. Databases eventually have to be migrated to another location, perhaps even a clustered instance. DBAs are tasked with making the database migration succeed despite all of the complexities and failures that are possible. The concerns around database migration can be alleviated through an automated process which results in an infrastructure that will be easier for DBA teams to manage, more compliant, easier to document, faster in turnaround time for changes, and more reliable with less downtime.
Posted July 15, 2008