Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Move away from migra #4

Open
ewan-escience opened this issue Apr 19, 2024 · 1 comment
Open

Move away from migra #4

ewan-escience opened this issue Apr 19, 2024 · 1 comment
Labels
help wanted Extra attention is needed

Comments

@ewan-escience
Copy link
Collaborator

We have been using migra to automatically generate migration scripts for consecutive releases of the RSD (sometimes having to adapt them manually). However, Migra hasn't been updated in 2 years and it is starting to fail in some cases. For example, it didn't see the newly added DOMAIN in this PR.

So we need to move to another tool. Ideally it works the same as migra: take two running databases and create s script that when applied to one of the databases, would update its schema to be the same as the other database.

@ewan-escience ewan-escience added the help wanted Extra attention is needed label Apr 19, 2024
@ewan-escience
Copy link
Collaborator Author

Some tools to consider:

  • Atlas looks promising
  • pgdiff is similar but hasn't been updated in 3 years
  • pg-schema-diff also looks promising, but it isn't clear if you can run it agains two running databases (compared to one running database and one schema file)
  • pg-diff seems not to be actively developed anymore
  • PostgresCompare is not free

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
help wanted Extra attention is needed
Projects
None yet
Development

No branches or pull requests

1 participant