SQL Server Migration Toolkit
Scripts that automate migrating SQL Server logins, jobs, credentials, certificates, and database configuration between instances during upgrades and cloud migrations.
Repository link coming soon
Problem Statement
Migrating a database to a new instance - whether for an upgrade, a hardware refresh, or a move to AWS/Azure - involves more than copying the data. Logins, SQL Agent jobs, linked servers, credentials, and certificates all need to move too, and missing one quietly breaks applications after cutover. This toolkit scripts out and replays that supporting configuration so it isn't handled ad hoc during a migration window.
Architecture
Technologies Used
- T-SQL scripts to script out logins, jobs, and configuration in a replayable format.
- PowerShell for orchestrating export/import steps and validation checks.
- Experience applying this during migrations onto AWS FSx, AWS RDS, and Azure SQL.
Screenshots
Screenshots coming soon.
Lessons Learned
Most migration problems I've seen were not about the data itself - they were about forgotten dependencies: a login mapped to the wrong SID, a job pointing at a decommissioned linked server, a certificate that didn't get carried over. Treating configuration migration as its own scripted, checklist-driven step (rather than "we'll remember it") cut down on post-cutover surprises.