Overview
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.
Explanation
There are very few DBAs who spend their whole life working on a single database engine. Most of us have to learn the differences and similarities between the big database players like Microsoft SQL Server, Oracle, DB2, Sybase, Informix, MySQL and PostGreSQL. The good news is that once you master two database platforms it is very easy to learn the others – just like with programming languages.
In this tutorial we will focus on the move from MySQL to SQL Server and cover:
- 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.
Additional Information
- Microsoft SQL Server vs. MySQL article on MSSQLTips
I am a technical and business professional based in Budapest, Hungary. I am working in the financial industry on the operations side, but also have test management experience in the educational software domain. My experience includes Microsoft SQL Server 2000-2012, IBM DB2 and MySQL database administration, troubleshooting, migration and development. My focus points are performance tuning and security. I am passionate about sharing my knowledge with the greater audience.
I hold MSc degree in Engineering and Management. I am married and I have a beautiful daughter.
LinkedIn account:
http://www.linkedin.com/in/nagytibor
Twitter account:
https://twitter.com/#!/tnagy_eeft
