Is there a way to import data from an SQL file to Microsoft SQL Server Express Edition on Linux?

Question

Ok, so I have a .sql file that i exported from MySQL Workbench and now I want to import it into Microsoft SQL Server Express Edition for linux, and I'm not sure how I should go about doing that, any suggestions?

Answer 1

If you export the data into csv or some other delimited format, I think you will be more successful.

If able to connect to your db in Linux with version of SQL Server Management Studio, there is an option - Right click on your DB in SSMS, Select Tasks -> Tasks -> Import Flat File. I am using SQL Server Management Studio 15.0.18330.0. I hope this helps.

Answer 2

If your Linux SQL database has sight of your MySQL database and you have an ODBC driver loaded for my SQL (on Linux), there may be another, importing it directly from MySQL, without going through an intermediary step.