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)?
--
Greg Sabino Mullane greg(a)endpoint.com
End Point Corporation
PGP Key: 0x14964AC8