SQL Server Migration Checklist

Are you thinking about migrating your SQL Server infrastructure?

The following are some of the SQL Server components that you will need to keep in mind to ensure that your migration between SQL Servers goes smoothly;

• Data files 
• Database objects 
• Logins
• Linked Servers
• System DSNs and Drivers
• Extended stored procedures
• Configuration settings 
• Security settings 
• SQL Server Agent jobs 
• SQL Server Integration Services (SSIS) packages 
• Maintenance Plans
• User-Defined error messages

If you’re migrating to a newer version of SQL Server, ensure that you first run the appropriate upgrade advisor to alert you to any potential issues that you may encounter between SQL editions, and always verify that your business applications are supported by your vendors at that database level otherwise you may risk voiding your support agreements!

For more information on this, check out our database consolidation and migration services!