CODEWITHSUNDEEP
mysqlsql-servermigration
Jeremy Logan
Jeremy Logan

Reputation: 47514

Tools to migrate table structure from MySQL to SQLServer?

Like the title says, I just need something to migrate a set of tables from MySQL to SQLServer. I know it can't be 1-to-1, but if it'll get me as close as possible, I'll be happy.

Upvotes: 0

Views: 2066

Answers (3)

Jeremy Logan
Jeremy Logan

Reputation: 47514

Turns out Microsoft offers a tool called "SQL Server Migration Assistant for MySQL". It's available for download free of charge (though you have to give them your name and stuff to register it). You may have to do a little tweaking (I did), but it'll get you 99% of the way there.

Upvotes: 1

Robin Rizvi
Robin Rizvi

Reputation: 5183

The easy way to do this would be:

First you have to download the Mysql connector for dotnet from here. Then make sure you install it.

The second step would be to download Mysql GUI tools from here. Install the GUI tools.

Then open Mysql Workbench or Mysql Administrator and just find the option to "Backup" a database/schema. This backup will create sql scripts which you will save on your disk.

*After you have got the script there are multiple ways to do it. You can import that sql script file through command line through the sqlcmd command or you can enter it directly in visual studio or you can use any T-sql editor/parser/client to do the job.

Next you download sqlserver management studio from here. Then you can create a new database from the left pane and then right-click on that new database and goto Tasks and then Import and then a wizard will open. From there (if you have installed the ODBC/NET connector) you will be asked for a DataSource and then you can choose MYsql provider from that list and you can move forward as the wizard directs.

That in-short was a visual/easy way to do the thing.

*One more thing to add for the direct method of migrating MYSQL to MSSQL is mentioned above, for a ODBC based direct migration method view this or Download Microsoft SQL Server Migration Assistant for MySQL v1.0

  • The vice-versa of this process i.e for the migration of MSSQL to MYSQL use Mysql WORKBENCH view this

Upvotes: 0

vmvadivel
vmvadivel

Reputation: 1067

Check out http://www.swissql.com/ which can help you out in this.

Extract from that site:

SwisSQL is a automated database migration solution that has more than 300+ customers. SwisSQL offers productive database migration tools for stored procedure migration, SQL migration, and data migration. It offers comprehensive migration solution across a wide range of databases such as Oracle, SQL Server, IBM DB2 UDB, Teradata, Netezza, Sybase ASE, MySQL, Informix, and PostgreSQL.

Approx 6 yrs back I wrote a short review about this tool here - http://vadivel.blogspot.com/2006/05/product-review-swissql-sqlone-console.html

Upvotes: 0

Related Questions