Can we copy tables from MSSQL to MySQL?

Hi, I was wondering if we can use HeidiSQL to copy tables from a MSSQL database to a MySQL database? When copying across two different servers HeidiSQL seems to wanna use MSSQL compatible syntax for the passed MySQL commands.

I have tried MySQL Workbench, DBeaver, Valentina Studio, Microsoft SQL Server Import Export Data, and a thing called Data Loader. It either isn't supported, crashes the software, or just doesn't use a cross compatible format.

CSV just doesn't contain all that useful structural column data.

Any tips?

Hello this is Gulshan Negi Well, I did a search about it on Google and I found that to copy tables from MSSQL to MySQL using HeidiSQL, you can follow some steps which are listed below:

1. Connect to the MSSQL database server using HeidiSQL.
2. Choose the database with the tables you want to copy.
3. Select "Export database as SQL" by right-clicking on the tables you want to copy.
4. In the Commodity exchange box, select "Product to SQL record" and pick an area to save the document.
5. In the Choices tab, ensure that "Commodity table design" and "Product table information" are chosen.
6. In the Similarity tab, select "MySQL" as the objective data set framework.
7. To generate the SQL script, select "Export."
8. HeidiSQL is used to connect to the MySQL database server.
9. Choose the database where you want the table(s) to be copied.
10. Now open the SQL file.
11. Execute the SQL script in the MySQL database.
    It will help you. Thanks

Umm.. "Product to SQL record", "Commodity table design", "Product table information" those are not in HeidiSQL. Or the option to select "MySQL" as the objective data set framework.