Migration

[alberk8]

Does pgroll, do a diff of an old DB schema with a new DB schema and then generate the migration script?.

[gulcin]

Hello @alberk8, thanks for your question! We do have an open issue for a diff feature (#199), but it hasn’t been implemented yet. I’ll keep this thread updated as soon as we prioritize it.

Out of curiosity, could you share a bit about your database setup? Do you use any kind of ORM or similar tools?

[alberk8]

@gulcin, Thanks for the quick reply. I’m used to working with Entity Framework Core, but I find it’s mainly useful in development environments. I don’t need anything overly complex — if I could simply generate a migration script by diffing the last schema against the current schema, that would be ideal. It would also help if old schemas and migration scripts could be snapshotted and stored in a versioned pgroll table.

[alberk8]

This could be the base for diff https://github.com/stripe/pg-schema-diff

[gulcin]

Thanks for the detailed explanation @alberk8. I’ll keep you posted once we start working on this.

[alberk8]

Hope you can consider the following design. Where the migration can be done to a specific version. In the example below, a DB admin should be able to apply migration from v0 to v3 in one step (internally going from v0->v1->v2->v3) or V0 to any of the subsequent version in one step. Thank you.

Base Version v0-> v1 -> v2 -> v3

[gulcin]

Thanks @alberk8 we'll consider it. We appreciate all the feedback!