Batch copy SQL Server tables to PostgreSQL

by

Posted on by

Want to batch copy data from SQL Server tables to PostgreSQL ?

Try Withdata DBCopier, a SQL Server to PostgreSQL converter for Windows, Mac, and Linux, Bulk copy SQL Server to PostgreSQL, Easy and Fast.

Download Withdata DBCopier Download DBCopier

Batch copy data from SQL Server tables to PostgreSQL tables

Login to SQL Server and PostgreSQL -> Select source SQL Server tables -> Set target PostgreSQL tables -> Copy SQL Server data to PostgreSQL

Choose source SQL Server database and logon.

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

Choose target PostgreSQL database and logon.

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

Click “Convert All Tables” at task dialog.

Batch import data from SQL Server tables to PostgreSQL tables - Task Window

then show the wizard.

1. Select source SQL Server tables.

Batch convert data from SQL Server tables to PostgreSQL tables - Open Source schema

2. List target PostgreSQL tables.

Batch extract data from SQL Server tables to PostgreSQL tables - select destination schema

3. Select PostgreSQL tables to import.

Batch import data from SQL Server tables to PostgreSQL tables - select tables

4. Transfer data from SQL Server tables to PostgreSQL.

Batch copy data from SQL Server tables to PostgreSQL tables - batch import

Batch transfer data from SQL Server tables to PostgreSQL in command line

Save “SQL Server tables to PostgreSQL” session, then you can:

Set scheduled tasks for coping data from SQL Server tables to PostgreSQL

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

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “SQL Server to PostgreSQL” conversion.
  2. Set scheduled task for “SQL Server to PostgreSQL” conversion.

FAQ

More about Withdata DBCopier – SQL Server to PostgreSQL Converter

See also: