Transfer data from PostgreSQL query to SQL Server table without programming

by

Posted on by

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

Using Withdata software DBCopier, a PostgreSQL to SQL Server converter, you can transfer data from PostgreSQL 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 PostgreSQL query To SQL Server table

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

Choose source PostgreSQL database and logon.

convert PostgreSQL query to SQL Server table - Choose PostgreSQL and logon

Choose target SQL Server database and logon.

save PostgreSQL query results to SQL Server table - Choose SQL Server and logon

Click “Convert From Query” at task dialog.

Import data from PostgreSQL query results to SQL Server table - Task Window

then show the wizard.

1. Set a PostgreSQL query.

Convert data from PostgreSQL query results to SQL Server table - open query results

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

Extract PostgreSQL query results data to SQL Server table - select table

3. Preview data.

Migrage data from PostgreSQL query results to SQL Server table - preview

4. Transfer data from PostgreSQL query result to SQL Server table.

save data from PostgreSQL query results to SQL Server table - import

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.

2) Set scheduled task.

More about DBCopier – PostgreSQL to SQL Server Converter

Download DBCopier for 30-day free trial Download DBCopier