Create data dictionary to check version of DB
EversonSep 15 2009 — edited Sep 15 2009Hi all,
Good afternoon.
Today I work at a company that develops software to several customers, and we are not the main responsible for there databases, because of this I can't garantee that the database is in agreement with the software version.
To be able to ensure that the client base has no divergence with the software version I'm thinking about creating my own data dictionary, which at first it would be something like the Oracle data dictionary, after that I need to set up mechanisms to confront my new data dictionary with what is there on the client. My data dictionary will be created here in the company.
In addition, this data dictionary also would be used by the development team, for example whenever they want to confirm if some object exists or not exists in production. As we know the development database is a 'mess'.
Does anyone have any suggestion or hint for me about this project?
Thank you,
Everson