x
login about faq Site discussion (meta-askssc)

Importing mySQL into MS-SQL...

Any thoughts on where to begin with something like this? It may become a project for me soon, and I am wondering where a good starting point for research would be. I know I can always "google", but I figure someone on here has most likely ran across this before.

more ▼

asked May 02 '11 at 06:05 AM in Default

xypher gravatar image

xypher
416 2 6 9

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Good news. Microsoft just released version 5 of the SQL Server Migration Assistant for migrating from mySQL

http://blogs.technet.com/b/dataplatforminsider/archive/2011/04/28/sql-server-migration-assistant-v5-0-is-now-available.aspx

update...

Bill Ramos covers managing data type conversions with the Migration Assistant when migrating a mySQL database to SQL Server - http://blogs.msdn.com/b/ssma/archive/2011/04/29/converting-from-mysql-to-sql-server-working-with-data-types.aspx

more ▼

answered May 02 '11 at 06:13 AM

KenJ gravatar image

KenJ
12.4k 2 10

This is very good news! Thanks for the direction!

May 02 '11 at 06:50 PM xypher
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x394
x52

asked: May 02 '11 at 06:05 AM

Seen: 424 times

Last Updated: May 02 '11 at 06:05 AM

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.