CODEWITHSUNDEEP
mysqlsql-server
teddy
teddy

Reputation: 197

Move data from MS SQL to MySQL

I have one MS SQL DB (very big) and MySQL. I must move data from MS SQL DB to MySQL by doing SQL. It mean that source data & destination data arenot same structure. When source data is updated, the updating is reflected into destionation. Please give me an advice which is the suitable way?

  1. Using SSIS
  2. Using store procedure & write my own script
  3. Other way.

Any advice is highly appreciated.

Upvotes: 3

Views: 9771

Answers (2)

Kuzgun
Kuzgun

Reputation: 4737

Cleanest way will be using stored procedures since it is not a complete immigration. By doing this you will have everything under control. MSSQL has a nice feature linked servers, a bit slow but worths it in most of cases. You can find instructions here: http://www.sqlservercentral.com/Forums/Topic340912-146-1.aspx

An example:

UPDATE your_mysql_database.dbo.your_mysql_table SET col1=...

Upvotes: 1

karthik
karthik

Reputation: 17852

To migrate from MSSQL to MYSQL, Please use MYSQL Migration Toolkit

To download and use the MYSQL Migration Toolkit, Please use the following link http://dev.mysql.com/downloads/gui-tools/5.0.html

The MySQL Workbench Migration Wizard is designed to save DBA and developer time by providing visual, point and click ease of use around all phases of configuring and managing a complex migration process:

     Database migrations - enables migrations from Microsoft SQL Server, PostgreSQL, Sybase ASE, Sybase SQL Anywhere, SQLite, and more.
     Migration project management - allows migrations to be configured, copied, edited, executed and scheduled.
     Source and Target selection - allows users to define specific data sources and to analyze source data in advance of the migration.
     Object migration - allows users to select objects to migrate, assign source to target mappings where needed, edit migration scripts and create the target schema.
     Data migration - allows users to map source and target data and data types, set up data transfer and assign post data transfer events where needed.
     Version Upgrades - using migration users can easily move databases off older MySQL versions to the latest.

Upvotes: 0

Related Questions