Toad Data Modeler - Beta Forum - Toad Data Modeler Beta Program - Toad World

Toad Data Modeler - Beta Forum

Toad Data Modeler Beta Program Community

Community Discussion

asharovarov
Follow / 8 Sep 2016 at 2:32am / Toad Data Modeler Beta Program
Latest post by on 12 Sep 2016 at 2:43pm

Generate Chaneg Script includes objects which weren't selecte...

Expand content
TDM Version: 6.1.2.10 Server: SQL Server 2014 / SQL Server 2016 On a model with 100+ tables with lot of changes (5-10 tables, new columns) "Model\Generage Change Script" includes objects...

TDM Version:  6.1.2.10

Server: SQL Server 2014 / SQL Server 2016

On a model with 100+ tables with lot of changes (5-10 tables, new columns) "Model\Generage Change Script" includes objects which weren't selected:

Steps to reproduce:

  1. Choose to "Model\Generage Change Script" 
  2. Unselect All differences, then Expand all changes to see details on the review screen.
  3.  Then select several tables with change and generate script 
  4. Script would include table changes which weren't selected
215 5 / Create an account to join the discussion.
sykiemikey
Follow / 9 Sep 2016 at 3:15pm / Toad Data Modeler Beta Program
Latest post by on 12 Sep 2016 at 6:14am

Order of Generated Objects

Expand content
Using 64 bit version. The list does not seem to retain my changes. Also, it has multiple headers for the same thing (Procedures, Functions, Entities). See screenshot below.

Using 64 bit version.

The list does not seem to retain my changes. Also, it has multiple headers for the same thing (Procedures, Functions, Entities). 

See screenshot below.

92 1 / Create an account to join the discussion.
sykiemikey
Follow / 10 Aug 2016 at 7:07pm / Toad Data Modeler Beta Program
Latest post by on 9 Sep 2016 at 2:02pm

Temporal history table in separate filegroup from current table

Expand content
I prefer my history tables to be stored in separate filegroups from the current table. As far as I know, 2016 doesn't have an easy way to define a separate filegroup with the simple history table...

I prefer my history tables to be stored in separate filegroups from the current table.

As far as I know, 2016 doesn't have an easy way to define a separate filegroup with the simple history table auto-generation command WITH (SYSTEM_VERSIONING = ON ( HISTORY_TABLE = [???_HISTORY] )).

For this to work, the history table needs to be defined and created (without pk, fk and period of course) first on one file group, then the current table created on a separate filegroup with system_versioning on to attach to it.

Maybe have an checkbox under "Temporal Table Properties" to define history table separately, and with a check of the box, the ability to specify a separate file group?

Thanks much.

370 7 / Create an account to join the discussion.
asharovarov
Follow / 8 Sep 2016 at 10:31pm / Toad Data Modeler Beta Program
Latest post by on 9 Sep 2016 at 12:01pm

Order of fields in multi-column index get messed up

Expand content
TDM Version: 6.1.2.10 Server: SQL Server 2014 / SQL Server 2016 If make multiple cycles of "Update Model From Database..." ->...Make some changes to the model -> "Generate Change...

TDM Version:  6.1.2.10

Server: SQL Server 2014 / SQL Server 2016

If make multiple cycles of  "Update Model From Database..." ->...Make some changes to the model ->  "Generate Change Script "-> "Update Model From Database..." TDM shows that Column Order in multi-column index got messed up.

120 1 / Create an account to join the discussion.
asharovarov
Follow / 8 Sep 2016 at 10:37pm / Toad Data Modeler Beta Program
Latest post by on 9 Sep 2016 at 11:50am

If Column is renamed in database "Update Model From Database...

Expand content
TDM Version: 6.1.2.10 Server: SQL Server 2014 / SQL Server 2016 If a column is renamed in database and you do "Update Model From Database..." it drops the old column with all custom attributes...

TDM Version:  6.1.2.10

Server: SQL Server 2014 / SQL Server 2016

If a column is renamed in database and you do "Update Model From Database..." it drops the old column with all custom attributes which are stored inside the model only.

It would be nice to have a way to match old and new column in UI, so it would be treated as rename w/o loss of any attributes.

I experience the similar problem with Tables, FK, PK, etc. 

128 1 / Create an account to join the discussion.
rada
Follow / 3 Aug 2016 at 3:25pm / Toad Data Modeler Beta Program
Latest post by on 4 Aug 2016 at 1:39pm

Toad Beta and new Win10 update 1607

Expand content
Hello, After upgrading new Win10(x64) update 1607 seems Toad beta 6.1.2.9 lost ability to print. After program starts, it gives notification that "No valid printer has been found on your computer...

Hello,

After upgrading new Win10(x64) update 1607 seems Toad beta 6.1.2.9 lost ability to print. After program starts, it gives notification that "No valid printer has been found on your computer. Some of the functions related to print might work incorrectly." Trying to choose Print.. from menu results in program crash.

Lubo

273 1 / Create an account to join the discussion.
john stoddart
Follow / 2 Aug 2016 at 8:31pm / Toad Data Modeler Beta Program
Latest post by on 3 Aug 2016 at 7:43am

will new modeler beta version work with modeler 3.4

Expand content
i have modeler 3.4 and when i try to run the new beta version, i receive a message that license key has not been found. will the beta version run with my current version? john

i have modeler 3.4 and when i try to run the new beta version, i receive a message that license key has not been found. will the beta version run with my current version?

john

286 1 / Create an account to join the discussion.
byron.maldonado
Follow / 8 Jun 2016 at 8:06pm / Toad Data Modeler Beta Program
Latest post by on 13 Jul 2016 at 7:09am

Toad Data Modeler 64 bits Beta delays in Reverse Engineering

Expand content
Our customer is executing a Reverse Engineering of 4,000 objects schema and is 17 hours executing without termination. In the past the customer had some issues of out of memory in TDM 32 bits and he was...

Our customer is executing a Reverse Engineering of 4,000 objects schema and is 17 hours executing without termination.

In the past the customer had some issues of out of memory in TDM 32 bits and he was expecting the issue will resolve in 64 bits

Unanswered 775 10 / Create an account to join the discussion.
anderson.ant.oli
Follow / 22 Jun 2016 at 3:11pm / Toad Data Modeler Beta Program
Latest post by on 24 Jun 2016 at 7:33am

I can not create a foreign key whose data type is a type defined by...

Expand content
I have a parent table and a child table. The child table has a data type with N columns. One of these columns should make reference to the key of the parent table. How to do this in TOAD Data Modeler?...

I have a parent table and a child table. The child table has a data type with N columns. One of these columns should make reference to the key of the parent table. How to do this in TOAD Data Modeler?

Version: 5.4.8.1

Unanswered 557 3 / Create an account to join the discussion.
kevinstern
Follow / 22 Mar 2016 at 8:37pm / Toad Data Modeler Beta Program
Latest post by on 1 Apr 2016 at 1:22pm

Toad Data Modeler 6.0 64-bit Beta Now Available!

Expand content
We are pleased to announce that we have released the first Beta build of Toad Data Modeler 6.0 64-bit edition. It is available for download here in the Beta community site. Please let us know if experience...

We are pleased to announce that we have released the first Beta build of Toad Data Modeler 6.0 64-bit edition. It is available for download here in the Beta community site. Please let us know if experience any issues with the Beta by posting to the Beta forum or replying to this thread. Thank you for your support!

1094 9 / Create an account to join the discussion.
morgan
Follow / 10 Feb 2008 at 1:17am / Toad Data Modeler Beta Program
Latest post by on 24 Feb 2016 at 6:00pm

Copy or clone a workspace

Expand content
If I have an existing workspace that formatted properly by having the entities arranged properly and colored properly, etc. Is there a way to create a new workspace that is a copy of the first one so that...
If I have an existing workspace that formatted properly by having the entities arranged properly and colored properly, etc. Is there a way to create a new workspace that is a copy of the first one so that slight formatting changes can be made without losing the first workspace?

I can get the entities and relationships from one workspace to another, but the formatting and positioning then ends up being lost.

Thanks
10712 4 / Create an account to join the discussion.
proc.eng
Follow / 4 Feb 2016 at 1:52pm / Toad Data Modeler Beta Program
Latest post by on 5 Feb 2016 at 11:44am

Interface problems on a High DPI screens

Expand content
Hi, I know that there much more important issues in the product, but latest beta (6.0.1.17) seems to be not compatible with a high DPI screens. Impossible to work with a 4k screen's laptop without...

Hi,

I know that there much more important issues in the product, but latest beta (6.0.1.17) seems to be not compatible with a high DPI screens. Impossible to work with a 4k screen's laptop without external monitor.

Unanswered 981 2 / Create an account to join the discussion.
alvesc80
Follow / 2 Feb 2016 at 10:40pm / Toad Data Modeler Beta Program
Latest post by on 3 Feb 2016 at 12:49pm

Import dm2 file with tdm 5.4.8.1

Expand content
Hi all, I have to read with the Toad Data Modeler 5.4.8.1 a dm2 file that I suspect it was wrote in the version 2.24.0.21 but when I import with "Case Studio Model..." the error message is...

Hi all,

I have to read with the Toad Data Modeler 5.4.8.1 a dm2 file that I suspect it was wrote in the version 2.24.0.21 but when I import with "Case Studio Model..." the error message is showed: "XML cannot be read"

How can I import this file?

My best regards

Cristiano

Answered 906 3 / Create an account to join the discussion.
vladka
Follow / 25 Nov 2013 at 1:39pm / Toad Data Modeler Beta Program
Latest post by on 23 Jul 2015 at 2:38pm

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

11795 6 / Create an account to join the discussion.
alexandru.popescu
Follow / 3 Feb 2015 at 1:30pm / Toad Data Modeler Beta Program
Latest post by on 3 Feb 2015 at 4:21pm

BETA version has expired

Expand content
Hi, the Export/Import function to and from Excel has a bug which is acknowledged by the developers ( http://www.toadworld.com/products/toad-data-modeler/f/30/t/23520.aspx ) and fixed in the BETA version...

Hi,


the Export/Import function to and from Excel has a bug which is acknowledged by the developers  ( http://www.toadworld.com/products/toad-data-modeler/f/30/t/23520.aspx ) and fixed in the BETA version. After downloading and installing the BETA version I was able to use it for two days and now the application refuses to start and quits with the message:

"Beta version has expired. Please download the latest beta version from http://modeling.inside.quest.com"

So far I tried uninstalling and installing BETA version again, nevertheless without success.

Is there a workaround to have the BETA Version working again?


Your support is highly appreciated.

10652 2 / Create an account to join the discussion.
Lukas
Follow / 3 Feb 2015 at 4:04pm / Toad Data Modeler Beta Program

New BETA available for download!

Expand content
Hi our BETA users, New Toad Data Modeler 5.4.5 BETA has just been made available for you! Please, DOWNLOAD , try the new stuff and LET US KNOW! Regards, Lukas & TDM Team

Hi our BETA users,

New Toad Data Modeler 5.4.5 BETA has just been made available for you!

Please, DOWNLOAD, try the new stuff and LET US KNOW!

Regards,

Lukas & TDM Team

10272 0 / Create an account to join the discussion.
BillR
Follow / 27 Mar 2007 at 2:42am / Toad Data Modeler Beta Program
Latest post by on 24 Nov 2014 at 2:01pm

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?

12337 10 / 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 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.

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

14381 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
11570 4 / Create an account to join the discussion.