File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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: 2491
    
    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: 2491
    
    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.
 
jQuery in Action, 2nd edition
 
subject: Migrating from mysql to mssql
 
Similar Threads
how to connect servlet with mssql
how to connect with mssql
Migrating from Ms Sql Server(T-SQL) to Oracle database 10g(PL-SQL)
why not more database?
How would you create a Content Server/Provider using J2EE