Toad Data Modeler - Beta

Toad Data Modeler Beta Program Community

Beta Community Discussion

Sergei Agalakov
Follow / 5 Feb 2014 at 10:38pm / Toad Data Modeler Beta Program
Latest post by on 15 Oct 2014 at 11:35am

Postgres DDL generation's errors

Expand content
Currently an order of the object's generation for Postgresql is incorrect. I work with Postgresql 9.2 but the same issue will exist for other versions. The roles are generated almost at the end of...

Currently an order of the object's generation for Postgresql is incorrect. I work with Postgresql 9.2 but the same issue will exist for other versions. The roles are generated almost at the end of the script, but schema is generated at the very beginning. The problem is that schema may require an authorization associated with the role like 

CREATE SCHEMA "test_schema" AUTHORIZATION "test_application_admin"


This statement will fail because role "test_application_admin" wasn't yet created. I suggest to create roles first, but to leave a section that grants permissions to the roles at the end of the DDL script.

The second problem is that script tries to create without pre-existence check even standard and pre-defined schemas and roles like 

CREATE SCHEMA "public" AUTHORIZATION "postgres"
;

CREATE SCHEMA "pg_catalog"
;

CREATE ROLE "postgres" LOGIN
;

These statements will just generate error messages.

280 5 / Create an account to join the discussion.
widipa
Follow / 31 Oct 2008 at 6:00am / Toad Data Modeler Beta Program
Latest post by on 9 Oct 2014 at 11:45am

TDM for Linux?

Expand content
Hello. TDM exists for Linux?

Hello.

TDM exists for Linux?

2669 3 / Create an account to join the discussion.
trapneto
Follow / 12 May 2011 at 3:58pm / Toad Data Modeler Beta Program
Latest post by on 18 Sep 2014 at 3:32pm

TDM 4.0.5.10: Views with LEFT JOIN or UNION?

Expand content
Can you do LEFT JOIN and UNION in TDM 4.0.5.10 VIEWs? - Tom
Can you do LEFT JOIN and UNION in TDM 4.0.5.10 VIEWs?

- Tom
810 4 / Create an account to join the discussion.
dpost_562
Follow / 12 Oct 2010 at 8:00pm / Toad Data Modeler Beta Program
Latest post by on 18 Sep 2014 at 11:52am

In full Screen mode - need back out of it...ARG

Expand content
Anyone know how to get OUT of the full screen mode in 3.6 data modeler? Nothing seems to work, tried escape, tried all the options when right clicking, tried function buttons. 10 years of data modeler...

   Anyone know how to get OUT of the full screen mode in 3.6 data modeler?  Nothing seems to work, tried escape, tried all the options when right clicking, tried function buttons.  10 years of data modeler and this tool frustrates me to know end!

764 4 / Create an account to join the discussion.
Sergei Agalakov
Follow / 12 Sep 2014 at 6:20pm / Toad Data Modeler Beta Program
Latest post by on 18 Sep 2014 at 8:55am

Recommendations for PostgreSQL

Expand content
Thank you for adding new data types (daterange etc.) What I do miss: EXTERNAL storage parameter for columns, e.g. ALTER TABLE "public"."t1" ALTER COLUMN "col1" SET STORAGE...

Thank you for adding new data types (daterange etc.)

What I do miss:

EXTERNAL storage parameter for columns, e.g. ALTER TABLE "public"."t1" ALTER COLUMN "col1" SET STORAGE EXTERNAL

 

Thank you,

Sergei

171 3 / Create an account to join the discussion.
Sergei Agalakov
Follow / 16 Sep 2014 at 4:16pm / Toad Data Modeler Beta Program
Latest post by on 17 Sep 2014 at 8:43pm

A bug with SQL parsing: key words are analized inside text constants

Expand content
In Entity Properties in SQL Preview parser considers key words inside comments. As you can see on the attached picture the from word is analyzed inside a text constant, and collapse nodes were added due...

In Entity Properties in SQL Preview parser considers key words inside comments. As you can see on the attached picture the from word is analyzed inside a text constant, and collapse nodes were added due to this bug.

88 2 / Create an account to join the discussion.
Sergei Agalakov
Follow / 16 Sep 2014 at 4:25pm / Toad Data Modeler Beta Program
Latest post by on 17 Sep 2014 at 12:14pm

SQL parsing bug: collapse nodes are added without any visible logic

Expand content
I don't see any logic in how TDM adds collapse nodes for SQL text. The correct behavior for the same text can be observed in Notepad++ :

I don't see any logic in how TDM adds collapse nodes for SQL text. The correct behavior for the same text can be observed in Notepad++ :

112 1 / Create an account to join the discussion.
Sergei Agalakov
Follow / 12 Sep 2014 at 7:11pm / Toad Data Modeler Beta Program
Latest post by on 17 Sep 2014 at 7:51am

All new entities are automatically added to Work Space "All Items"

Expand content
It may be by design, but I think it should be a configurable option at least. After all you can remove a graphical symbol of an entity from "All Items" work space, so why then mandatory add all...

It may be by design, but I think it should be a configurable option at least. After all you can remove a graphical symbol of an entity from "All Items" work space, so why then mandatory add all new entities created in other work spaces to "All Items"?

127 3 / Create an account to join the discussion.
Sergei Agalakov
Follow / 12 Sep 2014 at 7:04pm / Toad Data Modeler Beta Program
Latest post by on 16 Sep 2014 at 3:58pm

In Physical Model Explorer it is impossible to filter by schema (at...

Expand content
It will be nice to be able to see only objects (entities, functions etc.) only from selected schemas. Currently all functions, for example, are in one list even if they belong to the different schemas...

It will be nice to be able to see only objects (entities, functions etc.) only from selected schemas. Currently all functions, for example, are in one list even if they belong to the different schemas. It should be very useful for all databases that have concept of a schema.

 

95 2 / Create an account to join the discussion.
Sergei Agalakov
Follow / 12 Sep 2014 at 6:35pm / Toad Data Modeler Beta Program
Latest post by on 16 Sep 2014 at 3:49pm

Generic recommendation for improvement of Verification Log

Expand content
It would be nice to add a filter to Verification Log for a model at least for warnings. Sometimes it makes sense to create tables without PK for example, and for them I want to create an exception list...

It would be nice to add a filter to Verification Log for a model at least for warnings.

Sometimes it makes sense to create tables without PK for example, and for them I want to create an exception list in the Verification Log for a model. The new tables should be warned against until they are manually added to the ''please don't warn me about them'' list.

It is akin how it is done for Windows updates for example. If you want to ignore some particulare update you can 'hide' it so it will not pop-up every time.

 

Sergei

116 2 / Create an account to join the discussion.
MIhabT
Follow / 8 Mar 2014 at 12:59pm / Toad Data Modeler Beta Program
Latest post by on 12 Sep 2014 at 6:44pm

Modeler Bug: Entity & Relationship Properties inconsistent in...

Expand content
Not sure if this is the right way to post some bugs found in the Beta version (or potentially exist in the current one), please let me know if I'm missusing this forum: * On changing foreign key...

Not sure if this is the right way to post some bugs found in the Beta version (or potentially exist in the current one), please let me know if I'm missusing this forum: 

* On changing foreign key to not-null in entity properties, it should reflect in the relationship as ‘parent mandatory’, and vice versa.  It works only if you set parent mandatory and gets reflected as not null, but all other permutations of change doesn’t work i.e. setting it not null doesn’t reflect as parent not mandatory ..etc.

297 3 / Create an account to join the discussion.
Lukas
Follow / 9 Jul 2014 at 10:14pm / Toad Data Modeler Beta Program
Latest post by on 10 Jul 2014 at 9:16am

Toad Data Modeler 5.3.2.4 BETA released!

Expand content
Hi All, The new BETA 5.3.2.4 is available for download now bringing you several new features and enhancements. Support for DB2 v.10.5 (LUW). New Model Actions window available for all Synchronization...

Hi All,

The new BETA 5.3.2.4 is available for download now bringing you several new features and enhancements.

  • Support for DB2 v.10.5 (LUW).
  • New Model Actions window available for all Synchronization options, management of saved settings and execution of saved settings or new actions.
  • Synchronization options buttons available on the application toolbar.
  • Alter Script generation- Use Temporary Tables options are now available for Oracle Databases in Settings and in generator.
  • New Filter bar added in
    • Model Explorer- and also object group dialogs
    • Category Properties.

  • Indexes to Foreign Keys generation- Manage generation of indexes to FKs in the Relationship Properties dialog (see options in Settings | Options | Model Physical Model).

Any feedback especially on the new features is appreciated!

Thank you!

Lukas & TDM Team

250 1 / Create an account to join the discussion.
BillR
Follow / 27 Mar 2007 at 2:42am / Toad Data Modeler Beta Program
Latest post by on 2 Jun 2014 at 6:57am

Postgres

Expand content
Can someone please confirm that Postgres is not supported as the documentation indicates?

Can someone please confirm that Postgres is not supported as the documentation indicates?

1050 7 / Create an account to join the discussion.
vladka
Follow / 10 Mar 2014 at 3:01pm / Toad Data Modeler Beta Program

Toad Data Modeler BETA 5.2.5.2 Released

Expand content
Hi, Let me announce another Beta release - Toad Data Modeler BETA 5.2.5.2. This Beta brings the following enhancements: Unhide Line - New option to display parts of relationship lines hidden behind...

Hi,

Let me announce another Beta release - Toad Data Modeler BETA 5.2.5.2.

This Beta brings the following enhancements:

  • Unhide Line - New option to display parts of relationship lines hidden behind entity/view boxes. See the new icon on the toolbar or right-click the line | Line Style | Unhide Line.
  • MS SQL 2005, 2008, 2012 - Extended Properties supported
  • Oracle 12c - Reverse engineering - TCP/IP supported and DDL Script reverse engineering supported.  (Note: The "Temporal Validity support for table" (PERIOD FOR) is not loaded.)
  • Silent installation - New parameters CHECKFORUPDATES=0 and SUPPRESSCOLLECTUSAGESTATFIRSTRUN=1
  • other minor enhancements and fixes.

Toad Data Modeler BETA expires on 12 July 2014.

Regards,

Vladka + TDM Team

169 0 / Create an account to join the discussion.
omar.flores_062
Follow / 25 Feb 2014 at 4:11pm / Toad Data Modeler Beta Program
Latest post by on 4 Mar 2014 at 6:59am

TDM Access violation at address 012D7322 in module 'TDM.exe'...

Expand content
Anytime I am trying create a new model or to open an existing one, I get an error message: Access violation at address 012D7322 in module 'TDM.exe'. Read of address 0000000C. I am running Windows...

Anytime I am trying create a new model or to open an existing one, I get an error message: Access violation at address 012D7322 in module 'TDM.exe'. Read of address 0000000C.  I am running Windows 7 Pro 64 bits, TDM 4.2.6.12 on a permanent licencse.  So far, the software is useless, there is nothing I can do with it, please help!

965 12 / Create an account to join the discussion.