Platonides wrote:
Note we will also need a way to generate a SQL from that (eg. for manually creating a new database with SQLAdmin).
Personally, I prefer viewing the code (SQL) which is really used, but I won't stop you from making the perfect abstraction.
Well, the very first task of the new system will be to generate a tables.sql and make sure it matches the current one. Perhaps we can even keep them around, but make them "read only", for the benefit of circumstances like the above (as well as making it easy to read from the perspective of each database-in-question).
The only question in my mind at the moment is do we also copy all the comments to each tables.sql (see maintenance/tables.sql), no comments (see oracle|postgres/tables.sql) or something in the middle (see mssql/tables.sql)?