Toad Data Modeler Beta Program Community

Toad Data Modeler - Beta Forum

SAinCA
Follow / 15 Aug 2017 at 7:10pm / Toad Data Modeler Beta Program
Latest post by on 5 Oct 2017 at 6:48am

List of Entities NOT in a Workspace, excluding All Items, of course...

Expand content
With several thousand Entities to draw subject area diagrams for, and developers constantly adding new Entities, I know that if I kept the all items workspace, they would be thrown into that mess. I've...

With several thousand Entities to draw subject area diagrams for, and developers constantly adding new Entities, I know that if I kept the all items workspace, they would be thrown into that mess.  I've nuked that because it's just that, a mess, and serves no purpose.  Workspaces are NOT defined by schema, either, simply because we are still transitioning from the old dbo-everything SQL Server paradigm, to schema-oriented.  Workspaces, currently 30 or more, are Business Function oriented, often broken into multiple "sub-worspaces" because there are just too many items to depict with any clarity if left all together.

That described, how, when I run a Model Update from the latest release database, do I obtain a list of all entities that are not in any of my subject areas?  If the "all items" workspace were to creep back into being, I'd need to specifically exclude that from consideration, for obvious reasons.

Thanks.

Answered 247 7 / Create an account to join the discussion.
Rod
Follow / 4 Sep 2017 at 4:01pm / Toad Data Modeler Beta Program
Latest post by on 11 Sep 2017 at 6:25am

Will the New Version of Toad Data Modeler support PostGreSQL 9.6 ...

Expand content
Hello there, I was wondering if the new version of Toad Data Modeler will include PostGreSQL 9.6 Thank you,

Hello there,  

   I was wondering if the new version of Toad Data Modeler will include PostGreSQL 9.6

Thank you,

151 6 / Create an account to join the discussion.
Daniel Bizon

New Toad Data Modeler Beta is out!

Expand content
Toad Data Modeler 6.3 Beta Now Available! We are pleased to announce that we released the Beta build of Toad Data Modeler 6.3. It is available for download here in the Beta community site. Please let...

Toad Data Modeler 6.3 Beta Now Available!

We are pleased to announce that we released the Beta build of Toad Data Modeler 6.3. 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!

129 0 / Create an account to join the discussion.
CandleLifeMinistries
Follow / 23 Jan 2017 at 11:55pm / Toad Data Modeler Beta Program
Latest post by on 25 Jan 2017 at 1:01am

Reverse Engineering Connection Error

Expand content
I am trying to reverse engineer an Access 2007 database. I have a connection, have the ADO/DAO provider which is the only one that shows up in the dropdown list, and am selecting the file path. I keep...

I am trying to reverse engineer an Access 2007 database. I have a connection, have the ADO/DAO provider which is the only one that shows up in the dropdown list, and am selecting the file path. I keep getting this error though. I the the standard install.

Can someone please tell me how to fix this? It would be easier to do it with this wizard if I can get it to work given how many tables this program has.

Any help would be appreciated.

Thank you in advance.

BTW: The connection string with the workgroup file is:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Public\Documents\MS Office\Access\Restaurant Program\Master Copy\Restaurant Analysis.accdb;Jet OLEDB:System Database=C:\Users\Ministry\AppData\Roaming\Microsoft\Access\System.mdw;

Without the workgroup file it is:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Public\Documents\MS Office\Access\Restaurant Program\Master Copy\Restaurant Analysis.accdb;

I have tried this with and without using the Workgroup Information File with the same error.

I have also tried using the short file names like what you would find under the Command prompt. Nothing seems to work.

Unanswered 624 2 / Create an account to join the discussion.
dheadford
Follow / 22 Dec 2016 at 3:22pm / Toad Data Modeler Beta Program
Latest post by on 6 Jan 2017 at 2:05pm

Splitting DDL into one file per table 6.2.2

Expand content
When I generate DDL and check the "Split Output File" I get scripts for each table and one called other. The other has the key and index statements. Is there a way to have these included with...

When I generate DDL and check the "Split Output File"  I get scripts for each table and one called other.  The other has the key and index statements.  Is there a way to have these included with the table scripts? 

Unanswered 969 6 / Create an account to join the discussion.
joethejet
Follow / 15 Dec 2016 at 4:53pm / Toad Data Modeler Beta Program
Latest post by on 20 Dec 2016 at 7:50am

License Key?

Expand content
Hello, is it possible to get a license key? I was trying to use the beta product, but it asks for a license key.

Hello, is it possible to get a license key? I was trying to use the beta product, but it asks for a license key.

1224 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 2 Dec 2016 at 12:25am

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.

2319 15 / Create an account to join the discussion.
rada
Follow / 7 Oct 2016 at 2:01pm / Toad Data Modeler Beta Program
Latest post by on 11 Oct 2016 at 12:27pm

Order of generated objects, extension

Expand content
Hello, It seems to me that during generating of sql script from model action, TDM is ignoring extension settings in Order of generated objects page. Example is in attachment. As I know it worked in...

Hello,

It seems to me that during generating of sql script from model action, TDM is ignoring extension settings in Order of generated objects page. Example is in attachment.

As I know it worked in older version. I am forced to use beta because of other bugs which blocks me in work.

Do you know how to force TDM to take this settings in use?

Lubo.

Answered 1178 7 / Create an account to join the discussion.
rada
Follow / 3 Aug 2016 at 3:25pm / Toad Data Modeler Beta Program
Latest post by on 7 Oct 2016 at 2:05pm

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

1090 2 / Create an account to join the 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
1077 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.

818 1 / 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.

826 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. 

876 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

1018 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 1645 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 1311 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!

1929 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
11564 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 2094 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 1713 3 / Create an account to join the discussion.