Overview of tools for data comparison in PostgreSQL

database Administrators and developers often face situations when you need data from different databases to compare and sync, or just transfer them into another working database. In this case, it is very important to choose the right tool which will help to cope with this task quickly and efficiently. For PostgreSQL there are a few ready-made tools, which allow us to find differences and synchronize the data. In this article let's have a short review of the features of these tools, namely the products of companies such as Devart, SQL Maestro Group, Navicat and Altova.


image

After installation, on first launch, all products require a license key, but all the same there is a trial period. From SQL Maestro Group and Navicat 15 days, and dbForge and Altova 30 days. And, if all the products of the transition in the period of trial use is possible with a single push of a button, Altova offers to use their automated service to obtain the keys on every product. Then in the mail comes a list of keys for the requested products with the end date of their validity.


Each product is quite different from each other on the interface and functionality. Therefore, we give a brief overview of the applications of first impressions:


    the
  1. PostgreSQL DataSync — the application immediately launches the wizard to compare two databases, thereby indicating that this application is intended only for comparison of data and nothing more. Also in the master there is a button Generate command line... which allows you to save the script for later use in process automation.
    2. the
  2. dbForge Data Compare for PostgreSQL after the application starts, a window opens, Start Page, which can be a list of previous projects. Also, judging by the toolbar, you can invoke not only the master data synchronization, but normal SQL window document's script with a standard set of tools and running large scripts directly from a file. To work on data synchronization as well open New Data Comparison wizard to enter the connections and names databases. Also in the master there is a button Save Command Line... that allows you to save scripts for further use.
    3. the
  3. Navicat for PostgreSQL – after starting open Studio with a set of tools for working with databases. Ie offers not only the option to synchronize data and synchronize schemas and objects. For comparison, data are also runs master Data Synchronization, prompting you to select two connections and for some reason only one schema from each database. Thus, to compare multiple schemas you need to run the synchronization for each scheme separately.
    4. the
  4. Altova DatabaseSpy – after you run the application opens, where from the drop down menu have the opportunity to choose options compare files, directories, data, etc. the Neighborhood of such applications in a single list a little embarrassed, and attempt to conduct a simple comparison of the two databases has not led to any satisfactory result, because of the fairly unique interface. Therefore, unfortunately, further comparison of this application, we excluded.

When comparing simple data, all three applications showed pretty well, stood only Navicat with your comparison of each scheme separately. dbForge pleased with the opportunity to enter additional custom scripts for each pair of comparison.
When working with complex data has emerged differences. When synchronizing data with the conversion all types of applications display a warning about possible data loss. But at least for our test data, after the synchronization DataSync and Navicat continue to show that the data in the tables are not equal, but in the synchronization script nothing is removed. After synchronization dbForge application in the subsequent comparison of the application itself indicates that the data in both databases are equal, and additional synchronization is not required. DataSync and Navicat confirmed that after the synchronization application dbForge Data Compare for PostgreSQL, all data is equal.


When comparing applications should pay attention to their prices. The table also added the tools that we have not included in the review.


the the the the the the the the the
Product
 Link
 Company
 Price
dbForge Data Compare for PostgreSQL
 https://www.devart.com/dbforge/postgresql/datacompare/
 Devart
 $99.95
PostgreSQL Data Sync
 http://www.sqlmaestro.com/products/postgresql/datasync/
 SQL Maestro
 $99
EMS Data Comparer for PostgreSQL
 http://www.sqlmanager.net/products/postgresql/datacomparer
 SQL Manager
 $110
Table Data Comparison And Synchronization Tool
 http://www.dbsolo.com/datacomp.html
 DB Solo
 $129
DatabaseSpy 2017
 http://www.altova.com/databasespy.html
 Altova
 Enterprise $189
Professional $129
Datanamic DataDiff for PostgreSQL
 http://datanamic.com/datadiff-for-postgresql/index.html
 Datanamic
 Standard $199
Navicat for PostgreSQL (for Windows)
 https://www.navicat.com/en/products/navicat-for-postgresql
 Navicat
 Enterprise $299
Standard $199
Aqua Data Studio
 http://www.aquafold.com/aquadatastudio/schema_sql_compare.html
 AquaFold
 Standard $499

Prices are for single user with 1 year support.


Summing up, we can say that each tool has both advantages and disadvantages. Which tool to choose depends on your preferences. On the basis of all the above criteria was chosen dbForge Data Compare for PostgreSQL, which is perfectly copes with the objectives, while having a low cost.


image

Article based on information from habrahabr.ru

Популярные сообщения из этого блога

Approval of WSUS updates: import, export, copy

Изображение
the Backstory Until recently, I worked as edikasyon a major Russian company that has many offices throughout the country. In my jurisdiction there were eleven sites, located in different cities of the Far East (this is important). In each of these offices had its own, not connected with other network infrastructure — your domain AD own subnet, etc. Once the leadership gave me the task to organize the automatic updating of the OS and programs from MS and allowed to expand on accountable sites WSUS . Problem After WSUS was deployed, binding policy, computers to WSUS groups are configured, the directory synchronization content server MS held, etc., the question arose: who and how will approve the update? Imagine 11 cities that are so "fast" and "stable", that rare moment when latency of ICMP replies are only 800 MS, are perceived as unheard of luck. And in each you test all updates before deploying. The access to the servers at the sites was only v...
Далее...

Kaspersky Security Center — the fight for automation

oddly enough, I found habré only one article on the subject — the sandbox much unfinished actually contains a piece of the slightly redesigned the product help. Yes, and Google query klakaut silent. I'm not going to tell you how to administer the hierarchy of Kaspersky Security Center (hereinafter KSC) from the command line — I do not yet need never. Just want to share some thoughts about automation tools to those who need it and disassemble one case with which I had to face. If you, %habrauser%, this topic will be interesting — welcome under kat. Historically, the anti-virus protection on the job, I prefer products of Kaspersky Lab (hereafter LK). Causes and other Holy war of personal opinions, I'll leave behind the scenes. Naturally, I would like to centrally deploy, protect, to protect and to enforce the law to draw beautiful graphics to integrate into existing monitoring systems and to do other work shifting the blame to a healthy server. And if you deplo...
Далее...

The Hilbert curve vs. Z-order

Изображение
Repeatedly heard the opinion that of all swept curves . it the Hilbert curve the most promising for spatial indexing. The explanation given is that it does not contain discontinuities and therefore in some sense “well-arranged”. Whether so it actually and what is the spatial indexing, we will understand under the cut. The concluding article of the series: the the Why doesn't the straightforward approach to spatial indexing swept curves the Presentation the 3D and obvious optimization the 8D and perspectives OLAP the 3D field as it looks the 3D field benchmarks the How about indexing non-point objects? The Hilbert curve has the remarkable property — the distance between two successive points is always equal to one (step current of detail, to be precise). Therefore, data is not much different Hilbert curve values are close to each other (the inverse, incidentally, is wrong — adjacent points may be very different in meaning). For this property it is us...
Далее...