jprahn0002
Follow / 18 Feb 2018 at 4:26pm / Toad Data Modeler
Latest post by on 21 Feb 2018 at 3:23pm

Toad Freeware 6.3.3.2 64-bit Freeware Crashes On Launch

Expand content
I have installed the freeware on my laptop and my home office desktop. On the laptop it works like a charm, on the desktop it crashes immediately. I've uninstalled and reinstalled to no avail. I'm...

I have installed the freeware on my laptop and my home office desktop. On the laptop it works like a charm, on the desktop it crashes immediately. I've uninstalled and reinstalled to no avail. I'm running Windows 10 on both. The desktop is relatively high performance; I can supply whatever specs are relevant. Here is the top portion of the error report: 

2.1 Date : Sun, 18 Feb 2018 11:18:42 -0500
2.2 Address : 00000000005DECEF
2.3 Module Name : TDM.exe - (Toad Data Modeler)
2.4 Module Version: 6.3.3.2
2.5 Type : EOleException
2.6 Message : Not found.
2.7 ID : E5C156D6
2.8 Count : 1
2.9 Status : New
2.10 Note :
2.11 Sent : 0

Any input would be appreciated. 

106 6 / Create an account to join the discussion.
andrearomani
Follow / 21 Feb 2018 at 11:56am / Toad Data Modeler
Latest post by on 21 Feb 2018 at 2:46pm

Nedd Key for TDM 6.3

Expand content
Hi. I've installed TDM 6.3 but it has expirend on jannuary. How can I get a new key ? Thanks, Andrea

Hi.

I've installed TDM 6.3 but it has expirend on jannuary.
How can I get a new key ?

Thanks,

Andrea

31 1 / Create an account to join the discussion.
giron35
Follow / 15 Feb 2018 at 1:42pm / Toad Data Modeler
Latest post by on 19 Feb 2018 at 10:08am

Trouble to generate change script for PostgreSQL ...

Expand content
I have few PostgreSQL 10.1 databases installed on the same server. When i want to generate change script on a specific database with TDM, i got the following error message "Internal Error - Callstack...

I have few PostgreSQL 10.1 databases installed on the same server.

When i want to generate change script on a specific database with TDM, i got the following error message "Internal Error - Callstack "REDataMigratorDBPG93" from package "Object RE Database for PostgreSQL9.3".

This is not due to PostgreSQL version, even 10.1 is not supported yet, because the script is well generated for all other databases (installed on the same host/server).

Have you already experienced this problem ? how can i solve it ?

Thanks for your answer.

 

Unanswered 211 6 / Create an account to join the discussion.
auh
Follow / 8 Feb 2018 at 12:08pm / Toad Data Modeler
Latest post by on 13 Feb 2018 at 12:04pm

Internal Error on reverse engineering from Vertica - REDataMigrat...

Expand content
Hello, I'm new to TOAD Data Modeler and at the moment I'm evaluating if TOAD Data Modeler can help us to model and document our Vertica Database. I tried to reverse enineer from the DB...

Hello,

I'm new to TOAD Data Modeler and at the moment I'm evaluating if TOAD Data Modeler can help us to model and document our Vertica Database.

I tried to reverse enineer from the DB and got this error:

TAOD Data Modeler Internal Error - REDataMigratorDBVR - Multiple commands canot be active on the same connection ....

Callstack: REDataMigratorDBVR from Object RE Database for Vertica.

(see picture below)

I have only one connection - and I gort this error also when I tried to import only 1 table from my database. It seems that the amount of imported objects has nothing to do with the error. :-(

We're using vertica 08.01.0105 with driver version 06.01.0300 (That's what I can find in my DBVisualizer connection to the Vertica DB).

Can anybody help me?

Many thanks and all the Best,

Anja

396 6 / Create an account to join the discussion.
costabas
Follow / 7 Feb 2018 at 6:42pm / Toad Data Modeler
Latest post by on 8 Feb 2018 at 8:11pm

Undo (CTRL+Z) doesn't work in the SQL code editors

Expand content
In version 6.3 Undo (CTRL+Z) doesn't work in the SQL code controls embedded in the various sections (After Script, Before Script etc.). Can you please fix this? Thanks

In version 6.3 Undo (CTRL+Z) doesn't work in the SQL code controls embedded in the various sections (After Script, Before Script etc.).

Can you please fix this?

Thanks

332 2 / Create an account to join the discussion.
sykiemikey
Follow / 29 Jan 2018 at 7:36pm / Toad Data Modeler
Latest post by on 8 Feb 2018 at 4:12pm

Issues with "Generate Change Script"

Expand content
I'm on the newest version (6.3) First of all, would like a way for the function to take into account the "generate" flag on each item and only generate scripts for those. Extended Properties...

I'm on the newest version (6.3)

First of all, would like a way for the function to take into account the "generate" flag on each item and only generate scripts for those.

Extended Properties:
Comparing model to SQL 2016. I have many extended properties that are set null until we figure out all the values to be populated. When reading extended properties from SQL 2016, modeler doesn't pick up any of the ones with a NULL value and generates an "addproperty" for all of them which comes back and says "property already exists" when ran. My issues is going to be when I fill in the property in the model, it is going to try to run an "add" when it really needs to do an "update" and the property value will never get set.

Attributes:
I get a LOT of ALTER Table statements to ALTER COLUMN to the datatype and null/not null value that is already present. Tried different settings and was never able to eliminate these.

Temporal Tables:
This is where it gets really bad. Especially with "generates temp tables to preserve data" selected.

  1. It doesn't seem to drop all the constraints
  2. It tries to create a history table with the same name as an existing one.
  3. It does not copy the history table data to preserve it.
  4. It does not take into account the file group selected under the Temporal Table Properties/History Table Properties for each table and automatically creates under PRIMARY.
  5. It seems the script functions are all out of order.

I've yet to generate a change script that I didn't have to spend half my day fixing before it could actually run and even then I had problems.
Please help.

Thanks

Michael

594 6 / Create an account to join the discussion.
Jolene.Jobe-Neuse
Follow / 5 Feb 2018 at 6:18pm / Toad Data Modeler
Latest post by on 8 Feb 2018 at 8:34am

Import Oracle SQL Developer Data Modeler data model into Toad Data...

Expand content
We were authorized to purchase a data modelling tool, & Toad was selected. There are a number of existing data models created with Oracle SQL Developer Data Modeler we'd like to import into Toad...

We were authorized to purchase a data modelling tool, & Toad was selected.

There are a number of existing data models created with Oracle SQL Developer Data Modeler we'd like to import into Toad.

An earlier blog, over 6 years ago, discusses importing Power Designer data models into Toad, but I didn't see any other modelling tool discussed.

The Toad installation on my workstation displays the following File --> Import options: 

Toad for Oracle projects, Toad for Oracle ERD, ER/Studio Data Architect, Import from Excel, & Import from CSV.

Am I missing features, or is importing from Oracle SQL Developer Data Modeler into Toad not possible?  There is significant existing content.

 

Unanswered 434 5 / Create an account to join the discussion.
costabas
Follow / 7 Feb 2018 at 8:52pm / Toad Data Modeler
Latest post by on 8 Feb 2018 at 7:29am

The syntax highlighting in the Model Properties - Before Script, After...

Expand content
The syntax highlighting doesn't work in the Before/After Script editors on the Model Properties dialog. Can you please fix it? Thanks

The syntax highlighting doesn't work in the Before/After Script editors on the Model Properties dialog.

Can you please fix it?

Thanks

317 1 / Create an account to join the discussion.
SPDToad
Follow / 6 Feb 2018 at 10:03am / Toad Data Modeler
Latest post by on 7 Feb 2018 at 7:44am

Freeware Version - Reverse Engineer Selected Tables not working

Expand content
Hi, I am using the latest freeware version of modeller. Because of this I only want to reverse engineer <25 tables. I have gone through the Model > Update Model and File > Reverse Engineering...

Hi,

I am using the latest freeware version of modeller. Because of this I only want to reverse engineer <25 tables. I have gone through the Model > Update Model and File > Reverse Engineering option but each time I select a set of tables (say 7)  and then change the option to 'All Selected Tables' it will still import ALL table in the database - 341.

Is there anyway I can limit the amount as I don't want to have to manually remove 316 entities

Thank You

Steve

384 4 / Create an account to join the discussion.
Vaclav Frolik
Follow / 23 Sep 2010 at 11:27am / Toad Data Modeler
Latest post by on 7 Feb 2018 at 6:26am

Import models

Expand content
Hi, yesterday I published new article about how to load logical information (captions, notes) from external sources to reverse engineered model. This article can be useful for all interested in "import"...

Hi,

yesterday I published new article about how to load logical information (captions, notes) from external sources to reverse engineered model. This article can be useful for all interested in "import" of models created in other database modeling tools. Direct import is very difficult because competitors usually protect their file formats... and that's why I think the published article can be a good starting point for making advanced import scripts.

Blog entry: http://www.toadworld.com/products/toad-data-modeler/b/weblog/archive/2010/09/22/how-to-load-logical-information-from-external-sources

BTW: you can find there information about how to load XML in javascript, how to search object by name, how to use "OpenDialog" and more.

Regards,

Vaclav

10683 4 / Create an account to join the discussion.
otbl
Follow / 3 Oct 2011 at 5:10pm / Toad Data Modeler
Latest post by on 30 Jan 2018 at 4:11pm

Freeware edition licensing

Expand content
I've installed Toad Data Modeler Freeware version. But it says that license is only valid for 120 days. What is going to happen after that? Also the feature document on the web site indicates that...

I've installed Toad Data Modeler Freeware version. But it says that license is only valid for 120 days.

What is going to happen after that?

Also the feature document on the web site indicates that Freeware version is valid until August 2010, which is much more than 120 days from today.

11751 4 / Create an account to join the discussion.
anthony.vitale
Follow / 23 Jan 2018 at 3:58pm / Toad Data Modeler
Latest post by on 24 Jan 2018 at 7:32am

How Do I Make the Workspace I am working on Open when a Model Opens...

Expand content
Hi. I Use a Number of Workspaces in My Model So At Any one Time I am working On a Workspace defined for the Task At hand. Additionally I do not use the All Items Workspace At All, And Given that...

Hi.

I Use a Number of Workspaces in My Model

So At Any one Time I am working On a Workspace defined for the Task At hand.

Additionally I do not use the All Items Workspace At All, And Given that I have close to 1,000 Entities I Find Opening The All Items Workspace to be time Consuming and I immediately close it.

However, Everytime I open the Model within TDM, It always Only Opens the "All Items" Workspace, So I need to wait for the Designer to open and then I need to Open the Workspace I was working on Manually and Close the All Items.

I have to Assume that there is some way I can Control to Have TDM open a Workspace I want on Open of the Model. 

However I may be Wrong.

Please let me know.

616 1 / Create an account to join the discussion.
costabas
Follow / 10 Jan 2018 at 8:20pm / Toad Data Modeler
Latest post by on 12 Jan 2018 at 8:49pm

The syntax highlighter in the SQL Preview doesn't highlight properly...

Expand content
Hi: I added a table comment that has multiple lines (I pressed enter to create new lines). When I go to SQL Preview, I noticed that the syntax highlighter didn't highlight the all the sql string...

Hi:

I added a table comment that has multiple lines (I pressed enter to create new lines). When I go to SQL Preview, I noticed that the syntax highlighter didn't highlight the all the sql string lines.

The RDBMS is SQL Server 2008 R2.

Here is a screenshot. Lines 58 and 60 should have been blue.

It's not  a big issue, but when I looked the comment the first time I thought I did something wrong, then I realized the the syntax highlighter didn't highlight properly the strings.

833 2 / Create an account to join the discussion.
costabas
Follow / 3 Jan 2018 at 10:58pm / Toad Data Modeler
Latest post by on 10 Jan 2018 at 6:47am

Dialogs don't show up immediately

Expand content
Hello, This is a complaint I've had for a very long time, since the days TDM was owned by the Czech company (the product had another name). I bring it up again because it annoys me greatly and...

Hello,

This is a complaint I've had for a very long time, since the days TDM was owned by the Czech company (the product had another name).

I bring it up again because it annoys me greatly and perhaps you can do something about it.

It takes a few good seconds until a dialog shows up after clicking on an entity or attribute.

Let's say I want to edit the attributes of an entity. I double-click on the entity. It takes 3 seconds until the Entity Properties dialog shows up.

Now, I go to attributes and double-click on an attribute. It takes 3 seconds until the Attribute Properties dialog shows up.

Let's say I want to modify a check constraint. I double-click on a check constraint. This one is faster, it takes a second.

I don't understand why the dialogs aren't snappier. It is disruptive to my workflow because I want to make changes quickly.

I have a decent VM. I've used in the past other data modelling tools, power designer data architect and the e/r studio and their dialogs are snappy and fast. I don't understand why this tool is not the same.

Any hints or suggestions?

Thanks

816 6 / Create an account to join the discussion.
Robert
Follow / 1 Jan 2018 at 5:16pm / Toad Data Modeler
Latest post by on 2 Jan 2018 at 11:15am

TDM 6.3 - stored procedure - validation problem: set rowcount with...

Expand content
TDM reporting error - bad validation? create stored procedure my_proc ( @myRowCount int=100 ) as ... set rowcount @myRowCount ... reporting ERROR: ERROR: line xxx, column xxx, ending line...

TDM reporting error - bad validation?

create stored procedure my_proc (

@myRowCount int=100

)

as ...

set rowcount @myRowCount

...

reporting ERROR:

ERROR: line xxx, column xxx, ending line xxx, column xxx: Found '@myRowCount': Expecting: integer

THX for repair

Unanswered 845 1 / Create an account to join the discussion.
richdhan
Follow / 28 Dec 2017 at 8:56am / Toad Data Modeler
Latest post by on 1 Jan 2018 at 9:00pm

XML import from ERwin model into TDM 5.5

Expand content
I have saved the ERWin (8.2) model as .xml file. How do I import this .xml file into TDM 5.5? I tried the import option -> Case Studio 2 model and chose Files of Type as All. Am I in the right direction...

I have saved the ERWin (8.2) model as .xml file.

How do I import this .xml file into TDM 5.5?

I tried the import option -> Case Studio 2 model and chose Files of Type as All. Am I in the right direction so far?

But getting error as "Unexpected Error During Loading Model"

Thanks in advance for the support.

Richard

764 1 / Create an account to join the discussion.
studentttt
Follow / 15 Dec 2017 at 7:16pm / Toad Data Modeler
Latest post by on 18 Dec 2017 at 7:04am

Users in Physical Model Explorer

Expand content
Hi everyone. I have a problem with Users in Physical Model Explorer. I don't have this position in Physical Model in my project, but in sample project "Videorental" it is, and there is no...

Hi everyone. 

I have a problem with Users in Physical Model Explorer. 
I don't have this position in Physical Model in my project, but in sample project "Videorental" it is, and there is no problem to create users.
Also, in "Videorental" and in my project, I can create a new User Groups.

I have 6.3 trial version of Toad Data Modeler and project is based on postgresql 9.0, but in 9.5 is the same problem.

How can I fix it? 
Maybe it's a problem of trial version? For example, I can't create more than 25 entities.

Unanswered 984 1 / Create an account to join the discussion.
costabas
Follow / 11 Dec 2017 at 8:49pm / Toad Data Modeler
Latest post by on 12 Dec 2017 at 6:58am

Primary key names conventions and relationship based index names conventions...

Expand content
I want to always set the primary key name for my tables using the pattern: PK_<TableName>. Ideally the app would sync the name whenever I change the table name. Is it doable? If yes, how can I do...

I want to always set the primary key name for my tables using the pattern: PK_<TableName>. Ideally the app would sync the name whenever I change the table name. Is it doable? If yes, how can I do it?

Also, I want to change the index names for indexes created from relationships to IX_<TableName>_<FieldName> instead of IX_Relationship1, IX_Relationship2 etc. Again, is it doable? If yes, how?
Thank you!

Unanswered 932 1 / Create an account to join the discussion.
costabas
Follow / 8 Dec 2017 at 8:24pm / Toad Data Modeler

Ability to wrap text inside Text and Label Rectangle elements

Expand content
I created this entry in the idea pond: https://www.toadworld.com/products/toad-data-modeler/i/general_features/add_the_ability_to_wrap_text_inside_rectangle_boundary Please vote for it if you think it...

I created this entry in the idea pond: https://www.toadworld.com/products/toad-data-modeler/i/general_features/add_the_ability_to_wrap_text_inside_rectangle_boundary

Please vote for it if you think it would be useful.

Thanks

570 0 / Create an account to join the discussion.
SPDToad
Follow / 4 Dec 2017 at 9:55am / Toad Data Modeler
Latest post by on 5 Dec 2017 at 7:09pm

SQL Server - add NONCLUSTERED to CREATE INDEX command

Expand content
Hi, Is there a way to tell Toad to include NONCLUSTERED in the CREATE INDEX command for index that are not CLUSTERED. Thank you Steve

Hi,

Is there a way to tell Toad to include NONCLUSTERED in the CREATE INDEX command for index that are not CLUSTERED.

Thank you 

Steve

Unanswered 1081 4 / Create an account to join the discussion.