Like the question title says, I want a tool like
make which will take a recipe file and use it to automatically rebuild a collection of interdependent tables in a relational database. Does such a tool exist?
I'm working on a project that involves many people generating (and regenerating) many different tables in a relational database. During the development process, we are frequently regenerating some of these tables from scratch. Many of these tables are dependent on each other, so that when one table is regenerated, all of its dependent tables also need to be regenerated - which can be very time-consuming.
This situation feels analogous to a typical situation in software development, where code needs to be recompiled. In the software development world, there are automated build systems which keep track of these dependencies and speed up the recompilation process - make being (possibly) the most well-known of these.
make tool takes a "recipe" file which lists the dependencies between different files, checks the state of the files to see which ones have been modified since the last compilation, and updates (recompiles) only those files which need to be. I want something like that for the generation of database tables.
Does such a tool exist?