Toad Data Modeler Forum - Toad Data Modeler - Toad World
Danny Torres
Follow / 1 Nov 2016 at 1:33pm / Toad Data Modeler

We are now on Twitter!!! Contact a Technical Support expert today...

Expand content
Do you have a quick support question and short of time? Contact us Via Twitter @ QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

Do you have a quick support question and short of time? Contact us Via Twitter  @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

540 0 / Create an account to join the discussion.
marbleberg
Follow / 24 Jun 2013 at 5:41am / Toad Data Modeler
Latest post by on 26 May 2017 at 8:23am

Need to recover access database with superior solution to fix access...

Expand content
I have a task regarding access database. I and my organization is using access database to maintain my access files in well mannered way. But due to varied reasons access file showing error message Error...

I have a task regarding access database. I and my organization is using access database  to maintain my access files in well mannered way. But due to varied reasons access file showing error message

Error 3112: Your access database got corrupted will not be able to show the database.

Due to this error message I will not be able to access my access database. I don't have any idea how to recover access database or how to fix access database errors without affecting my original database????? Is there any relevant solution to repair access database?????

Unanswered 19653 27 / Create an account to join the discussion.
costabas
Follow / 25 May 2017 at 8:24pm / Toad Data Modeler
Latest post by on 26 May 2017 at 7:50am

re: the Generation dialog

Expand content
I thought of sharing my experience using the sql Generation Dialog. - It doesn't have a Close button at the bottom. Minor, but a bit annoying when I come to this dialog very often. - re: Actions...

I thought of sharing my experience using the sql Generation Dialog.

- It doesn't have a Close button at the bottom. Minor, but a bit annoying when I come to this dialog very often.

- re: Actions: I am not to sure how Actions are supposed to work. Every time I change a setting in that dialog I am scared that I am going to loose that setting so I end up saving the action - The problem is that it creates a new action every time even when I use the same name instead of overwriting the one with the same name and I end-up having to items with the same name in the Load Action drop-down. 

How about renaming Action to Generation Settings and changing the behaviour to overwrite the settings with the same name. Otherwise I have to use numbers, Action01, Action02 ... to know which one is the last one which becomes annoying when you make changes and re-generate the script often.

-Not all the foreign keys of the tables I selected are included. In the Referential Integrity tab I checked Always, so I thought all the foreign keys are selected from the tables I selected for generation but that's not true. I had to go Select List -> Relationships and check them there.

That's it for now with this dialog.

Overall, my experience with the tool has been so and so. This morning when I came, some changes I made yesterday were gone. I left the program running. Not sure what happened. Maybe there is no point in mentioning it, but what the heck. Now I got into a paranoid mode and I click Apply every time I have a chance and save very often.

39 1 / Create an account to join the discussion.
orangeCat
Follow / 24 May 2017 at 7:39pm / Toad Data Modeler
Latest post by on 25 May 2017 at 5:40pm

Freeware Toad Data Modeler

Expand content
I have been using Toad Data modeler freeware 32bit since Dec 2016. The 120 days limit is approaching and I'm trying to re-download as the site said - simply download. But am having difficulty, even...

I have been using Toad Data modeler freeware 32bit since Dec 2016. The 120 days limit is approaching and I'm trying to re-download as the site said -simply download. But am having difficulty, even though I have created an account with address, email, phone etc., updated my profile. When I complete the form to initiate the download, the submit button does not seem to work. It's possible it is rejecting my PostalCode, but it was accepted on the account creation. I see various references to Toad, Quest and Dell and am confused as to what or how these fit together.

I am on a few data base forums and participate with design and draft models. The freeware edition of TDM is very adequate for my use, and I would like to re download the latest version before my current freeware expires. I am a retired data management person.

Any info to clarify the terminology, and especially for how to get this freeware download sorted would be most welcome.

Thanks.

orangeCat

Unanswered 63 2 / Create an account to join the discussion.
costabas
Follow / 24 May 2017 at 12:56am / Toad Data Modeler
Latest post by on 24 May 2017 at 5:49pm

Captions for links between tables

Expand content
Is there a way to specify distinct captions for the two ends of a relationship between two tables in a physical model? As an example, from the video rental model, a Customer borrows movies, I wanted...

Is there a way to specify distinct captions for the two ends of a relationship between two tables in a physical model?

As an example, from the video rental model, a Customer borrows movies, I wanted to add one caption on the Customer side, Borrows, and on the other side, Borrowed by.

I used before ER/Studio from Embarcadero and you could add descriptions on both ends of a relationship. I was curious if you can do something similar in TDM. I find that sometimes having captions on both sides of a relationship can enhance the readability of the model.

Thank you

Update: I started to use Rectangle Labels. Is there another way?

Unanswered 69 2 / Create an account to join the discussion.
gnkurup
Follow / 19 May 2017 at 3:12pm / Toad Data Modeler
Latest post by on 22 May 2017 at 7:55am

Toad Data Modeler: Update Model from Database

Expand content
I am new to the Toad Data Modeler. I have created a couple for ERDs through this tool. I would say this is a wonderful tool. But after creating the ERDs, there are a couple of changes in the database....

I am new to the Toad Data Modeler. I have created a couple for ERDs through this tool. I would say this is a wonderful tool. But after creating the ERDs, there are a couple of changes in the database. I have designed the model in a printable format with great difficulty (as I am not a good designer). But once the change is made, I am not able to revise my ERD. I have tried it through Update Model from Database (I got this idea from a different thread)

https://www.toadworld.com/products/toad-data-modeler/f/30/t/2767

Unfortunately, that is not working for me. When I am trying with this. It is asking me to select the tables again from the scratch. Please let me know whether I am doing anything wrong or this is the way the tool behaves. Is there a better way to do that. If I am not clear, please go through the above link. I have the same question that he had.

Unanswered 85 3 / Create an account to join the discussion.
greg long
Follow / 10 May 2017 at 1:37am / Toad Data Modeler
Latest post by on 16 May 2017 at 9:43am

Can I use bracket for all field names in SQL code generation

Expand content
I have a client who insists on using some reserved words in their database that I'm rebuilding. Instead of having the argument about best practice and losing their confidence I'd like to be able...

I have a client who insists on using some reserved words in their database that I'm rebuilding. 

Instead of having the argument about best practice and losing their confidence I'd like to be able to add square brackets automatically around ALL entities/attributes when generating the SQL / ADO.

Is this possible?  

(I note Toad will delimit entities/attribute values that have spaces so I assume it's possible somehow).

Many thanks

Greg

137 11 / Create an account to join the discussion.
SPDToad
Follow / 26 Apr 2017 at 7:37am / Toad Data Modeler
Latest post by on 14 May 2017 at 7:50pm

Spell Checker

Expand content
Hi, I use the comments and descriptions options in my model to document my database. In SQL Server this information is subsequently added to custom properties in the database which I then extract into...

Hi,

I use the comments and descriptions options in my model to document my database. In SQL Server this information is subsequently added to custom properties in the database which I then extract into administrator reports.

Typos in those comments and descriptions are very bad so I am wondering if anyone has any suggestion for how to spell check these properties without having to cut-n-paste the text into another window.

Thanks

Steve

107 1 / Create an account to join the discussion.
pstein
Follow / 27 Mar 2017 at 2:11pm / Toad Data Modeler
Latest post by on 5 May 2017 at 10:42am

How to move folder AppData-Roaming-Dell-Toad-Data Modeler to other...

Expand content
I prefer to keep all components of a program together. Unfortunately Toad Data Modeler creates a settings folder C:\Users\<username>\AppData\Roaming\Dell\Toad Data Modeler\ while the main installation...

I prefer to keep all components of a program together.

Unfortunately Toad Data Modeler creates a settings folder

C:\Users\<username>\AppData\Roaming\Dell\Toad Data Modeler\

while the main installation folder is in

D:\tools\ToadDataModeler\

How can I move the settings folder to another directory?
I prefer a subdirectory like

D:\tools\ToadDataModeler\mysettings\

Therefore Toad Data Modeler should automatically look at first in this customized location before the software looks at
C:\Users\<username>\AppData\Roaming\Dell\Toad Data Modeler\

Another solution could be to pass a parameter at the commandline similar to

D:\tools\ToadDataModeler\\Bin\TDM.exe -settingsfolder="D:\tools\ToadDataModeler\mysettings\"

Is this somehow possible?

Peter

298 4 / Create an account to join the discussion.
a_valued_customer
Follow / 3 May 2017 at 7:28am / Toad Data Modeler
Latest post by on 4 May 2017 at 6:26am

Extremely slow loading of the forum

Expand content
... this might be because of the performance. Loading the landing page of the forum takes ages for me and usually doesn't finish unless I try multiple times. Sometimes it works if I login before...

... this might be because of the performance.

Loading the landing page of the forum takes ages for me and usually doesn't finish unless I try multiple times. Sometimes it works if I login before visiting the forum.

When tracing the network calls using wget I see this:

--2017-05-03 08:25:07--  www.toadworld.com/.../default.aspx
Resolving www.toadworld.com (www.toadworld.com)... 12.106.87.211
Connecting to www.toadworld.com (www.toadworld.com)|12.106.87.211|:80... connected.
HTTP request sent, awaiting response... 301 Moved Permanently
Location: www.toadworld.com/.../f [following]
--2017-05-03 08:25:08--  www.toadworld.com/.../f
Reusing existing connection to www.toadworld.com:80.
HTTP request sent, awaiting response... 200 OK
Length: 69159 (68K) [text/html]
Saving to: 'www.toadworld.com/products/toad-data-modeler/f/default.aspx'

www.toadworld.com/products/toad-data-modeler/f/de 100%[===============================================================================================================>]  67.54K   105KB/s   in 0.6s

Last-modified header missing -- time-stamps turned off.
2017-05-03 08:25:09 (105 KB/s) - 'www.toadworld.com/products/toad-data-modeler/f/default.aspx' saved [69159/69159]

Loading robots.txt; please ignore errors.
--2017-05-03 08:25:09--  www.toadworld.com/robots.txt
Reusing existing connection to www.toadworld.com:80.
HTTP request sent, awaiting response... 200 OK
Length: 69 [text/plain]
Saving to: 'www.toadworld.com/robots.txt'

www.toadworld.com/robots.txt                      100%[===============================================================================================================>]      69  --.-KB/s   in 0s

2017-05-03 08:25:09 (869 KB/s) - 'www.toadworld.com/robots.txt' saved [69/69]

--2017-05-03 08:25:09--  www.toadworld.com/.../layout.css
Reusing existing connection to www.toadworld.com:80.
HTTP request sent, awaiting response... Read error (Unknown error) in headers.
Retrying.

--2017-05-03 08:25:29--  (try: 2)  www.toadworld.com/.../layout.css
Connecting to www.toadworld.com (www.toadworld.com)|12.106.87.211|:80... connected.
HTTP request sent, awaiting response... Read error (Unknown error) in headers.
Retrying.

--2017-05-03 08:25:59--  (try: 3)  www.toadworld.com/.../layout.css
Connecting to www.toadworld.com (www.toadworld.com)|12.106.87.211|:80... connected.
HTTP request sent, awaiting response... Read error (Unknown error) in headers.
Retrying.

--2017-05-03 08:26:37--  (try: 4)  www.toadworld.com/.../layout.css
Connecting to www.toadworld.com (www.toadworld.com)|12.106.87.211|:80... connected.
HTTP request sent, awaiting response...

--2017-05-03 08:27:08--  (try: 5)  www.toadworld.com/.../layout.css
Connecting to www.toadworld.com (www.toadworld.com)|12.106.87.211|:80... connected.
HTTP request sent, awaiting response... Read error (Unknown error) in headers.
Retrying.

--2017-05-03 08:27:40--  (try: 6)  www.toadworld.com/.../layout.css
Connecting to www.toadworld.com (www.toadworld.com)|12.106.87.211|:80... connected.
HTTP request sent, awaiting response...

So there seems to be something wrong when loading the CSS file for the site.

90 1 / Create an account to join the discussion.
david.solomon
Follow / 29 Apr 2017 at 2:19pm / Toad Data Modeler
Latest post by on 29 Apr 2017 at 2:38pm

User Guides

Expand content
Hi everyone, New to Toad Data Modeler. Are there any user guides and tutorials I can download for 6.1. Thanks, Dave

Hi everyone,

New to Toad Data Modeler.   Are there any user guides and tutorials I can download for 6.1.

Thanks,

Dave

122 1 / Create an account to join the discussion.
rada
Follow / 26 Jul 2016 at 12:30pm / Toad Data Modeler
Latest post by on 20 Apr 2017 at 9:54am

TDM 6, Create entity and Attribute comments

Expand content
Hi, After I enter Model action, and I click Entities and check to generate Comments...and I close it....program doesn't keep this setting. Generating script from model action doesn't generate...

Hi,

After I enter Model action, and I click Entities and check to generate Comments...and I close it....program doesn't keep this setting.

Generating script from model action doesn't generate entity and attribute comments at all.

Tested on x86 version.

Any suggestions how to solve this?

Lubo.

1418 4 / Create an account to join the discussion.
sugee_jung
Follow / 6 Apr 2017 at 8:56am / Toad Data Modeler
Latest post by on 8 Apr 2017 at 3:25am

freeware version expired on 29/12/1899

Expand content
I just install toad data modeler freeware version today. When it first run program, I get "Invalid or expired freeware license". Can anyone help me,please.

I just install toad data modeler freeware version today.

When it first run program, I get "Invalid or expired freeware license".

Can anyone help me,please.

304 4 / Create an account to join the discussion.
mwilliams_109
Follow / 1 Jun 2010 at 6:20pm / Toad Data Modeler
Latest post by on 28 Mar 2017 at 2:33pm

Import Erwin Model into TDM3.5

Expand content
I have just installed TDM 3.5.10.4 and need to import a number of models already created in Erwin 4.1.4.4224. Firstly, I am not sure whether you should be able to import directly from the Erwin .ER file...
I have just installed TDM 3.5.10.4 and need to import a number of models already created in Erwin 4.1.4.4224. Firstly, I am not sure whether you should be able to import directly from the Erwin .ER file or should I forward engineer out of Erwin into some other format. Secondly, I cannot see any option in TDM for importing a Erwin file. The import option lets me select a connection to a database or to import a DDL file but no erwin option.

I have been told that you sould be able to import Erwin files but can't see how. Can anybody help?
11354 5 / Create an account to join the discussion.
Adam S
Follow / 13 Apr 2012 at 3:46pm / Toad Data Modeler
Latest post by on 21 Mar 2017 at 6:21am

Teradata Support

Expand content
Are there any plans to support Teradata?
Are there any plans to support Teradata?
4618 3 / Create an account to join the discussion.
Tommaso Sala
Follow / 15 Mar 2017 at 9:17am / Toad Data Modeler
Latest post by on 17 Mar 2017 at 8:45am

Removing a relation leaving its fields in the child table

Expand content
Hi, I'm trying to remove a relation from my ERD, but I want to leave its carried fields in the child table. In particular, I want to remove the relationship M20_PCL_F01 between parent M20_PCL_IDX...

Hi,

I'm trying to remove a relation from my ERD, but I want to leave its carried fields in the child table.

In particular, I want to remove the relationship M20_PCL_F01 between parent M20_PCL_IDX and child M20_PCL, but maintaining the field PCL_ID in the child (highlighted in the image).

Whenever I remove the relation, Toad automatically removes the field too.

Is there any solution? (besides re-adding the field manually... it is inherited by a number of descendant tables)

Answered 376 4 / Create an account to join the discussion.
a_valued_customer
Follow / 13 Mar 2017 at 8:51am / Toad Data Modeler
Latest post by on 13 Mar 2017 at 9:34am

Default HTML report doesn't show array columns

Expand content
When using arrays in Postgres, the default HTML report does not show this. E.g. a column defined as text[] (Type: Text, Is Array Type: true) is only shown as "Text" in the ER diagram and also...

When using arrays in Postgres, the default HTML report does not show this.  E.g. a column defined as text[]  (Type: Text, Is Array Type: true) is only shown as "Text" in the ER diagram and also as "Text" in the Entities list. There is no indication at all that the column is an array.

It would also be nice if that was shown in the WorkSpace as well, e.g. as Text[] instead of just Text

214 1 / Create an account to join the discussion.
shango.gs
Follow / 12 Mar 2017 at 12:24am / Toad Data Modeler
Latest post by on 13 Mar 2017 at 9:17am

Getting Access violation at address 018796F3 in module TDM.exe. Read...

Expand content
Please help me troubleshoot this exception.I am trying to convert Logical data model to physical data model. I have a few many to many relationships in the LER model.I will be unable to paste the log from...

Please help me troubleshoot this exception.I am trying to convert Logical data model to physical data model. I have a few many to many relationships in the LER model.I will be unable to paste the log from the company TOAD data modeler software installation .

Getting Access violation at address  018796F3 in module TDM.exe. Read of address 00000000

Exception details,

Address : 018796F3 

ID : 7215

Module Version : 5.5.3.20

Module Name: TMD.exe

255 1 / Create an account to join the discussion.
dan.anselm
Follow / 8 Mar 2017 at 10:45am / Toad Data Modeler
Latest post by on 9 Mar 2017 at 9:35am

Comparing Model To SQL Server 2016 Database

Expand content
Hi, I've just moved to SQL 2016 and done a simple data model which i then used to generate a script to build the database tables (using TDM 6.1.3.26). However, without making any changes to either...

Hi,

I've just moved to SQL 2016 and done a simple data model which i then used to generate a script to build the database tables (using TDM 6.1.3.26).

However, without making any changes to either model or db, when I do a compare I get a large number of differences which can basically be summarised as the same set of 5 or 6 fields per table:-

 - Attribute collation - this is not set in the model, but the compare has detected the collation applied and flagged it as a difference

 - Entity index properties (5 spatial properties set in model, but not in db and type of index set as relational in db but not in model)

I know I can remove these fields in the advanced settings, but there seems to be no way for this settings change to be remembered for the next time and it is quite laborious to have to keep unchecking all these item boxes (not to mention the large possibility of making a mistake!).

So is there any way to have the compare tool remember these settings changes for future compares?

Alternatively, is there any way to set up defaults when creating model items so that at least the model side doesn't add anything in that doesn't seem to be used by SQL 2016 (spatial fields, collation)? If so, can this be applied retrospectively to an existing model or will it only work for new models and items?

Thanks

Dan

298 4 / Create an account to join the discussion.
dan.anselm
Follow / 7 Mar 2017 at 10:31am / Toad Data Modeler
Latest post by on 7 Mar 2017 at 5:25pm

Data Dictionary - Can We See Lower Level Objects In A List

Expand content
Hi, I know inside the model menu (model items submenu) we can bring up lists up entities, relationships, etc. But is there a way of getting lists of lower level objects like indexes, fields/attributes...

Hi,

I know inside the model menu (model items submenu) we can bring up lists up entities, relationships, etc. But is there a way of getting lists of lower level objects like indexes, fields/attributes and keys?

Thanks

Dan

299 2 / Create an account to join the discussion.