Question: how to import mysql data into sql server?
Answer: Open your ODBC Data Source Administrator from the Control Panel -> Administrative Tools. ...  In the next dialog enter your MySQL server connection details, test it and click OK. Set SQL_MODE to ANSI_QUOTES on MySQL Server. Launch the SQL Server Management Studio. Create a new database or use an existing database.