Vaclav: Your test script worked fine for a test. I modified it to support the data types for SQL 2005. This script almost worked as expected. On model create 2...
Hi, I have TOAD DM 2.5 and when I change the background color of an ERD, then export to an image, it loses the background color. Am I doing something wrong? ...
Hi, The background color is always set to white when you export your ERD to image - not to print large colored area and to prevent from troubles with printers....
Hi Greg, On line 30 in your excel sheet you have "Call Info " with white space at the end of the table name. The script doesn't trim the names, therefore you...
Thanks for your response Vladka. I am going to use TOAD to generate HTML documentation of our database. I would really like to have HTML image maps so that...
Hi, In some of my ERD diagrams, I would like to include synonyms and views. Is it possible for TOAD to load in synonyms or views when doing the reverse...
Hello Juraj, Synonyms and views are stored among Text objects (CTRL+T) and are not included in ERD directly. To load them during the RE, please select the Load...
Hi Juraj, I am going to use TOAD to generate HTML documentation of our database. I suppose you mean Toad Data Modeler. (Toad and TDM are two different ...
Hi Vladka, ... Very cool. I had originally downloaded TDM Trial, and then recently purchased TDM 2.25. It *looked* the same, so I didn't bother trying to...
For ongoing eval of TDM (using trial version 2.24) ... 1st of 2 questions: I do not see any easy way for editing an ER model. Specifically - I want to be able...
TDM Question 2: In the data dictionary functionality - I was expecting to be able to define allowed values for an attribute (or domain). I do not see any way...
Oracle supports views and synonyms, and sometimes a modeler would like to promote them from secondary objects to being first class entities. After all, the...
Hi, Do you know if TOAD DM supports project-specific paths? I work with many different models. When I export, each goes to a different folder. It's very...
Hello Juraj, Do you know if TOAD DM supports project-specific paths? No, it doesn't. I work with many different models. When I export, each goes to a different...
Hello, I do not see any easy way for editing an ER model. Specifically - I want to be able to select one or more attributes from an entity - and drag them to...
Hello Greg, To be honest, we're not sure what exactly you mean by 'allowed values'. Could you please write us more details? Nevertheless, in TDM there is not...
Vladka: Allowed Values: ActionFlag (in Entity1) has datatype: char(1). Allowed Values are "Y" or "N" If database is MySQL ... this can be supported by SET...
Good example - the same thing in Oracle would result in something like: create table junk ( action_flag char(1) not null check (upper(action_flag) in...
Thanks - Is it possible to support your Oracle example in script for SQL Server 2005 with current TDM? Is it something that can only be put in at forward...
This works fine ... only one attribute at a time is ok. This functionality was not obvious from documentation ... or from GUI - there is no focus on the...
Hello, Thanks for your examples. Firstly, we'd like to note that TDM supports only physical model with a physical and logical view on it. Logical model is not...
Hello again, Here we are with some other notes for you. You can write check constraints to particular attributes (as we wrote previously), or use User Defined...
Hello Greg, This functionality was not obvious from documentation ... Documentation to the 'How to copy and move attributes' issue is at your disposal in: *...
Thanks - Yes it is all there - once you know where to look. The casestudio movie is particularly good ... unfortunately, this has not been folded into the...
Thanks Vladka et. al. I need to test out what you have suggested with real examples from our application ... both for allowed values and more complex business...
Hello Greg, Thanks for your suggestions. I've forwarded them to our developers for consideration. Thanks again for your great co-operation! Have a nice day, ...
Hi all, I am using Toad data modeler. I have a script which i got by using Qdesigner. can i open it by TOAD data modeler.Please let me know. With Regards ...
Hello, If you mean SQL script, it's not possible to open it by TDM. However, TDM allows you to import models from QDesigner. Please see the Help file |...