Database Layer - Data Dictionary

[jkimbler]

I'm wondering if anyone has come across any good components, articles,
or books about creating a data dictionary for an application. I need
to be able to allow the data dictionary keep the database schema up-to-
date with changes in the program.

I found ADDA (Advanced Data Dictionary Architect) but have been unable
to download it becaue of an error on the web site. It creates an XML
file that can be packaged with the application. When the application
starts, it scans the database and compares the schema with that of the
XML file, making changes as needed.

If anyone can point me to good resources on developing a data
dictionary for SQL Server that will allow for updates to the schema.
that would be great. Thanks.

-Joe

 

[Guest]

I'm wondering if anyone has come across any good components, articles,
or books about creating a data dictionary for an application. I need
to be able to allow the data dictionary keep the database schema up-to-
date with changes in the program.

I use LLBLgen - it can generate the data layer as well as document it