You will no longer receive e-mail notifications from this forum.
Log-In to post
These people make Toad Data Modeler Beta Program great and have the most points for this month!
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.
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!
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
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.
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++ :
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"?
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.
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.
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.
The new BETA 22.214.171.124 is available for download now bringing you several new features and enhancements.
Any feedback especially on the new features is appreciated!
Lukas & TDM Team
Can someone please confirm that Postgres is not supported as the documentation indicates?
Let me announce another Beta release - Toad Data Modeler BETA 126.96.36.199.
This Beta brings the following enhancements:
Toad Data Modeler BETA expires on 12 July 2014.
Vladka + TDM Team
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 188.8.131.52 on a permanent licencse. So far, the software is useless, there is nothing I can do with it, please help!