Cross Platform Migration

Migration Help

Azure SQL Migrations using Azure Data Studio

This article looks at database migration with the Azure Data Studio extension, making it easy to move databases from an on premises SQL Server to one in Azure.

SQL Migrator (Part 1)

Read about a free automated Upgrade\Migration Tool for SQL Server.

Paying Attention to Estimates

Aaron Bertrand follows up on a recent post about DATEFROMPARTS() with a deeper look into the estimates and potential mitigation techniques.

Fix Orphan Users for Instance Migration

Use provided script to fix orphan users for all databases after Instance Migration. Tested on SQL 2014.

SQL Server Migration

Some SQL migrations require keeping the server name, instance name, IP, and port number. Geoff Ruble shares some notes on his recent experience with a SQL Server migration.

Generate RESTORE DATABASE Script without Using CMDSHELL

Use this script to generate RESTORE DATABASE scripts for all .BAK backup files from backup location during Instance or Database migration.

Migrating SQL Server Databases to Windows Azure by Leveraging BACPAC Files

Marcin Policht shows you how to migrate on-premise data that is already cloud-compliant to Windows Azure SQL Databases by converting it into a BACPAC formatted file.

SQL Server 2014 Hybrid Cloud Scenarios: Migrating On-Premises SQL Server to Windows Azure Virtual Machines

This article describes how to use the new wizards in SQL Server Management studio to get access to Windows Azure and then create and configure your VM.