How can I transfer mysql tables to MS-SQL?

Question

I have a mysql database.I would like to transfer all data to a new database in MS-SQL. Can you give me information about how to do this?

Answer 1

0

First, set up a linked server.

Once this has been completed, you can simply eith do:

Select * into <newtable> from <mysqltable>

Or you can create a project in SSIS and pull data and objects across that way.

answered Nov 06 '09 at 11:03 AM

RickD
1.6k ● 1 ● 1 ● 4

Just to expand a bit on that the syntax is likely to look like: Select * into newtable from mysql_alias.mysqltable

Nov 07 '09 at 10:13 AM Kristen ♦

(comments are locked)