Fixing "The Distributor has not been installed correctly" Error with AWS

When migrating a database from SQL Server on premises to AWS, you might receive this error. Learn how to get rid of it.

The DB2 Migration

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.