Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


MySQL to SQL Server Conversion Tutorial

By:   |   Read Comments   |   Related Tips: 1 | 2 | 3 | More > Upgrades and Migrations

ALERT: Did you know 66% of DBAs say their workload is increasing! - Click here to learn more.

Read the tutorial!

From time to time companies initiate projects to move from one database platform to another. Such migrations can involve switching between database engines such as SQL Server, MySQL, Oracle, Sybase, DB2, etc. In this tutorial we will explore the differences between MySQL and Microsoft SQL Server and the key components that you should be aware of when making that move. 

Here is the tutorial outline:

  • a possible migration plan what you can fine tune as needed
  • MS SQL Server editions
  • data type and system function differences
  • how to migrate your data
  • transactional and locking differences
  • backup and recovery options
  • database maintenance and tuning

The tutorial is designed for DBAs who are experienced with MySQL and plan to start using MS SQL Server.

In this tutorial we will focus on the most important features, but I will also try to provide links for more detailed resources on each topic.

Read the tutorial!

Last Update:

next webcast button

next tip button

About the author
MSSQLTips author Tibor Nagy Tibor Nagy is a SQL Server professional in the financial industry with experience in SQL 2000-2012, DB2 and MySQL.

View all my tips

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.


Learn more about SQL Server tools