Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Migrating from mysql to mssql

 
Manoj Maniraj
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

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

thanks..
 
Jan Cumps
Bartender
Posts: 2599
12
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Manoj Maniraj
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2599
12
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic