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.