BULK Data Transfer

Data Transfer

Overview

The Data Transfer feature provides a high-performance UI for moving data between SQL Server, PostgreSQL, and MySQL using native bulk-load APIs. It is designed for fast, adhoc transfers of large result sets without requiring SSIS packages or custom scripts.

Key capabilities:

• High-throughput bulk copy optimized for large datasets.
• Cross-database transfers between SQL Server, PostgreSQL, and MySQL.
• Minimal configuration through a simple, tab-based workflow.

Quick Start

1. Select a transfer tab based on the source and target databases.
2. Configure source and target connections:
   • SQL Server connections are selected from Object Explorer.
   • PostgreSQL and MySQL connections can be entered manually or selected from Saved Connections.
3. Paste the source query. The query must return the data to be transferred.
4. Specify a target table name, or leave it blank to auto-generate one when using cross-database tabs.
5. Click Copy Data and monitor progress in the status label.

Notes and Requirements

• For PostgreSQL and MySQL, use Edit Saved Connections to securely store and reuse connection profiles.
• For MySQL imports, local_infile must be enabled on the server. Connections use AllowLoadLocalInfile=true.