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.
Last Update: 2011-06-14
About the author
View all my tips