fuzzyocelot
Programmer
Hey everyone!
I hope this is the right forum for my question.
I have a new problem I hope someone can offer some advice on. There are 14 databases on one of our servers that are “related”. They are for the same application but for different organizations. The fun part is that not all of them use the same schema. The users would like to report on them. However, I don’t think they realize the scope of these databases. Of the 14 databases, 11 of them have the same number of tables – 139 tables each! The other 3 dbs have 140, 37 and 3 tables. The users are going to find out of the vendor has a schema we can look at. Otherwise, it’s gonna be fun trying to figure this thing out!
Anyway, I thought about trying to create a database diagram using Enterprise Manager as the database is in SQL 2000. How do I go about doing so with 139 tables in one database? Oh and there do not appear to be any relationships between the tables! Any ideas on how to diagram this thing? It usually helps me to have a visual of the tables, but I’m not sure I’m going to be able to do so with these databases.
It would be nice if I had something like Visio, but I don’t. I’m not even sure how to go about creating a data dictionary of sorts for this thing.
Many, many thanks!
I hope this is the right forum for my question.
I have a new problem I hope someone can offer some advice on. There are 14 databases on one of our servers that are “related”. They are for the same application but for different organizations. The fun part is that not all of them use the same schema. The users would like to report on them. However, I don’t think they realize the scope of these databases. Of the 14 databases, 11 of them have the same number of tables – 139 tables each! The other 3 dbs have 140, 37 and 3 tables. The users are going to find out of the vendor has a schema we can look at. Otherwise, it’s gonna be fun trying to figure this thing out!
Anyway, I thought about trying to create a database diagram using Enterprise Manager as the database is in SQL 2000. How do I go about doing so with 139 tables in one database? Oh and there do not appear to be any relationships between the tables! Any ideas on how to diagram this thing? It usually helps me to have a visual of the tables, but I’m not sure I’m going to be able to do so with these databases.
It would be nice if I had something like Visio, but I don’t. I’m not even sure how to go about creating a data dictionary of sorts for this thing.
Many, many thanks!
