Re: schema change tracking
От
Steve Atkins
Тема
Re: schema change tracking
Дата
Msg-id
5743A1A5-A8DF-4463-9B00-0D87B32C622D@blighty.com
Ответ на
schema change tracking (Benedict Holland)
Список
Дерево обсуждения
schema change tracking Benedict Holland <benedict.m.holland@gmail.com>
Re: schema change tracking Paul Jungwirth <pj@illuminatedcomputing.com>
Re: schema change tracking Steve Atkins <steve@blighty.com>
Re: schema change tracking Mark Fletcher <markf@corp.groups.io>
Re: schema change tracking Benedict Holland <benedict.m.holland@gmail.com>
Re: schema change tracking Adrian Klaver <adrian.klaver@aklaver.com>
Re: schema change tracking bricklen <bricklen@gmail.com>
> On May 16, 2019, at 5:41 PM, Benedict Holland wrote: > > Hi All, > > I am fairly this question has many answers but here it goes: > > I need a tool that can track schema changes in a postgesql database, write scripts to alter the tables, and store those changes in git. Are there tools that exist that can do this? If you're looking for something that'll reverse engineer schema change scripts from a database someone has made ad-hoc changes to ... try and avoid doing that if at all possible. Use the change scripts in git as the source of truth. If you do that there are many answers, starting at "it's fairly easy to do yourself, with a simple schema version and upgrade / downgrade scripts". Depending on what language you're writing your app in there may be libraries that can help. But if you're looking for something standalone, look at https://sqitch.org Cheers, Steve
В списке pgsql-general по дате отправления
