Software for automatic schema compare for PostgreSQL?


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
6 views
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 %)
by | 6 views

5 Answers

0 like 0 dislike
EMS DB Comparer for PostgreSQL www.sqlmanager.net/en/products/postgresql/dbcomparer
you can even be a script to try — snippets.dzone.com/posts/show/949
by
0 like 0 dislike
To compare schemas, you can use PgMDD. The procedure is simple.
\r
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.
by
0 like 0 dislike
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...
by
0 like 0 dislike
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.
by
0 like 0 dislike
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
by

Related questions

0 like 0 dislike
3 answers
0 like 0 dislike
1 answer
asked Jun 14, 2019 by sputnickk
0 like 0 dislike
1 answer
0 like 0 dislike
2 answers
110,608 questions
257,186 answers
0 comments
27,101 users