[Haskell-cafe] Fwd: SQL database schema diff tool

[Sergey Mironov]

---------- Forwarded message ----------
From: Sergey Mironov <grrwlf at gmail.com>
Date: 2015-07-11 22:17 GMT+03:00
Subject: Re: [Haskell-cafe] SQL database schema diff tool
To: David Kraeutmann <kane at kane.cx>


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 <kane at kane.cx>:
> 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 at haskell.org
>> http://mail.haskell.org/cgi-bin/mailman/listinfo/haskell-cafe
>>
>
>