What do I need to know when switching from MS SQL server to MySQL?

Question

I am trying to specialize in MS SQL server technologies, but my work has required me to understand more MySQL recently. Should any MS SQL database administrator or developer have to do this, and if so, what were their biggest problems? At the moment for me:

• Lack of a decent IDE
• There are no simple ETL tools like ssis

Answer 1

The biggest difference between the two technologies, in my opinion, is that the database engines under the hood are completely different.

, , , SQL Server, MySQL.

SQL Server, MySQL, , MySQL, INODB MyIsam ..

, , , .. , .., . T-SQL , MySQL .

GUI, Navicat, , SQL Server Management Studio (SSMS) .

, ETL, SSIS, MySQL, . Microsoft SQL Server , , Reporting Services, Analysis Services, SSIS Notification Services ..

, . - - .

,

Answer 2

IDE MySQL, MySQL Workbench.

, , MSSql MySQL, - autocommit.

MySQL 5.0 MSSql 2005 ( ...)

, MySQl...

Answer 3

, , MySql UNIQUEIDENTIFIER. , .

MySql, , .