You will no longer receive e-mail notifications from this forum.
Log-In to post
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
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
How can I move the settings folder to another directory?I prefer a subdirectory like
Therefore Toad Data Modeler should automatically look at first in this customized location before the software looks atC:\Users\<username>\AppData\Roaming\Dell\Toad Data Modeler\
Another solution could be to pass a parameter at the commandline similar to
Is this somehow possible?
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)
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
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
Address : 018796F3
ID : 7215
Module Version : 220.127.116.11
Module Name: TMD.exe
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 18.104.22.168).
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?
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?
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
This question concerns Toad Modeler 22.214.171.124 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.
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\......") ?
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 ?
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
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 4select 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.
This question concerns Toad Data Modeler v126.96.36.199; 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;
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 188.8.131.52
Is there a way to place GO after each statement in the generated DDL?
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?