Software for automatic schema compare for PostgreSQL
Could you tell me the tool for automatic comparison of PostgreSQL schemas on different databases. Used for MySQL SQLyog. Now I write a migration by hand, and different data dictionaries to overtake — it's hard. Who uses what or how gets out?
UPD: we use:
a) to compare schemas — apgdiff
b) to compare data LEFT JOIN %)
To compare schemas, you can use PgMDD. The procedure is simple.
1. Do Reverse Engineering one
2. For the resulting model run Modify, as the target referred to the other.
3. Received DDL statements is diff.
jacynthe_Sauer answered on October 14th 19 at 12:36
the difference between the physical models are very good in sybase powerdesigner to watch — but
1. under Windows, under Wayne really buggy and hard to cut to the point to at least create a workspace.
2. trial or...
queenie.Macejkov answered on October 14th 19 at 12:38
Junk certainly creepy, but suddenly will do or thinking what will induce (he really is long in the direction of the elephant was not looking, but this thing was once used) — PostgreSQL Diff Utility.
oswaldo_Schulist answered on October 14th 19 at 12:40
Data to compare/senkat can rubyrep — good job to throw to sezincote two bases. The truth of the schema he does not know how to compare and Cinca scheme should be the same