Batch copy PostgreSQL tables to SQL Server

by

Posted on by

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

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

Download Withdata DBCopier Download DBCopier

Batch copy data from PostgreSQL tables to SQL Server tables

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

Choose source PostgreSQL database and logon.

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

Choose target SQL Server database and logon.

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

Click “Convert All Tables” at task dialog.

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

then show the wizard.

1. Select source PostgreSQL tables.

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

2. List target SQL Server tables.

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

3. Select SQL Server tables to import.

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

4. Transfer data from PostgreSQL tables to SQL Server.

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

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

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

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

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

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

FAQ

More about Withdata DBCopier – PostgreSQL to SQL Server Converter

See also: