MySQL to SQL Server Express

Asked By 10 points N/A Posted on -
qa-featured

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

SHARE
Answered By 0 points N/A #189510

MySQL to SQL Server Express

qa-featured

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 :

http://blogs.msdn.com/b/ssma/archive/2011/02/07/mysql-to-sql-server-migration-how-to-use-ssma.aspx

Login/Register to Answer

Related Questions