Skip to main content This browser is no longer supported. Show Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Migration guide: MySQL to Azure SQL Database
In this articleApplies to: In this guide, you learn how to migrate your MySQL database to an Azure SQL database by using SQL Server Migration Assistant for MySQL (SSMA for MySQL). For other migration guides, see Azure Database Migration Guide. PrerequisitesBefore you begin migrating your MySQL database to a SQL database, do the following:
Pre-migrationAfter you've met the prerequisites, you're ready to discover the topology of your environment and assess the feasibility of your Azure cloud migration. AssessUse SQL Server Migration Assistant (SSMA) for MySQL to review database objects and data, and assess databases for migration. To create an assessment, do the following:
Validate the data typesValidate the default data type mappings and change them based on requirements, if necessary. To do so:
Convert the schemaTo convert the schema, do the following:
Migrate the databasesAfter you've assessed your databases and addressed any discrepancies, you can run the migration process. Migration involves two steps: publishing the schema and migrating the data. To publish the schema and migrate the data, do the following:
Post-migrationAfter you've successfully completed the migration stage, you need to complete a series of post-migration tasks to ensure that everything is functioning as smoothly and efficiently as possible. Remediate applicationsAfter the data is migrated to the target environment, all the applications that formerly consumed the source need to start consuming the target. Accomplishing this will in some cases require changes to the applications. Perform testsThe test approach to database migration consists of the following activities:
OptimizeThe post-migration phase is crucial for reconciling any data accuracy issues, verifying completeness, and addressing performance issues with the workload. For more information about these issues and the steps to mitigate them, see the Post-migration validation and optimization guide. Migration assetsFor more assistance with completing this migration scenario, see the following resource. It was developed in support of a real-world migration project engagement.
The Data SQL Engineering team developed these resources. This team's core charter is to unblock and accelerate complex modernization for data platform migration projects to Microsoft's Azure data platform. Next steps
FeedbackSubmit and view feedback for |