Thank this author by sharing:
By Andrew Kuprianov,
Although there are many free tools and solutions to migrate MySQL data to MS SQL server, none of them is able to convert views. That's why everybody who wants to migrate complete database have to convert views manually. This article gives 20 tips how to modify MySQL views to make it compatible with Microsoft SQL Server. The target audience for this guide should have general database management knowledge and experience in composing SQL queries.
First, you need to get list of all views in database as follows:
SELECT table_name, view_definition
WHERE table_schema='%database name%';
And then start to modify each MS SQL view query according to the following rules:
Also you should remember that unlike MySQL MS SQL requires all selected columns in 'SELECT ... GROUP BY ...' queries to be either under 'GROUP BY' clause or in aggregation functions.
Of course, there are a lot of newances staying outside of this article, it just covers the most frequent issues in migrating views from MySQL to MS SQL. If you need a solution for complete migration of MySQL database to MS SQL server, take a look at the following tools:
how to convert mysql database in mac os to mssql in windows
The syntax of SQL queries in MS SQL and MySQL are similar but not identical. This article discovers ...
derived column --replace " with space expression error
As part of the LAMP stack, MySQL is incredibly important for providing a reliable and platform-agnos...