question

HakanD avatar image
HakanD asked

How can I transfer mysql tables to MS-SQL?

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?

mysqldata-import
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
RickD avatar image
RickD answered

First, set up a linked server.

http://forums.mysql.com/read.php?60,123221,123221#msg-123221

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.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.