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

918 views Asked by At

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?

2

There are 2 answers

0
Craig Gers On

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.

0
Craig Gers On

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.

enter image description here