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, 2009 at 10:28 AM
Nov 07, 2009 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, 2009 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, 2009 at 10:28 AM
Seen: 950 times
Last Updated: Nov 07, 2009 at 10:12 AM
Need career advice on returning to IT
Which among row level and statement level triggers is effective
importing and presenting files with variable number of columns
Need your help with a query
how to create a database
MySQL query performance
log shipping with mysql
Update a table from another table
I want to delete total tables at time ?
Import from an Excel spreadsheet