Category Archives: Migration

Azure Data Migration Service Review

Posted on December 22, 2017 by ConfigMgrMVP

The Data Migration Service (DMS) is a new Azure service still in preview. DMS will help you migrate existing on-premises SQL Server, Oracle, and MySQL databases to Azure SQL Database, Azure SQL Database Managed Instance or SQL Server on an … Continue reading →

Posted in Azure SQL Server, Migration, SQL Server 2016 | Leave a comment

Azure SQL Migration Tools

Posted on March 14, 2017 by ConfigMgrMVP

In preparing a presentation for data migration to Azure, thought I’d share some of my research. There are other methods not specified here, but this should be a good start! Each toolset includes notes about that tool, and where to … Continue reading →

Posted in Azure SQL Server, Migration, SQL Server | Tagged , | 1 Comment

SQL Server Database Migration Checklist

Posted on May 2, 2016 by ConfigMgrMVP

This guide is meant to provide general recommendations for migrating SQL Server databases from one server to another. Always test database migrations (and subsequent application connectivity) in a lab environment prior to the actual migration. Note: Server name ‘SOURCE’ is … Continue reading →

Posted in Migration, SQL Server, SQL Server 2012, SQL Server 2014 | 3 Comments