wood burning stoves*
The moose likes JDBC and the fly likes Migrating from mysql to mssql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Migrating from mysql to mssql" Watch "Migrating from mysql to mssql" New topic
Author

Migrating from mysql to mssql

Manoj Maniraj
Ranch Hand

Joined: Mar 25, 2009
Posts: 38
Hi all,

Which is the best tool for migrating the MySql database to MSSQl database? Please provide some links.

thanks..


http://manojmaniraj.blogspot.com
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2497
    
    8

Which is the best tool for migrating the MySql database to MSSQl database?
Both MySQL and SQLServer have migration tools.
MySQL: MySQL Migration Toolkit
SQLServer: DTS (Data Transformation Services)
Please provide some links.
MySQL Migration Toolkit
Data Transformation Services


OCUP UML fundamental and ITIL foundation
youtube channel
Manoj Maniraj
Ranch Hand

Joined: Mar 25, 2009
Posts: 38
Thanks Jan for your response.

Will DTS or SSIS create the mysql tables in MSSQL with all the relationship between the tables?
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2497
    
    8

Will DTS or SSIS create the mysql tables in MSSQL
Yes
with all the relationship between the tables?
Between a MySQL and a SQLServer db? Not that I know.
 
Don't get me started about those stupid light bulbs.
 
subject: Migrating from mysql to mssql