HomeAboutMailing ListList Chatter /0/0 3.233.232.160

db schema compare

2023-07-07 by: Ed King
From: Ed King 
------------------------------------------------------
Specifically,  for postgresql

Yeah, I know I can Google and get a list of tools, but I want to know which
one(s) YOU, my fellow chuggers, like.to use

I've tried pg_admin's compare tool,  and I've seen an aquadata studio demo.

I have written bash scripts that call psql to:
identify diffs
drop dependencies
alter the tables and/or views
restore tables/views/grants/indexes

so I do have a solution, but I was wondering if there is a tool with a nice
gui that can do all of that.

=============================================================== From: Dan Danese ------------------------------------------------------ For postgres DBs, the favored tool now is dBeaver. I admin numerous types of postgres based databases and this is the primary tool of the user base now. -br Dan On Fri, Jul 7, 2023 at 8:15=E2=80=AFAM Ed King wrote:

=============================================================== From: Ed King ------------------------------------------------------ Thanks Dan.. I've used DBeaver but what I'm looking for is a tool that can do fully automated db sync... which might be a pipe dream. A tool that can not only identify db "diffs" but also be intelligent enough to perform the sync, even if it means dropping/restoring umpteen dependent views I've written bash+psql scripts to do db sync but they are tedious