Skip to content

Instantly share code, notes, and snippets.

@ajace

ajace/SSMA

Created June 21, 2017 20:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ajace/f1fdc9fe48ce1c6a7504605782c659e7 to your computer and use it in GitHub Desktop.
Save ajace/f1fdc9fe48ce1c6a7504605782c659e7 to your computer and use it in GitHub Desktop.
Download ZIP
SSMA migration from MySql to SQL Server
Raw
SSMA
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