How to Migrate MySQL Database to Microsoft SQL Server

MySQL to SQL Server Migration step by step

Created by: Bluelime Learning Solutions
Making Learning Simple

What Will I Learn?

• Install SQL Server Migration Assistant for MySQL (SSMA)
• Perform pre-migration steps
• Setup connections to source and target servers
• Create project in SSMA
• Create a report
• Validate type mappings
• Convert schema
• Perform client data migration
• Migrate schema
• Migrate data
• Perform post migration data validation

Requirements

• A computer with internet access required
• Basic knowledge of database concepts advised but not mandatory

Target audience

• Beginner database administrators
• Beginner data analyst
• Beginner business intelligence analyst
• Beginner data engineer
• Beginner data scientist