How can I put a database under git (version control)?

by

Take a database dump, and version control that instead. This way it is a flat text file.

Personally I suggest that you keep both a data dump, and a schema dump. This way using diff it becomes fairly easy to see what changed in the schema from revision to revision.

If you are making big changes, you should have a secondary database that you make the new schema changes to and not touch the old one since as you said you are making a branch.

More Related Contents:

  1. Keep PostgreSQL from sometimes choosing a bad query plan
  2. Copying PostgreSQL database to another server
  3. Primary keys with Apache Spark
  4. Do you use source control for your database items? [closed]
  5. How do IMMUTABLE, STABLE and VOLATILE keywords effect behaviour of function?
  6. Store query result in a variable using in PL/pgSQL
  7. Can I rollback a transaction I’ve already committed? (data loss)
  8. Kill a postgresql session/connection
  9. PostgreSQL: Drop PostgreSQL database through command line [closed]
  10. Do stored procedures run in database transaction in Postgres?
  11. Import SQL dump into PostgreSQL database
  12. how to use Blob datatype in Postgres
  13. How can I solve Postgresql SCRAM authentication problem?
  14. Convert SQLITE SQL dump file to POSTGRESQL
  15. Is it better to use multiple databases with one schema each, or one database with multiple schemas? [closed]
  16. How to login and authenticate to Postgresql after a fresh install?
  17. PostgreSQL Database Log Transaction
  18. Connect to a heroku database with pgadmin
  19. How do I automatically update a timestamp in PostgreSQL
  20. How should you build your database from source control?
  21. Starting and populating a Postgres container in Docker
  22. Adding a new value to an existing ENUM Type
  23. How can I import a .sql file into my Heroku postgres database?
  24. Backup/Restore a dockerized PostgreSQL database
  25. Definition of “downstream” and “upstream”
  26. How to delete duplicate rows without unique identifier
  27. Are Git’s pack files deltas rather than snapshots?
  28. Should composer.lock be committed to version control?
  29. Storing Images : DB or File System –
  30. Is there a version control system for database structure changes?

Leave a Comment