PostgreSQL Data Migration

Benefit from quick and seamless Postgres data migration and get a simple method to transfer your PostgreSQL data between different servers, databases, and IDEs.

Data migration is a tedious task requiring lots of manual activity. dbForge Studio for PostgreSQL can help relocate your workloads and data to new types of data storage and processing systems quickly and easily. The tool can boast an intuitive GUI with a bunch of advanced options that help you effortlessly migrate your data.

  • Create, modify, and share data import and export templates
  • Avoid negative impacts on the source system performance
  • Minimize the need for manual coding
  • Enjoy advanced mapping options
Migration flow

Data Migration Workflow

The PostgreSQL Import/Export functionality of dbForge Studio for PostgreSQL allows transferring data from PostgreSQL to any other DBMS as well as from any other DBMS to PostgreSQL using ODBC drivers.

We strongly recommend utilizing a high-performance and feature-rich Devart PostgreSQL ODBC Driver as it provides quicker and more stable access to PostgreSQL databases compared with standard ODBC drivers.

Migration to PostgreSQL

To perform import tasks with the help of dbForge Studio for PostgreSQL, you don't need to continuously switch between different IDEs to transfer PostgreSQL data between different databases.

In the Data Import wizard, select to import data using ODBC driver. Then configure the necessary import options, select server, database, and data to be imported. You can import data to the existing table or create a new one, which is highly beneficial.

Run the Import job and enjoy the result.

Migration from PostgreSQL

To relocate data from PostgreSQL quickly and smoothly, export the required data with the help of ODBC driver, using a convenient wizard. You don't have to migrate the whole table, you can select data to be exported instead.

Set the ODBC driver to connect to the DBMS server you want to transfer data to and configure driver's settings further. The possibility to save templates helps eliminate doing the same actions when moving data between various systems.

Run the Export job and enjoy the result.

Data Import

PostgreSQL Import with ODBC driver

To import the required data using ODBC data provider, on the Source file tab of the Data Import Wizard, select ODBC.

With an intuitive wizard, import tasks are seamless and error-free.

PostgreSQL Import from ODBC

Set ODBC data provider options

On the ODBC options tab of the Data Import wizard, you need to set ODBC data providers options for imported data. You have to provide:

  • Data source name
  • A connection string
  • Login information

For convenience, you can test the connection specified before running
Import job.

Set ODBC data provider options

Choose import destination

On the Destination tab of the wizard, you need to select a source and a target table for import.

Note, that you can import data to an existing table as well as create a new table and specify its name.
Customizable import options

Configurable data format

dbForge Studio for PostgreSQL can help introduce and sustain data standards within your organization.

With the tool, you can adjust:
  • Null string
  • Thousand separator
  • Decimal separator
  • Date and Time format

You can set options for each column separately.

Configurable data format

Mapping Options

Column mapping allows you to configure how your records should be stored in the target destination for maximum performance and efficiency.

If you are importing data into a new table, the tool will automatically create and map all the columns. If you are importing data into an existing table, the columns with the same names will already be mapped, the rest you can map manually.

Mapping Options

Data Import Modes

With dbForge Studio for PostgreSQL, you can choose a data import mode according to the needs of your project:

  • Append
  • Update
  • Append\Update
  • Delete
  • Repopulate
You can also select to import data in a single transaction.
Data Import Modes

Data Import Output

With the tool, you can select options to manage the data import script output:

  • Open the data import script in the internal editor
  • Save the data import script to a file
  • Import data directly to the database.

The tool also allows to automatically add timestamp to the file name and select a folder to save the file to.

Data Import Output

Handling Import Errors

With the Data Import functionality, you can customize errors handling behavior and logging options according to the needs of your project.

Managing errors processing helps significantly save database development, administration, and maintenance time.
Import Errors handling

Saving Import Templates

The tool allows saving your import options as a template in order to speed up repetitive data import jobs. You can then re-use the template as many times as you want.

It is also possible to share templates with the team to save time and ensure data standardization.
Saving Import Templates

Enjoy the result

As a result of your Import job, the source data you selected when configuring Data Import Wizard appears in your PostgreSQL database.

Import Result
Data Export
PostgreSQL Export ODBC format

PostgreSQL Export with ODBC driver

To export the required data using ODBC data providers, on the Export format tab of the Data Export Wizard, select ODBC.

A convenient wizard makes export tasks quick and simple.

Select data to be exported

Select data to be exported

When performing export tasks with the tool you can select

  • PostgreSQL Server connection
  • a database
  • a schema
  • table(s)

you want to be exported.

ODBC data provider options

Set ODBC data provider options

On the Options tab of the Data Export wizard, you need to provide:

  • Data source name
  • A connection string
  • Login information

For convenience, you can test the connection specified before running Export job.

Configurable data format

Choose a destination table

On the Table tab of the wizard, you need to select a destination table for export.

Note, that you can select from a list of existing tables as well as create a new table and provide its name.
Configurable data format

Configurable data format

By setting data format representation, you can encourage and deliver unified data standards within your company.

You can also assign data types for columns:
  • Integer
  • Date
  • Time
  • String
  • Float
  • Currency
  • DateTime
  • Boolean
Exporting rows

Exporting rows

It is not necessary to export the whole table. You can select to export all rows, export the selected rows only, or export the range of rows.

The selective export feature mitigates data transfer and greatly saves time.

Errors handling

Handling Export Errors

You can specify errors processing behavior and logging options:

  • Prompt a user for an action
  • Ignore all errors
  • Abort at the first error
You can also select to create a log file with a report and set a path to it.
Data Pump for SQL Server - Import Output

Saving templates

dbForge Studio for PostgreSQL allows you to save export options templates for recurring export scenarios.

Waste no time configuring options over and over again: use templates to apply options to any number of export jobs.

Errors handling

Enjoy the result

As a result of your Export job the data you selected appears in the database on the server you specified when configuring ODBC provider options.

Conclusion

dbForge Studio for PostgreSQL has advanced built-in features for moving PostgreSQL data between a source and target systems and can significantly assist teams in their PostgreSQL data migration efforts. The PostgreSQL Import and Export functionality provided in the Studio makes it possible to transfer PostgreSQL data between different databases, servers, and IDEs. Simplify your database migration with dbForge Studio for PostgreSQL.

dbForge Studio for PostgreSQL

Cutting-edge PostgreSQL IDE for database development and management

Download

Availability in the editions of dbForge Studio for PostgreSQL

Feature

Standard
Express
Data Export to 14+ file formats
Yes
Data Import from 10+ file formats
Yes

* CSV format has no restrictions for data export and import, for other formats only first 50 rows are processed. User templates are not supported.