[Haskell-cafe] SQL database schema diff tool

Sergey Mironov grrwlf at gmail.com
Sat Jul 11 17:54:10 UTC 2015


Hi, list! I wish I have a tool which would compare two database
sachemas, where each schema is represented as a list of 'CREATE smth'
instructions. The result of such a comparison would be a list of
'ALTER smth' instructions. This instruction set would change the
database from first state to second, if the transition is possible
without data losses. The 'hard' mode - to prepare the transition for
any inputs, with minimal data losses.

The database of interest is PostgreSQL. Does such a tool exist? If
not, which package do I better use to build the AST of initial
schemas?

The example schema is in attach.
Thanks in advance,
Sergey
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Etab.sql
Type: application/sql
Size: 1581 bytes
Desc: not available
URL: <http://mail.haskell.org/pipermail/haskell-cafe/attachments/20150711/5c7f48cb/attachment.bin>


More information about the Haskell-Cafe mailing list