Merge multiple similar MySQL tables to 1 SQL Server table

by

Posted on by

Want to transfer data from multiple similar MySQL tables to 1 SQL Server table?

Try Withdata DBCopier, a MySQL to SQL Server converter for Windows, Mac, and Linux, Copy MySQL data to SQL Server, Easy and Fast.

Download Withdata DBCopier Download DBCopier

Transfer data from multiple similar MySQL tables to a single SQL Server table

Login to MySQL and SQL Server -> Select source MySQL tables -> Set the target SQL Server table -> Copy MySQL data to SQL Server

Choose source MySQL database and logon.

convert MySQL data to SQL Server data - Choose MySQL and logon

Choose target SQL Server database and logon.

convert MySQL data to SQL Server data - Choose SQL Server and logon

Click “Convert Similar Tables” at task dialog.

Import data from multiple similar MySQL tables to 1 SQL Server table - Task Window

then show the wizard.

1. Select similar MySQL tables.

Convert data from multiple similar MySQL tables to 1 SQL Server table - open query results

2. Select a destination SQL Server table and config fields.

Combine multiple similar MySQL tables data to a single SQL Server table - select table

3. Preview data.

Migrage data from multiple similar MySQL tables to 1 SQL Server table - preview

4. Import data from multiple similar MySQL tables to a single SQL Server table.

Merge multiple similar MySQL tables to a single SQL Server table - import

More about MySQL to SQL Server converter

See also: