mssqltips logo

Planning your migration from MySQL to SQL Server



By:

Overview

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

Explanation

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 (*).

*Name
*Email
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.






download





get free sql tips

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.



Learn more about SQL Server tools