---------- Forwarded message ---------- From: Sergey Mironov Date: 2015-07-11 22:17 GMT+03:00 Subject: Re: [Haskell-cafe] SQL database schema diff tool To: David Kraeutmann Thanks for the answer, I've looked at simple-migrations application. Unfortunately, it doesn't look like the solution for me. Term 'migration' in PostgreSQL seems to mean 'movement of data from one server to another using the same schema', but I need to move the data from one schema to another as safely as possible having the definitions of both schemas. Regards, Sergey 2015-07-11 21:05 GMT+03:00 David Kraeutmann :

You could try https://github.com/ameingast/postgresql-simple-migration, but I haven't used it myself. "schema migration" seems to be what you want. On 7/11/2015 7:54 PM, Sergey Mironov wrote:

...

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

_______________________________________________ Haskell-Cafe mailing list Haskell-Cafe@haskell.org http://mail.haskell.org/cgi-bin/mailman/listinfo/haskell-cafe