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
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 v22.214.171.124; 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 126.96.36.199
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?
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”
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.
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?
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.
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.
It will be better to share domains between models. In addition, I also like to manage domains through an application. Thanks!
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.
Data Renovation, Oz.
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.
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.
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....
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?
I've used the "Default Values" dialog box to set default names and captions for new foreign key relationships, and that is very useful because I've failed to set all of our object names correctly in the past. I mistakenly assumed the "Defaults" item in the left pane of the Default Values was for new default constraints, but it's not. Is there some way to set the default name for new default constraints? For us, our naming convention demands that default constraints be named "df_[table name]_[column name]".
All of our models for SQL Server 2014.
Thanks for your help,
Hello, I have downloaded and installed the trial version of TDM 6.1 and after that decided to install freeware version. So, I uninstall trial version and installed freeware, but it still show me that it is trial version. How can I change from trial to freeware?
I found the "create index" won"t be in the DDL when the index name is the same as constraint name. I am using toad modeler to reverse engineer the DDL from the oracle database. Is there any way to force Toad modeler to have "create index" in the DDL generated?
Thanks for you help!