Batch copy SQL Server data from tables to tables

Click "Wizard - Tables To Tables" at task dialog.

Batch copy data from one SQL Server database to another - Task Window

then show the wizard.

1. Open Source SQL Server.

Batch copy data from one SQL Server database to another - Open Source schema

2. Open Target SQL Server.

Batch copy data from one SQL Server database to another - select destination schema

3. Select SQL Server tables to copy data.

Batch copy data from one SQL Server database to another - select tables

4. Batch copy SQL Server data from tables to tables.

Batch copy data from one SQL Server database to another - copy

For repeatable task, you can click "Save Session" button to save config, then run it next time. see also: Save and load session.