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: 761 times
Last Updated: Nov 07 '09 at 10:12 AM
Setting value of a column based on criteria from another
log shipping with mysql
sql connection from a php page
When using a static column with SELECT, why can't I access that column from WHERE clause?
How to import data from Excel file on local machine to Sql Server using Query
Posible Keys in DB
How to create a database with differing form responses
ssis package to import date from LINUX Box to SQL Server2008
Naming conventions - MySQL
MYSQL Trimming Data until it hits a special character