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: 882 times
Last Updated: Nov 07, 2009 at 10:12 AM
Changing values in a view
How to count where distinct?
Extraction of SQL data to a relational table
how to backup a database in mysql server 5.0
Trigger for insert,update,delete to copy a table data from one databse to another present in different server location
Is there a difference between MySQL replication and SQL replication?
writing a generalised sql query
How to select rows based on values from other table?
Does DTS export destination database need to be installed?
How to select in a n-n ids structure with multiple AND?