Planning your migration from MySQL to SQL Server



Migration projects are always complex assignments. They require careful planning, proper execution and often on the fly troubleshooting.


The migration starts with planning. First of all you have to get familiar with MS SQL Server to utilitize its features. At first glance it will seem unusual that it has only one storage engine although it is ACID compliant.

You have to consider the following database migration steps:

  • Choose your target SQL Server edition and install it.
  • Decide about the mapping of MySQL databases to MS SQL databases. Maybe you would like to consolidate more databases into one database under different schemas.
  • Make a conversion plan for your database objects (tables, indexes, views, procedures, functions, constrains, triggers).
  • Create a data type mapping plan.
  • Check the syntax of your procedures and functions.
  • Perform migration: convert your database and migrate data.
  • Configure your applications to use the SQL Server database.

Additional Information

Last Update: 5/27/2011

More SQL Server Solutions

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

Email me updates

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


get free sql tips
agree to terms

Learn more about SQL Server tools