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?
Nov 06 '09 at 10:28 AM
Nov 07 '09 at 10:12 AM
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.
Nov 06 '09 at 11:03 AM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Nov 06 '09 at 10:28 AM
Seen: 793 times
Last Updated: Nov 07 '09 at 10:12 AM
can allow user select the column ?
Wordpress MySQL to SQL Server 2011
MySQL to MSSQL: IF(value=5,1,NULL) how to do it in MSSQL?
projection from a query
How to import bulk .log files and add a column to the table
50 to 60 million records.Hardware Config required
How to convert sql server to mysql
how to use cast,in mysql when union is used
Insert into openquery MySQL