Database relationship tool needed

Click For Summary
SUMMARY

The discussion centers on the need for a tool to document database tables and their relationships, specifically for a Sybase database. Users recommend exploring a trial version of Erwin, a data modeling tool, which may fulfill the requirements for creating diagrams. The participant has already developed a program to extract column information but seeks a solution for comprehensive documentation, including definitions.

PREREQUISITES
  • Understanding of Sybase database structure
  • Familiarity with data modeling concepts
  • Knowledge of Erwin data modeling tool
  • Basic programming skills for data extraction
NEXT STEPS
  • Research how to use Erwin for Sybase database documentation
  • Explore freeware alternatives for database diagramming
  • Learn about Sybase database metadata extraction techniques
  • Investigate best practices for documenting database schemas
USEFUL FOR

Database administrators, data analysts, and developers working with Sybase who need efficient methods for documenting database structures and relationships.

Borg
Science Advisor
Gold Member
Messages
2,356
Reaction score
5,132
I just got handed an assignment to document our database tables. I would rather not have to do this manually and I'm wondering if anyone knows of any freeware that will allow me to create diagrams of the tables and relationships between the tables.
 
Technology news on Phys.org
Which RDBMS do you use? A trial version of Erwin might do everything that you need.
 
Last edited:
Math Is Hard said:
Which RDBMS do you use? A trial version of Erwin might do everything that you need.

Thanks MIH, I'll look into it. We're using a Sybase database. I've already written a quick program to pull all of the needed column info for each of the tables. Except for the definitions, that will kill an entire appendix.
 

Similar threads

Simpler alternatives to SQL-like databases
  • · Replies 50 ·
2
Replies
50
Views
9K
Many to Many Relations in Database
  • · Replies 6 ·
Replies
6
Views
2K
Why can't there be a Database tool that has the best of everything?
  • · Replies 5 ·
Replies
5
Views
3K
Python Simple Python Database Tutorial & Example
  • · Replies 6 ·
Replies
6
Views
3K
When should you create sprocs? As often as possible?
  • · Replies 5 ·
Replies
5
Views
2K
JavaScript How do I save JSON files to off-line database?
  • · Replies 8 ·
Replies
8
Views
2K
Python How can I build a database in Python?
  • · Replies 1 ·
Replies
1
Views
3K
What database skills do I need for Android app development?
  • · Replies 10 ·
Replies
10
Views
2K
'Operand type clash: numeric is incompatible with uniqueiden
  • · Replies 1 ·
Replies
1
Views
4K
Need resources for ER diagram and SQL
  • · Replies 5 ·
Replies
5
Views
2K