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: 925 times
Last Updated: Nov 07, 2009 at 10:12 AM
Need Help with hour averages
sql server function to mysql with same logic
Is SQL Server catching up with Oracle or would it be a good career decision to develop in both?
Best MySQL practice to insert a record if it does not already exist, and return its id
How to port the Mysql server table into MS SQL server
My SQL DB how to import them?
duplicate value unable to insert in int column
formatting the cell values
Problem with Master/Detail script displaying the Master Record with every Detail Record.
Split data from mysql using json