Want to transfer data from multiple similar MySQL tables to 1 SQL Server table?
Using DBCopier, a native GUI tool, you can transfer data from multiple similar MySQL tables to single SQL Server table easily and fast, just a few mouse clicks.
Support Windows, Linux, macOS
Here you can download and install DBCopier.
Transfer data from multiple similar MySQL tables To same SQL Server table
Choose source MySQL database and logon.
Choose target SQL Server database and logon.
Click “Convert Similar Tables” at task dialog.
then show the wizard.
1. Select similar tables.
2. Select a destination table and config fields.
3. Preview data.
4. Import.
You can schedule and automate this converting task by:
1) Save session and create .bat file.
More about DBCopier – the tool to copy MySQL (MariaDB, Percona) data to SQL Server