Migrating MySQL to SQL Server

Sign in to queue

Description

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

 

 

Embed

Download

Download this episode

The Discussion

Add Your 2 Cents