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
Just to expand a bit on that the syntax is likely to look like: Select * into newtable from mysql_alias.mysqltable
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
asked: Nov 06 '09 at 10:28 AM
Seen: 549 times
Last Updated: Nov 07 '09 at 10:12 AM
Is there a difference between MySQL replication and SQL replication?
Log in Session for billing purpose.
SELECT * FROM OPENROWSET ('MSDASQL')
Does DTS export destination database need to be installed?
How to count where distinct?
Need Help with hour averages
Analysis DBCC CHECKDB output
Is SQL Server catching up with Oracle or would it be a good career decision to develop in both?
writing a generalised sql query
My SQL DB how to import them?
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.