Toad Data Modeler 4.1.5.8 Keygen
Magali Swinderman
In order to get the entire DB do you have to select each table one at a time? Is this Quest way of prompting you to buy an add on? If so what is it so thatt I can just select a schema and all objects, to create an ERD.
Hi,
There is an Database tab in Toad, under that report tab is there, under that
ERD option is there.
We can draw ERD using that one by selecting the new ERD option.
If u select one table, It will automatically generate the ERD with related
tables.
From: clhoste via oracle-db-l [mailto:oracl...@Groups.ITtoolbox.com]
Sent: Tuesday, April 20, 2010 5:36 PM
To: Voskoboynikov, Oleg
Subject: [oracle-db-l] How to generate an ERD with Toad data modeler
I need to start a long-term project in mapping out data tables so that we can get a high-level view of what information we store in our Oracle database and how the tables are linked to each other. This is largely for GDPR preparation.
Since our organization has been around for a number of decades, its database is massive. With TOAD for Oracle, I'm able to see all columns in our tables easily, so I started looking at different database mapping tools (ER/ONE, DDM, Astah) but they all look like I need to manually create all the tables and columns and draw their relationships out by hand.
I'm hoping to minimize as much manual labor as possible and am wondering if using TOAD data modeler would help since I'm using TOAD for Oracle anyways. Could I somehow automate the table, column, and relationship creation process?
Any decent data modelling tool supports reverse engineer a physical data model from an existing schema. How good the derived model is will depend on how good your schema is (my bet: decades of development without an existing data modelling tool? not good). For instance, if your schema has foreign keys the reverse engineering process will use them to draw the relationships between tables (even if they are disabled). But if there are no foreign keys then you're on your own.
As you're using already TOAD you are right to want the TOAD modelling extension. You can buy it as a standalone purchase. But if your company won't spring for the extra licenses you should check out Oracle SQL Developer Data Modeler. It's free and it has the most comprehensive support for idiomatic Oracle. (I'm not saying it's the best DM tool of them all but it's very good for something which is free). Find out more.
I'm trying to do data modeling with Visio 2007, and it just seems Microsoft really hasn't put much effort into making the data modeling portion of Visio work well with MS SQL. When I try to reverse engineer the database I'm working with I have Micorsoft SQL Server selected as the 'Installed Visio Driver' then I select a Microsoft SQL 2008 database, but Visio just returns 'The currently selected Visio driver is not compatible with the data source'. What the heck... I can get it to work using Generic OLE DB Provider but then most of the data types in the model are incorrect.
Also with Visio when I do get a model created, often times moving a table will disconnect the relationships between it and other tables, and re-adding the relationship can create new columns if the foreign and primary keys aren't the same name.
Thus far I've had better luck using the data modeler in SSMS than Visio, but I wanted to ask if I'm missing something or is it the consensus of most that Visio just isn't up to snuff for doing good data modeling. I've also been looking at Toad Data Modeler by Quest which I love the Freeware version, but even it expires in about 120 days and doesn't support more than 25 tables within the model which the database I'm working with now is 70 table and counting. And at the $475 price tag, though this is low for what I've seen others spend on a good modeling tool, it's beyond the budget I can spend.
I like visio, but I don't typically use the automation tools. I've got a toolbar that I've built a few shapes into to help me with, but primarily I use it to build out data flow diagrams and the like. Rarely is an ERD actually necessary, but I've gotten familiar enough with Visio I can do a largish DB within a day. More often I'm providing flow paths, algorithmic descriptions, and the like, where the freeform nature of Visio is a lot more powerful and useful.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL RecipesIf you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2
I haven't used it, but I did an eval of PowerDesigner. It's a very good piece of software, especially if you have a lot of datawarehousing work. It's got tools in support of star schemas & such that don't exist with other tools.
I'll echo a couple of sentiments here. As a charting, mapping, or graphic tool, I absolutely love Visio. I've used it extensively anytime I've needed a map, illustration, or some graphic representation of some type.
I used Visio for around three days with those three days being possibly the most stressful of my life, and the kicker with Visio is once you've persevered and actually created something you can't even forward engineer it, well since 2005 or something anyway (I seem to remember there being talk about an unofficial third party app that allowed forward engineering for 2007 but not from Microsoft).
b1e95dc632