PDA

View Full Version : Maintaining data dictionary

tantc
10-14-02, 22:03
What enterprise tools do you use to maintain the data dictonary pertaining to each application's database? Eg. what's the columns for and relationships between tables? Using all_comments system table is not possible for end users. Also it would be great if this tool can be used against different rdbms like oracle or sqlserver
alligatorsql.com
10-17-02, 17:30
Hello,

we use AlligatorSQL for Oracle8i/9i, MySQL, Interbase, Birdstep, PostgreSQL and MSSQL 7 (SQLServer).

You can open every supported databases and see all information about
the different database dictionaries.
You can browse, edit, modify and delete objects and easily switch between the different rdbms.

Try it and send us your comments ...
http://www.alligatorsql.com/download/alligator.zip

Manfred Peter
(Alligator Company GmbH i.Gr.)
http://www.alligatorsql.com
kwonghow
02-10-03, 05:59
you should try to use powerdesigner to maintain the data dictonary while you creating you design of you ERD coz
the Sybase POWERDESIGNER have the ability to generate report base on your diagram and create and full data report
I Hope this can help you
check out the site
www.syabase.com/downloads
playernovis
02-10-03, 12:18
nobody will probably kill me if I say that ERWin belongs to TOP 3 products on the market and I can highly recommend it.... it is more data modeling tool....

http://www3.ca.com/Solutions/Product.asp?ID=260


and I like easy to use and not expensive Microsoft VISIO 2002 ....

http://www.microsoft.com/office/visio/evaluation/techtour/page4.asp




jiri