MySQL to SQL Server Express

Asked By Emma Marie 10 points N/A Posted on - 10/18/2013

Hello Techyv Experts,

Please provide me step by step process of guidance on simple migration from MySQL to SQL Server Express. Waiting for reply from Experts.

Thanks in Advance,

Emma Marie

• Status: Open
• Question Views: 1071
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Suggestions

Answered By Onnon herald 0 points N/A #189510

MySQL to SQL Server Express

Basic Steps for Migration of MySQL to SQL Server
To start a migration, you’ll need to perform the following high level steps:
Create a new project.
Connect to a MySQL database.
After a successful connection, MySQL schemas will appear in MySQL Metadata Explorer. Right-click objects in MySQL Metadata Explorer to perform tasks such as create reports that assess conversions to SQL Server 2008 R2 Express. You can also perform these tasks by using the toolbars and menus.
You’ll then connect to your instance of SQL Server 2008 R2 Express. After a successful connection, a hierarchy of your existing databases will appear in SQL Server Metadata Explorer. After you convert MySQL schemas to SQL Server schemas, select those converted schemas in SQL Server Metadata Explorer, and then synchronize the schemas with SQL Server.
After you synchronize converted schemas with SQL Server 2008 R2 Express, you can return to MySQL Metadata Explorer and migrate data from MySQL schemas into target database.

HI you can find more info :

https://blogs.msdn.microsoft.com/ssma/2011/02/07/mysql-to-sql-server-migration-how-to-use-ssma/

About Onnon herald

Questions
0

Answers
19

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 10/19/2013
• Question Category: Suggestions