PostgreSQL Tools

We are proud to announce the release of a new product from the dbForge Tools for PostgreSQL line – dbForge Schema Compare for PostgreSQL, v1.0.

The tool is best suited when you need to compare Redshift databases quickly and efficiently, as well as to generate synchronization SQL scripts to update target database schemas.

We are glad to announce that a new version of dbForge Data Compare for PostgreSQL v.3.3 is available for download.

In this release, we have extended connectivity options to provide the possibility to work with the latest PostgreSQL database engine. Also, we adjusted the Pre & Post Script execution functionality that helps you perform additional operations before and/or after data synchronization.

For more than 15 years, Devart has been developing database tools and data-related solutions. One of its most popular product lines, dbForge, is designed to facilitate and simplify database development, management, and administration for SQL Server, MySQL, Oracle, and PostgreSQL.

We are glad to announce that the new version of dbForge Studio for PostgreSQL has been just released!

Transferring data between two different servers is not an easy task as it requires a great deal of effort and accuracy, especially when migrating from one database management system to another. In this article, we provide a visual walkthrough of MySQL data migration to PostgreSQL Server.

CSV files provide a great way to collect and store data, and they are often used as a reliable way to move table data between servers. In this article, we’ll look at two ways of importing and exporting PostgreSQL tables from and to CSV files – using the built-in import and export functionality of dbForge Studio for PostgreSQL and using the COPY command.

There are several reasons you may want to migrate your databases from Oracle to PostgreSQL:

1. Oracle can be very expensive, with some important features requiring additional investments on top of that.

A typical relational database table contains multiple rows, quite often with duplicate values in some columns. Data in such a table is usually stored in random order. By running a query to select data from a database table, you can perform filtering, sorting, grouping, selection, and other operations with data.

We are thrilled to inform our PostgreSQL users, that a new version of our ultimate data diffs management tool, dbForge Data Compare for PostgreSQL, v.3.2, has been rolled out. (more…)

Great news for PostgreSQL users: the new version of dbForge Studio for PostgreSQL is out!

The most notable features of this release comprise SQL Code Formatter and Generate Script AS. We expect our customers to benefit greatly from these most eagerly awaited improvements.

(more…)