Toad Data Modeler - Beta

Toad Data Modeler Beta Program Community

Beta Community 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

61 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?

929 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

136 0 / Create an account to join the discussion.
MIhabT
Follow / 8 Mar 2014 at 12:59pm / Toad Data Modeler Beta Program
Latest post by on 10 Mar 2014 at 9:40am

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.

176 2 / 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!

457 12 / Create an account to join the discussion.
vladka
Follow / 25 Nov 2013 at 1:39pm / Toad Data Modeler Beta Program
Latest post by on 3 Mar 2014 at 9:34am

Toad Data Modeler BETA 5.2.3.8 Released

Expand content
Hi everybody, I'm pleased to announce new release of Toad Data Modeler BETA 5.2.3! Except for a couple of bug fixes, this BETA release brings lots of improvements and changes in GUI. I'm sure...

Hi everybody,

I'm pleased to announce new release of Toad Data Modeler BETA 5.2.3!

Except for a couple of bug fixes, this BETA release brings lots of improvements and changes in GUI. I'm sure you already noticed some of them in previous Beta, e.g. new lines...
Nevertheless, let me announce them officialy and point your attention to them. Smile

Here's a brief list of enhancements:
* Export, Import Microsoft Excel - Export/Import feature is available for active data model and the resulting XLSX file includes individual worksheets for Entities, Attributes, Relationships and Data Types for the model. There, you can add comments and notes and modify or specify other properties. The modified Excel file can be imported back to Toad Data Modeler.

To export your model:
Select File | Export | Export to Excel…

 To import the data back to Toad Data Modeler:
Select File | Import | Import from Excel…

* New Relationship Lines Management System
Lines are right-angled only. You can move them and their parts as you need (vertically and horizontally). Anchor points are no longer fixed on entity boxes but you can alter them as you need (column to column alignment is possible now). You can add handle points (press CTRL) and this way you can select parts of line you need to delete or move.

* Snap to Objects - automatic align among objects on the workspace.
When you move an object on the workspace (e.g. entity or relationship line), a light blue line will display and you will be able to align the object to other objects in ERD easily.
The Snap to Objects option is on by default - see the new icon on the toolbar or Settings | Options | Graphics. There, you can turn this function off. To turn it off for a particular moment while working in your ERD, press and hold ALT Key.

* Import and Export Settings defined in the Options dialog - This option allows you to import/export the settings (particularly helpful for already defined paths) e.g. for side by side installation of TDM or to/from TDM on another PC. Also, you can restore the default settings easily. See the new buttons in the Options dialog.

* Possibility to hide Not Null and Key Marks (Object Format dialog | Entity tab)
* Go to Parent, Go to Child right-click options for relationships
* Button Add Workspace beside Tabs
* Possibility to close X every workspace
etc.

So, do not hesitate to explore and test these new great features. We can't wait for your feedback and other suggestions (even those that might appear to be unimportant or little).
Happy modeling with TDM! :)

Vladka and TDM Team

528 4 / Create an account to join the discussion.
Sergei Agalakov
Follow / 5 Feb 2014 at 10:38pm / Toad Data Modeler Beta Program
Latest post by on 10 Feb 2014 at 10:12am

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.

159 3 / Create an account to join the discussion.
Doron Enav
Follow / 24 Oct 2013 at 7:17pm / Toad Data Modeler Beta Program
Latest post by on 25 Oct 2013 at 10:20am

Data Modeler Beta License

Expand content
I tried installing the TBM Beta and it asked for a License. How do I acquire the license?

I tried installing the TBM Beta and it asked for a License.

How do I acquire the license?

200 1 / Create an account to join the discussion.
T Schnack
Follow / 17 Sep 2013 at 2:49pm / Toad Data Modeler Beta Program
Latest post by on 27 Sep 2013 at 9:28am

Auto-label relationship lines without programming?

Expand content
I would love to be able to auto-label the relationship lines with the parent column and/or child column name. As far as I know, the only way to do this is programmatically / via a macro, correct?

I would love to be able to auto-label the relationship lines with the parent column and/or child column name.  As far as I know, the only way to do this is programmatically / via a macro, correct?

186 1 / Create an account to join the discussion.
Michal.K
Follow / 9 Aug 2013 at 2:08pm / Toad Data Modeler Beta Program
Latest post by on 9 Aug 2013 at 3:13pm

removing field does not remove related index

Expand content
I'm not sure it is feature or bug. I consider it as bug because it's makes very annoying to find out all such issues. So, the scenario to reproduce is as follows: 1. add field to table 2...

I'm not sure it is feature or bug. I consider it as bug because it's makes very annoying to find out all such issues.

So, the scenario to reproduce is as follows:

1. add field to table

2. create index based on this field

3. remove the field from table.

Generate SQL script: you will get incomplete index creation definition which ends up with error during deployment.

IMO such index should be also removed. It might be supported by additional request "are you sure".


AFAIK, the same issue will appear in regard to foreign keys or relation between trigger and trigger function. (you can remove trigger function and left trigger non functional.

BTW: I know I can test structure before rendering model to SQL. In that case I spend a lot of time to find "Verification Log" (I was looking for files). Finally I figured out it is a subwindow of TDM app, however the window has been moved down to lower edge of app window makes impossible to notice it. IMO it should popup after verification showing verification results


Found in latest beta (5.0.2.11)

with regards

152 1 / Create an account to join the discussion.
JFischer_484
Follow / 1 May 2013 at 7:56pm / Toad Data Modeler Beta Program
Latest post by on 10 May 2013 at 5:35am

RE Selection Ignored?

Expand content
I did a reverse engineering on a DB with multiple schemas. I selected the tables in one schema. It is a small schema - only 20 tables. The selection criteria lists Selected 20 of xxx Tables / 20 of xxx...
I did a reverse engineering on a DB with multiple schemas.  I selected the tables in one schema.  It is a small schema - only 20 tables.  The selection criteria lists Selected 20 of xxx Tables / 20 of xxx All Objects. 

I then clicked on Execute.

TDM thought and thought, and then thought some more.  After a few minutes, I stepped away from my desk, and did  something else.  When I came back, TDM had a little dialog saying that it was finished.

I looked at what it had wrought.  It had RE'd the entire DB!  Not just that one little schema!  No wonder it took so long...

Why did it ignore my selections in the RE dialog box, and bring in every single object in the DB?
421 1 / Create an account to join the discussion.
quest_265
Follow / 2 May 2013 at 3:27pm / Toad Data Modeler Beta Program
Latest post by on 2 May 2013 at 9:22pm

Is the latest beta really over 2 years old?

Expand content
I notice that the posting date for the beta notification was in February of 2011. Is there really nothing newer? And, since the version numbering is higher than the current commercial release version of...
I notice that the posting date for the beta notification was in February of 2011. Is there really nothing newer? And, since the version numbering is higher than the current commercial release version of 4.3.3.6, does this mean that there are actually improvements and bug fixes in the 2+ year old beta that are not in the current commercial release? Which one should I really be using?

When will a 5.0 non-beta version be out?
822 1 / Create an account to join the discussion.
roddyt
Follow / 30 Apr 2013 at 3:35am / Toad Data Modeler Beta Program
Latest post by on 30 Apr 2013 at 4:12am

version number?

Expand content
What is going on with the versions? I haven't played with a beta version in a while. It looks like you started this year at 4.4, but now you're up to 5.0. 4.3 appears to still be the latest release...

What is going on with the versions? I haven't played with a beta version in a while. It looks like you started this year at 4.4, but now you're up to 5.0. 4.3 appears to still be the latest release, so what hapened to 4.4?

2307 2 / Create an account to join the discussion.
bpmc
Follow / 27 Apr 2013 at 6:58pm / Toad Data Modeler Beta Program

Illegal comments in generated DDL

Expand content
For DB2, top of file contains some garbage characters and then a /* ... */ comment, which is not legal syntax for the DB2 CLP.
For DB2, top of file contains some garbage characters and then a /* ... */ comment, which is not legal syntax for the DB2 CLP.
2592 0 / Create an account to join the discussion.
paul.crompton_375
Follow / 24 Apr 2013 at 2:35pm / Toad Data Modeler Beta Program
Latest post by on 27 Apr 2013 at 3:27am

Out of Memory when merging two large Models

Expand content
I am trying to merge two large data models and I am getting an Out of Memory Error. I'm using Windows 7 (64 bit) and TDM 4.3.3 It works on my medium sized models but not the large models. I have 8GB...

I am trying to merge two large data models and I am getting an Out of Memory Error.  I'm using Windows 7 (64 bit) and TDM 4.3.3  It works on my medium sized models but not the large models.  I have 8GB of memory and it never gets about 4GB used. 

I tried to download the beta but getting a HTTP 404 error on the beta page.

Thanks in advance,

6020 5 / Create an account to join the discussion.