|
Paul MaudDib posted:There are also dedicated schema management tools which attempt to address this. I haven't used one, but one that caught my eye was Flyway. The gist is that you dump some baseline content set or schema as "REV 001" and then store all schema/content changes (it's important that it be all changes) as additional revisions. By walking through the set of revisions you end up with whatever state the program expects. This can be done as part of a Maven build script or whatever. Flyway is great. I used it when it was a bit more minimal, and we had to write a handful of bash scripts around it, but the effort is minimal. Now it looks like there is all kinds of build tool support. It's probably obvious but worth mentioning explicitly: Even with such a schema management tool, you're going to need to make sure your database schema is backwards compatible with at least one version of your application.
|
# ¿ Jul 15, 2015 05:20 |
|
|
# ¿ Apr 30, 2024 05:31 |