Migrating MySQL to SQL Server

Migrating MySQL to SQL Server using SQL Server Migration Assistant(SSMA)

Simple explanation on how to use the above tool to migrate a MySQL database to SQL Server.

Links:

Blog Post: https://pkuppan.wordpress.com/2016/01/28/migrating-a-mysql-database-to-sql-server/

Tool: https://www.microsoft.com/en-us/download/details.aspx?id=42657

Extended Properties Script:

select 'EXEC sp_dropextendedproperty
@name = ''MS_SSMA_SOURCE''
,@level0type = ''schema''
,@level0name = ' + object_schema_name(extended_properties.major_id) + '
,@level1type = ''table''
,@level1name = ' + object_name(extended_properties.major_id)
from sys.extended_properties
where extended_properties.class_desc = 'OBJECT_OR_COLUMN'
and extended_properties.minor_id = 0
and extended_properties.name = 'MS_SSMA_SOURCE'

Thank you for watching

Regards and stay techy,

Prashant