2

I want to know what are the different techniques & tools used for database versioning and migration. I am also interested in saving a snapshot of the data along with the schema changes. Would that be a good practice?

I have come across tools like alembic and sqitch, although I haven't used either. I have around 200 table in PostgreSQL.

Thanks

y2p
  • 4,791
  • 10
  • 40
  • 56

1 Answers1

1
  1. Read about using Liquibase with PostrgeSQL
  2. Ask you DBA to create data- (or full) dumps, which you store with ALTER-dumps of Liquibase
Lazy Badger
  • 94,711
  • 9
  • 78
  • 110