Skip to content

Instantly share code, notes, and snippets.

@ajace
Created June 21, 2017 20:54
Show Gist options
  • Save ajace/f1fdc9fe48ce1c6a7504605782c659e7 to your computer and use it in GitHub Desktop.
Save ajace/f1fdc9fe48ce1c6a7504605782c659e7 to your computer and use it in GitHub Desktop.
SSMA migration from MySql to SQL Server
SSMA
General Solutions for migration
1. Update Mysql DB
2. SSMA > Table > Refresh from DB
3. SSMA > Table > Convert Schema
4. SSMA > SQL Server Table > Synchronize with Database
5. SSMA > MySQL Table > Migrate Data
6. Apply previous MySQL logic in MSSQL equivalent (most should be possible) in separate query
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment