Transfer data from MySQL query to SQL Server table without programming

by

Posted on by

Want to transfer data from MySQL query results to SQL Server table?

Using Withdata software DBCopier, a MySQL to SQL Server converter, you can transfer data from MySQL (MariaDB, Percona) query result to SQL Server table easily and fast.

  • Can run in GUI mode, Step by Step, just a few mouse clicks.
  • Can run in Command line, for Scheduled Tasks and Streams.
  • Support Windows, Linux, macOS.

Download DBCopier Download DBCopier

Transfer data from MySQL (MariaDB, Percona) query To SQL Server table

Login to MySQL and target SQL Server -> Enter source MySQL query -> Set target SQL Server table -> Copy MySQL query data to SQL Server table

Choose source MySQL database and logon.

convert MySQL (MariaDB, Percona) query to SQL Server table - Choose MySQL and logon

Choose target SQL Server database and logon.

save MySQL (MariaDB, Percona) query results to SQL Server table - Choose SQL Server and logon

Click “Convert From Query” at task dialog.

Import data from MySQL (MariaDB, Percona) query results to SQL Server table - Task Window

then show the wizard.

1. Set a MySQL query.

Convert data from MySQL (MariaDB, Percona) query results to SQL Server table - open query results

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

Extract MySQL (MariaDB, Percona) query results data to SQL Server table - select table

3. Preview data.

Migrage data from MySQL (MariaDB, Percona) query results to SQL Server table - preview

4. Transfer data from MySQL (MariaDB, Percona) query result to SQL Server table.

save data from MySQL (MariaDB, Percona) query results to SQL Server table - import

You can schedule and automate this “MySQL to SQL Server” conversion task by:

1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.

2) Set scheduled task.

More about DBCopier – MySQL to SQL Server Converter

Download DBCopier for 30-day free trial Download DBCopier