Database Migration: MySQL To Microsoft SQL Server
Learn how to migrate MySQL database to SQL Server using the free supported tool, SQL Server Migration Assistant (SSMA) from Microsoft. Simplify the migration process, automate assessment analysis, schema conversion, data migration, and testing. Convert database objects, review and compare them to identify potential problems. Complete post-migration tasks for smooth functioning. Ideal for beginners in database migration.
What you’ll learn
- Install SQL Server
- Install MySQL
- Install SQL Server Migration Assistant for MySQL (SSMA for MySQL)
- Perform pre-migration assessment
- Validate type mappings
- Convert database schema
- Perform post migration data validation
In this course, you will learn how to migrate MySQL database to SQL Server using the SQL Server Migration Assistant (SSMA) .
SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from MySQL to SQL Server. Azure SQL Database and Azure SQL Database Managed Instance. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing.
By using SSMA for MySQL, you can review database objects and data and assess databases for migration.
Learn to convert database objects by taking the object definitions from MySQL, converts them to similar SQL Server objects, and then loads this information into the SSMA for MySQL metadata. After the conversion finishes, compare and review the converted objects to the original objects to identify potential problems and address them based on the recommendations.
When you’ve successfully completed the migration stage, you will need to complete a series of post-migration tasks to ensure that everything is functioning as smoothly and efficiently as possible.
After you’ve migrated the data to the target environment, any application that formerly consumed the source need to start consuming the target. Accomplishing this task will require changes to the applications in some cases.
Who this course is for:
- Beginners to Database Migration
User Reviews
Be the first to review “Database Migration: MySQL To Microsoft SQL Server”
You must be logged in to post a review.
There are no reviews yet.