I am now able to extra an ERD and to convert it to a pdf doc (great feature). Export of a schema DDL to an sql file should also be possible, but I have never used it.Īpr 27, 2012, 13:37, 3785 days I am able to connect the DbVisualizer, to see the objects (tables.) from a given schema. select the schema that you want - click tab 'References' in the right-side panel - ERD is shown (can take some time when you have a lot of tables) - ERD can be saved in a number of graphical formats. But how to extract an ERD from the llst of table I have, as well as extracting a DDL script? Thanks and Regards. Hi Johan, I was able to download the driver for Oracle and I can establish a connection. Why do I need such a file and where to get it? Thanks and Regards. Hi LKBrwn DBA, In step 1 (connect to database) I can create a connection, but I press the import button, it expects a. Is there something missing? Kind Regards.ġ) Make sure the Oracle client installed 2) Needs the tnsnames.ora file 3) Then: File -> Import -> Dictionary. Hi LKBrwn DBA, I have the downloaded the version you mentionned, but when I start a session, I am unable to connect to a database. So: - place the ojdbc6.jar somewhere on your computer - put that directory in the Driver Manager Search Path - maybe you need to restart DBVisualizer - now you should be able to connect to your database using jdbc thin connection. The ojdbc6.jar is the Oracle jdbc driver that is used for thin jdbc connections. Only the "Oracle Thin", "Oracle OCI" and the "Oracle DataDiret". Johan, Unfortunatelly, in the driver name list, I do not have the "Oracle jdbc" driver. In the Driver Manager screen (under Tool Properties) you define the driver search path, where DBVis should look for drivers. You need to make the Oracle jdbc driver (ojdbc16.jar) available to DBVisualizer. Re: Re-Tool to extract database relational model Johan, About the DbVisualizer, any of the Oracle drivers provided by the menu after doenload is active. Hi Tarun, I use the freeware version of Toad, but I am unable to put all the tables into the ER diagram? Do I need to puchase the commercial version for it? Kind Regards. Re-Tool to extract database relational model PS: For PL/SQL packages, use SQL Developer. Oracle SQL Developer Data Modeler (Free): Database->Report->ER Diagram-Create new diagram Thanks Re: Tool to extract database relational model If you think this item violates copyrights, please click here Does someone know if there is such a tool to extract a diagram (even if not complete) of the database tables and their relations? Can such a toll also extact the PL/SQL code of big packages? Thanks by advance, Kind Regards. Hi, I do not have much experience with GUI-tools. Tool to extract database relational model
0 Comments
Leave a Reply. |