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

376 0 / 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 79 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 ?

104 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

169 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 199 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 210 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 221 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

208 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 225 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 219 1 / Create an account to join the discussion.
LALIT KUMAR B
Follow / 8 Aug 2016 at 11:00am / Toad Data Modeler
Latest post by on 3 Dec 2016 at 6:51am

TDM 6.0 fails to open GUI on Linux using Wine

Expand content
Hi, I have been using TDM 5.5 on Linux using Wine to generate DDL by invoking a Jscript file which is a simple ActiveXObject("TDM.App") call. After I upgraded to version 6.0 64-bit, I ran...

Hi,

I have been using TDM 5.5 on Linux using Wine to generate DDL by invoking a Jscript file which is a simple ActiveXObject("TDM.App") call. After I upgraded to version 6.0 64-bit, I ran into a bug which I have posted here. The workaround provided is to use 32-bit. Now, I have run into another bug using 32-bit as well.

Issue: TDM 6.0 32-bit fails to open GUI and/or generate DLL script on Linux using Wine. It pops up an error dialog box saying “OLE error….WbemScripting.SWbemLocator”. Any action on the dialog box closes the application. Although, there were no issues with TDM 5.5

 

Workaround: We found a workaround, Toad 6.0 install doesn’t register a TDM.App ActiveX object. Nothing in the registry at all to indicate that such a thing exists.

Administrator command prompt

  cd “\Program Files\Dell\Toad Data Modeler  6.0\Bin”

  tdm /regserver

 

That’s for 32 bit windows build. If 64 bit windows look in Program Files (x86).

 

After that I saw TDM.App in registry and script ran.


Question: Is there a fix already pipelined and is this the best workaround for the issue? Please suggest ASAP as it has impacted our business and some critical tasks are stalled.

 

Regards,

Lalit

1146 3 / Create an account to join the discussion.
ken0stamper
Follow / 30 Nov 2016 at 10:00pm / Toad Data Modeler
Latest post by on 1 Dec 2016 at 1:21pm

Naming convention rules for sequences

Expand content
I'm converting a model from SQL 2014 to Oracle 12c. When I generate DDL the sequence names for primary keys are created as Seq_tablename_pk_ID. I'd like to change the prefix and suffix. I looked...

I'm converting a model from SQL 2014 to Oracle 12c.  When I generate DDL the sequence names for primary keys are created as Seq_tablename_pk_ID. I'd like to change the prefix and suffix.

I looked in the Naming Convention Properties -- Naming Convention Rules.  I don't see sequences as an object type that I can alter.  Is this managed somewhere else?

327 2 / Create an account to join the discussion.
credis@resolutemgmt.com
Follow / 16 Nov 2016 at 8:34pm / Toad Data Modeler
Latest post by on 21 Nov 2016 at 12:35pm

Additional script objects

Expand content
I've got a data model that I'm using for a project I'm working on that's part of a large application. My model has the entities I've created, the relationships, etc. I've been using...

I've got a data model that I'm using for a project I'm working on that's part of a large application.  My model has the entities I've created, the relationships, etc.  I've been using the before/after scripts in the entities for some data setup and in the model itself for some additional deployment-related tasks.  I also need to setup a SQL Agent job as part of the project and was looking for a convenient way to incorporate the script that generates it into the TDM.  If you've seen one of these scripts, they're a bit unwieldy and I'd prefer not to include it in the model before/after script section.  Is there any other place in the TDM where something like this could fit?  I realize it's not directly related to the model in the traditional sense, but I've found that keeping everything I'm doing SQL-related in one place has a number of benefits.

Thanks,

Casey

Unanswered 451 3 / Create an account to join the discussion.
mary.stamper_062
Follow / 16 Nov 2016 at 4:20pm / Toad Data Modeler
Latest post by on 21 Nov 2016 at 10:58am

Transferring all Settings to another installation

Expand content
I have a new person joining my team and I need to duplicate my toad installation on another computer. Is there any systematic method for transferring all TDM settings from one computer to another, such...

I have a new person joining my team and I need to duplicate my toad installation on another computer. 

Is there any systematic method for transferring all TDM settings from one computer to another, such that the same model document opens exactly the same way on both computers?

I can't believe that there isn't an easier way to do this than what it seems that I am having to do.

387 1 / Create an account to join the discussion.
toad2017
Follow / 17 Nov 2016 at 2:49am / Toad Data Modeler
Latest post by on 21 Nov 2016 at 8:02am

Can we export/import the domains?

Expand content
It will be better to share domains between models. In addition, I also like to manage domains through an application. Thanks!

It will be better to share domains between models. In addition, I also like to manage domains through an application. Thanks! 

383 1 / Create an account to join the discussion.
greg long
Follow / 16 Nov 2016 at 1:04am / Toad Data Modeler
Latest post by on 21 Nov 2016 at 7:26am

TDM - Seeking guidance / experiences in options for Working Directory...

Expand content
Hi TDM Community I'm looking for advice on the three alternatives for configuring the "Working Directory and Project Structure" when creating a new Toad project with version control. ...

Hi TDM Community

I'm looking for advice on the three alternatives for configuring the "Working Directory and Project Structure" when creating a new Toad project with version control.

The only docs I've found discusses only the recommended option "Project and Repostory Structures are Identical (Recommended)".

I'm attempting to 'import' existing folder structures into SVN Projects and then adding Toad-specific resources to each Project. Toad's insistence on importing files to the Project can only be (reliably) avoided by having all project content - admin, comms, finance, etc., under the one top-leve Project folder and then using Toad's version control rather than having two version handlers - one for Toad content and one for all the rest of the project resources.

I've tested a few alternative structures, but found a new problem for which I'm creating a 'Case' ie. folders named "DEV" and "SOURCE" and probably some others look to be Toad Reserved Words and so Toad will not list such Folders when user attempts top add folders to the Project ... support case in prep for TDM 6.1.

Any advice/experience on configuring structures for new Projects with version control using the three alternatives would be very welcome.

Greg

Data Renovation, Oz.

475 3 / Create an account to join the discussion.
mary.stamper_062
Follow / 15 Nov 2016 at 9:18pm / Toad Data Modeler
Latest post by on 16 Nov 2016 at 9:44am

DDL Script Generation parameters and actions lost when converting...

Expand content
Why should these settings be lost? Is there any way to preserve them during the conversion? I would also like to be able to share these settings with a colleague.

Why should these settings be lost? Is there any way to preserve them during the conversion? I would also like to be able to share these settings with a colleague.

405 1 / Create an account to join the discussion.
jzhou
Follow / 14 Nov 2016 at 4:14pm / Toad Data Modeler
Latest post by on 15 Nov 2016 at 1:31pm

How can I generate DDL script per table

Expand content
Currently, I can generate a big sql script file for all entities: Model -> Generate DDL Script... However, I would like to generate sql script for each entity. This will fit our code review process...

Currently, I can generate a big sql script file for all entities:

Model -> Generate DDL Script...

However, I would like to generate sql script for each entity. This will fit our code review process.

Please advise!

Thanks!

Answered 545 8 / Create an account to join the discussion.
toad2017
Follow / 15 Nov 2016 at 12:50am / Toad Data Modeler
Latest post by on 15 Nov 2016 at 7:24am

Can we save the model into multiple files?

Expand content
It will be better to split up one model into multiple files. This will allow several developers to simultaneously edit different parts of a single model while they still can share the common definitions...

It will be better to split up one model into multiple files. This will allow several developers to simultaneously edit different parts of a single model while they still can share the common definitions such as domain, rules, etc.... 

Unanswered 423 1 / Create an account to join the discussion.
mail8mz
Follow / 3 Nov 2016 at 8:32pm / Toad Data Modeler
Latest post by on 4 Nov 2016 at 8:25am

How to ignor constraint name generated by system

Expand content
Hi, I reverse a model from an oracle database, and then compare the model with backup database. The oracle database generate a constraint name for any column not null, such as SYS_C009999. Then I always...

Hi,

I reverse a model from an oracle database, and then compare the model with backup database. The oracle database generate a constraint name for any column not null, such as SYS_C009999. Then I always has the difference between the model and the backup database.

Is there any way to ignore the constraint name generated by system when I use toad modeler to compare the model with the backup database?

Thanks!

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