Hi all sorry im posting this here, but you guys can answer almost all the q's that i can come up with.
Here is the problem, i got 226 tables that could be link to each other with id fields. I need a way to show diagrams starting with a main table (that i can pick) and show a diagram of tables that can join to it. Is there a program that can build up the diagram so i can know which table is join with another table
its something really close to sq servers diagrams but built automaticly.
Thanks in advance.
All I can say is who designed that? eeewww
I could not imagine trying to debug problems in that, nor trying to explain to another developer how things relate!
I do not think there is a tool out there that does that. If it did I am sure you are talking a couple thousand dollars.
EricYou might want to check out Visual Case. You can Download a trial copy...The tool will allow you to Reverse Engineer an existing DB.
<!-- m --><a class="postlink" href="http://www.visualcase.com/">http://www.visualcase.com/</a><!-- m -->
JoshNope it didnt work. It make me do the diagram by my self i can do that in sql server tooo. I guess i have to find another way to get this done. Thanks any wayEh? Are you looking for "are joined" meaning "are related" or "are join compatible, though may or may not be related"?
If you're looking for "are related", that's cake to do in Enterprise Manager, as there's an option for adding related tables automatically when building a diagram with the wizard. Select the table you're interested in, check the option, let it build the diagram, and there you are...
Here is the problem, i got 226 tables that could be link to each other with id fields. I need a way to show diagrams starting with a main table (that i can pick) and show a diagram of tables that can join to it. Is there a program that can build up the diagram so i can know which table is join with another table
its something really close to sq servers diagrams but built automaticly.
Thanks in advance.
All I can say is who designed that? eeewwwI could not imagine trying to debug problems in that, nor trying to explain to another developer how things relate!
I do not think there is a tool out there that does that. If it did I am sure you are talking a couple thousand dollars.
EricYou might want to check out Visual Case. You can Download a trial copy...The tool will allow you to Reverse Engineer an existing DB.
<!-- m --><a class="postlink" href="http://www.visualcase.com/">http://www.visualcase.com/</a><!-- m -->
JoshNope it didnt work. It make me do the diagram by my self i can do that in sql server tooo. I guess i have to find another way to get this done. Thanks any wayEh? Are you looking for "are joined" meaning "are related" or "are join compatible, though may or may not be related"?
If you're looking for "are related", that's cake to do in Enterprise Manager, as there's an option for adding related tables automatically when building a diagram with the wizard. Select the table you're interested in, check the option, let it build the diagram, and there you are...