Most today's database engines do not support foreign keys across databases, servers and engines and that would be very useful to understand data. See how you can document them with Dataedo cross-database relations.
A few scenarios how you can leverage Dataedo repositories to manage documentation in complex database systems.
A convenient way of browsing object descriptions from within SQL Server Management Studio.
Quick tutorial on viewing and editing table and column comments in free Oracle SQL Developer.
See how easily and conveniently you can discover, browse and document table and column relationships in your databases.
4 options you have to edit column descriptions in SSMS and 2 for describing tables.
A tutorial that shows how to document SQL Server database with Visual Studio and then export it to PDF and HTML.
Running Dataedo from command line allows you to automate the process of updating and exporting your documentations. However large systems may include multiple operations and files. Running this may be cumbersome. Here is a set of tricks to make it easier.
Practical guide on creating ER diagrams with Microsoft SQL Server Management Studio (SSMS).
Documenting data warehouse is not a trivial task. You need to know how and have the right tools. Here's a step by step tutorial on how to do it to make your colleagues and boss amazed.