4 ms·
Using a schema diff tool can help with a number of the problems you mention - you can test correctness, autogenerate changes, and because you can diff from curr
by djrobstep 6y ago
Using a schema diff tool can help with a number of the problems you mention - you can test correctness, autogenerate changes, and because you can diff from current -> target without version numbers, no need to keep a chain of migration files hanging around.
- danpalmer 6y agoThat's true, it would solve some of these problems. I do think the ultimate solution needs an awareness of both the diff and the migration plan though, to be able to test for things like whether changes can be made without downtime in a particular order. Unfortunately I suspect that the tool _also_ needs runtime instrumentation of the database in some cases to understand behaviour enough to address all of these concerns.