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

416 0 / Create an account to join the discussion.
mwilliams_109
Follow / 1 Jun 2010 at 6:20pm / Toad Data Modeler
Latest post by on 27 Mar 2017 at 7:38pm

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?
11049 2 / Create an account to join the discussion.
pstein
Follow / 27 Mar 2017 at 2:11pm / Toad Data Modeler

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

13 0 / 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?
4447 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 136 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

48 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

69 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

113 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

100 2 / Create an account to join the discussion.
a_valued_customer
Follow / 7 Feb 2014 at 11:18am / Toad Data Modeler
Latest post by on 6 Mar 2017 at 8:31am

Postgres model compare - Serial vs. Integer not detected correctl...

Expand content
Hello, when comparing an existing model against the database, TDM doesn't recognize serial/bigserial columns in the database correctly. If the columns in the model are defined as BigSerial and...

Hello,

when comparing an existing model against the database, TDM doesn't recognize serial/bigserial columns in the database correctly.

If the columns in the model are defined as BigSerial and the columns are created as such in the database, the model compare will incorrectly flag them as changed and display the reverse engineered columns as BigInt. Which is - strictly speaking - correct - but it's not really helpful. Technically the columns is a bigint but the both the JDBC driver  and pgAdmin can detect the fact that a column was defined as a bigserial, so it should be possible somehow to compare this correctly.

I'm using TDM 5.1 and Postgres 9.3

10303 3 / Create an account to join the discussion.
pmacek
Follow / 23 Feb 2017 at 11:16pm / Toad Data Modeler
Latest post by on 24 Feb 2017 at 4:12pm

How to avoid adding Entity to every Workspace tab

Expand content
Toad Team, This question concerns Toad Modeler 6.0.3.13 targeting Postgres. When adding an Entity (i.e., table), either by drag-n-dropping from the toolbar to a specific Workspace tab or right-clicking...

Toad Team,

This question concerns Toad Modeler 6.0.3.13 targeting Postgres.

When adding an Entity (i.e., table), either by drag-n-dropping from the toolbar to a specific Workspace tab or right-clicking + New on the Entities folder in the Physical Model Explorer, an unwanted byproduct is that the new Entity is added to all open Workspaces. Is there any way to turn off this behavior? Ideally if drag-n-dropping the Entity is only added to the target tab; and if right-clicking on the Entities folder then the Entity isn't added to any Workspace (open/tabbed or otherwise), rather I then should have to add it to a workspace as a second step.

Thanks,

Pete

Unanswered 140 2 / Create an account to join the discussion.
pstein
Follow / 11 Feb 2017 at 7:21am / Toad Data Modeler
Latest post by on 13 Feb 2017 at 6:35am

Where to specify paths to "Packages", "Scripts"...

Expand content
In v5.5-->Options---> Paths I successfully specified the paths to all (profile) folders like "Models", "Projects", "Galleries",.... However I miss some path entry...

In v5.5-->Options---> Paths

I successfully specified the paths to all (profile) folders like "Models", "Projects", "Galleries",....

However I miss some path entry fields for "Packages", "Scripts", "Selected OTPs"

These subfolders are  always automatically created here in a base folder D:\work\

I don't want them to be created here.

How can I (forever) move them to another location (e.g. to sub folders of  D:\uml\toaddata\myprofile\......") ?

Peter

Unanswered 194 1 / Create an account to join the discussion.
nakshatra_gupta
Follow / 9 Feb 2017 at 7:32pm / Toad Data Modeler
Latest post by on 10 Feb 2017 at 10:42am

Foreign Keys in TDM 6.1

Expand content
I have done reverse engineering of a schema by connecting to oracle db. This was successful & I was able to see the tables. Now I added 5 tables to my physical model, which I generated in step 1...

I have done reverse engineering of a schema by connecting to oracle db. This was successful & I was able to see the tables.

Now I added 5 tables to my physical model, which I generated in step 1.

I need to add foreign key to this model, which reference another schema on the same db. How can I add that ?

219 2 / Create an account to join the discussion.
thastings
Follow / 6 Feb 2017 at 3:56am / Toad Data Modeler
Latest post by on 8 Feb 2017 at 9:16am

How do I get an Alter script generation for two models for SQL ANYWHERE...

Expand content
Please help

Please help

285 6 / Create an account to join the discussion.
pmacek
Follow / 20 Jan 2017 at 5:07am / Toad Data Modeler
Latest post by on 22 Jan 2017 at 6:32pm

Postgres Model Schema Permissions

Expand content
In a Postgres model I've edited a given schema's properties, adding a particular user group on the "Permissions" tab. However, I can't seem to locate how to get that to generate the...
In a Postgres model I've edited a given schema's properties, adding a particular user group on the "Permissions" tab. 
However, I can't seem to locate how to get that to generate the expected SQL (e.g.
GRANT ALL ON SCHEMA my_schema TO my_role;).


Any suggestions?

Thanks,
Pete
 


Unanswered 303 2 / Create an account to join the discussion.
pmacek
Follow / 4 Jan 2017 at 10:33pm / Toad Data Modeler
Latest post by on 5 Jan 2017 at 2:18pm

PostgreSQL unique without AK and non-null restriction(s)

Expand content
In PostgreSQL, and in fact any "SQL standards"-complaint DBMS, one can insist on uniqueness for non-null values and at the same time allow repetition on null values. For instance, the following...

In PostgreSQL, and in fact any "SQL standards"-complaint DBMS, one can insist on uniqueness for non-null values and at the same time allow repetition on null values.

For instance, the following runs just fine:

create table uniqueness (
  col int unique
);

insert into uniqueness(col) values(null);
insert into uniqueness(col) values(1);
insert into uniqueness(col) values(null);
insert into uniqueness(col) values(2);

-- returns 4
select count(*) from uniqueness

However, within TDM there doesn't appear to be a way to effect the above when designing a table. Selecting the "Unique" checkbox but unselecting the "Not Null" doesn't appear to be allowed.

From the PG docs (my emphasis in bold):

In general, a unique constraint is violated if there is more than one row in the table where the values of all of the columns included in the constraint are equal. However, two null values are never considered equal in this comparison. That means even in the presence of a unique constraint it is possible to store duplicate rows that contain a null value in at least one of the constrained columns. This behavior conforms to the SQL standard, but we have heard that other SQL databases might not follow this rule. So be careful when developing applications that are intended to be portable.

-Pete

Unanswered 305 2 / Create an account to join the discussion.
pmacek
Follow / 2 Jan 2017 at 6:42pm / Toad Data Modeler
Latest post by on 4 Jan 2017 at 3:37pm

Postgres Dictionary Types

Expand content
This question concerns Toad Data Modeler v6.0.3.13; database is PostgreSQL. I'd like to define a new Dictionary Type (i.e., Postgres DOMAIN) in terms of an existing Dictionary Type. However, that...

This question concerns Toad Data Modeler v6.0.3.13; database is PostgreSQL.

I'd like to define a new Dictionary Type (i.e., Postgres DOMAIN) in terms of an existing Dictionary Type. However, that isn't supported in TDM, and the drop-down list of available types (whether intrinsic or user-defined) excludes Dictionary Types. Strictly speaking, this is a bug, as Postgres allows that (with the expected acyclic dependency caveats). In my particular case, it's forcing me to compromise my design.

For example, the following runs just fine:

CREATE DOMAIN my_base_type
  AS int;
ALTER DOMAIN my_base_type
  OWNER TO postgres;

CREATE DOMAIN my_sub_type
  AS my_base_type;
ALTER DOMAIN my_base_type
  OWNER TO postgres;

One utility of this is feature is the ability to attach additional CONSTRAINTs to the subtype. Another is the ability to use a subtype as a way to overload functions of the same name and achieve embellished or different behavior. For example:

CREATE OR REPLACE FUNCTION mult(i my_base_type) RETURNS my_base_type AS $$
        BEGIN
                RETURN i * 2;
        END;
$$ LANGUAGE plpgsql;

CREATE OR REPLACE FUNCTION mult(i my_sub_type) RETURNS my_sub_type AS $$
        BEGIN
                RETURN i * 3;
        END;
$$ LANGUAGE plpgsql;

Unanswered 311 2 / Create an account to join the discussion.
Denis.P.Daley
Follow / 29 Dec 2016 at 6:08pm / Toad Data Modeler
Latest post by on 2 Jan 2017 at 6:58am

Can I visually depict Attribute level changes within a data model

Expand content
Hi, I have reverse engineered the database and created a data model for our project. I have created new tables, modified existing tables, and used existing tables (unchanged) within the data model...

Hi,

I have reverse engineered the database and created a data model for our project.  I have created new tables, modified existing tables, and used existing tables (unchanged) within the data model diagram. I was able to set colors through Categories for 3 types of entities (New Entity, Existing Entity, and Modified Entity).  However, I also want to highlight the Columns/Attributes that have been changed so that visually they will stand out on the data model diagram.  Is there a way to accomplish this?

The version of Toad for Oracle that I am using is 12.10 and the version of Toad Data Modeler that i am using is 6.0.3.13

Thanks,

Denis

295 1 / Create an account to join the discussion.
dheadford
Follow / 20 Dec 2016 at 8:58pm / Toad Data Modeler
Latest post by on 21 Dec 2016 at 1:48pm

SQL adding GO after statements in DDL

Expand content
Is there a way to place GO after each statement in the generated DDL?

Is there a way to place GO  after each statement in the generated DDL?

Unanswered 316 2 / Create an account to join the discussion.
vishal1990
Follow / 15 Dec 2016 at 10:20am / Toad Data Modeler
Latest post by on 19 Dec 2016 at 7:13am

Getting error while generating RTF report and data model image

Expand content
Hello All, I'm trying to generate a RTF report for one of the schema data model but it is giving error even if I use administrators directory. "Access denied during accessing file <file_path...

Hello All,

I'm trying to generate a RTF report for one of the schema data model but it is giving error even if I use administrators directory.

"Access denied during accessing file <file_path\filename.rtf>"

Also getting below error while exporting model to image.

"There is not enough resources to complete this command"

Can anyone suggest me the solution for this errors?

Thanks,

Vishal.

Unanswered 305 1 / Create an account to join the discussion.