• Post Reply Bookmark Topic Watch Topic
  • New Topic

Migrating from mysql to mssql  RSS feed

 
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..
 
Bartender
Posts: 2633
17
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: 2633
17
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
Boost this thread!