question

xypher avatar image
xypher asked

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.
sql-server-2008-r2mysql
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
KenJ avatar image
KenJ answered
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][1] **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][2] [1]: http://blogs.technet.com/b/dataplatforminsider/archive/2011/04/28/sql-server-migration-assistant-v5-0-is-now-available.aspx [2]: http://blogs.msdn.com/b/ssma/archive/2011/04/29/converting-from-mysql-to-sql-server-working-with-data-types.aspx
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

xypher avatar image xypher commented ·
This is very good news! Thanks for the direction!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.