You will no longer receive e-mail notifications from this forum.
Log-In to post
Contact Support on Twitter
I created some wrong relationships within my model (TDM 6.1, Postgres 9.5) incorrectly linking the PK columns of both entities.
At some point I added the correct relationships including adding the correct FK columns.
I don't really know how I did it, but somehow the wrong relationship is now between both PK columns, and when I delete that relationship the two PK columns are deleted automatically as well (which of course I don't want).
So my question is: is there a trick so that I can delete that relationship but keep those columns that are incorrectly assumed to depend on that relationship?
It's "Relationship29" in the below screenshot. If I delete that relatioinship, TDM als deletes both ID columns.
If needed I can supply the model itself but I did not find a way to attach a file other then a screenshot here.
I am trying to connect the tables. one table has business_id, business_name and state_id, the other table has state_id and state name. When I try and connect the two by state_id it creates a new attribute called business_id in the second table. I want state_id to be a foreign key in both. What do I need to do? Thanks.
Boohoo - I just know this post is gonna get smashed, but...
Where do I change the default attribute data type (for the Universal model) - it's set to Char(1) which seems entirely pointless?
I've looked in Template Editor, looked in Defaults, looked in Dictionary, looked in Package Explorer.
I've probably ended-up in the right place once, but it wasn't obvious where to make the change
In my company we are currently using Case Studio 2.23 (TDM before renaming) and we decided for an upgrade but we need firebird support which current version of TDM doesn't have (or keeps it as a secret feature).
So my question is: Dont you know how to get firebird support into current version of TDM or which last version supported it?
I have a text document held inside a folder in a TDM 6.1 x86 Project folder under Subversion/TortoiseSVN bin control.
I have R/W permissions on the Subversion Repository and on the Project working folder
When I rename a document inside a TDM version-controlled folder, that filename does change in Toad, but it does NOT change the name of the file on disk.
Is this a feature or a bug, and is renaming non-Toad files from within TDM a bad idea?
As stated in a Post some time ago, the Project concept in Toad has merit but it must offer reliable file name/move/edit/delete functionality, else the concept is too limited for me to commit to using it as a 'project' manager.
I have models generated by TDM2. Now I can't even load them with TDM3. I can't find TDM2 anywhere. Can you send me a link to download TDM2 or tell how what am I supposed to do with *.dm2 files.
I am using Toad Data Modeler 6.2 and I have created a new workspace >> right click Edit >> and then the 'Workspace Properties' window is presented. I can see a list with all my tables but I need them being preceded by the schema name as some tables have the same name and then I don't have a way to figure out which ones I am looking for and I have to add them both and then remove the one with the wrong schema.
I guess I am looking for something similar to the option 'Full Names' in the dropdown in the menu closed to the Report button.
I have been using Toad Data modeler freeware 32bit since Dec 2016. The 120 days limit is approaching and I'm trying to re-download as the site said -simply download. But am having difficulty, even though I have created an account with address, email, phone etc., updated my profile. When I complete the form to initiate the download, the submit button does not seem to work. It's possible it is rejecting my PostalCode, but it was accepted on the account creation. I see various references to Toad, Quest and Dell and am confused as to what or how these fit together.
I am on a few data base forums and participate with design and draft models. The freeware edition of TDM is very adequate for my use, and I would like to re download the latest version before my current freeware expires. I am a retired data management person.
Any info to clarify the terminology, and especially for how to get this freeware download sorted would be most welcome.
I'm trying to find a way to add a default set of columns to each enntity for auditing purpose for each entity. I want to automatically generate all the column when the an entity is created.
The set of colums is required for each table in the model below:Insert_Datm date not null,Update_Datm date null, Error_Flag char(1) not null,Delete_Datm date null, Source_Key Varchar2 (256) not nullIf there's no way to autogenerate these, is there a way cut/past all colums into the DM at one time?Thanks
After I enter Model action, and I click Entities and check to generate Comments...and I close it....program doesn't keep this setting.
Generating script from model action doesn't generate entity and attribute comments at all.
Tested on x86 version.
Any suggestions how to solve this?
... this might be because of the performance.
Loading the landing page of the forum takes ages for me and usually doesn't finish unless I try multiple times. Sometimes it works if I login before visiting the forum.
When tracing the network calls using wget I see this:
--2017-05-03 08:25:07-- www.toadworld.com/.../default.aspxResolving www.toadworld.com (www.toadworld.com)... 18.104.22.168Connecting to www.toadworld.com (www.toadworld.com)|22.214.171.124|:80... connected.HTTP request sent, awaiting response... 301 Moved PermanentlyLocation: www.toadworld.com/.../f [following]--2017-05-03 08:25:08-- www.toadworld.com/.../fReusing existing connection to www.toadworld.com:80.HTTP request sent, awaiting response... 200 OKLength: 69159 (68K) [text/html]Saving to: 'www.toadworld.com/products/toad-data-modeler/f/default.aspx'www.toadworld.com/products/toad-data-modeler/f/de 100%[===============================================================================================================>] 67.54K 105KB/s in 0.6sLast-modified header missing -- time-stamps turned off.2017-05-03 08:25:09 (105 KB/s) - 'www.toadworld.com/products/toad-data-modeler/f/default.aspx' saved [69159/69159]Loading robots.txt; please ignore errors.--2017-05-03 08:25:09-- www.toadworld.com/robots.txtReusing existing connection to www.toadworld.com:80.HTTP request sent, awaiting response... 200 OKLength: 69 [text/plain]Saving to: 'www.toadworld.com/robots.txt'www.toadworld.com/robots.txt 100%[===============================================================================================================>] 69 --.-KB/s in 0s2017-05-03 08:25:09 (869 KB/s) - 'www.toadworld.com/robots.txt' saved [69/69]--2017-05-03 08:25:09-- www.toadworld.com/.../layout.cssReusing existing connection to www.toadworld.com:80.HTTP request sent, awaiting response... Read error (Unknown error) in headers.Retrying.--2017-05-03 08:25:29-- (try: 2) www.toadworld.com/.../layout.cssConnecting to www.toadworld.com (www.toadworld.com)|126.96.36.199|:80... connected.HTTP request sent, awaiting response... Read error (Unknown error) in headers.Retrying.--2017-05-03 08:25:59-- (try: 3) www.toadworld.com/.../layout.cssConnecting to www.toadworld.com (www.toadworld.com)|188.8.131.52|:80... connected.HTTP request sent, awaiting response... Read error (Unknown error) in headers.Retrying.--2017-05-03 08:26:37-- (try: 4) www.toadworld.com/.../layout.cssConnecting to www.toadworld.com (www.toadworld.com)|184.108.40.206|:80... connected.HTTP request sent, awaiting response...
--2017-05-03 08:27:08-- (try: 5) www.toadworld.com/.../layout.cssConnecting to www.toadworld.com (www.toadworld.com)|220.127.116.11|:80... connected.HTTP request sent, awaiting response... Read error (Unknown error) in headers.Retrying.--2017-05-03 08:27:40-- (try: 6) www.toadworld.com/.../layout.cssConnecting to www.toadworld.com (www.toadworld.com)|18.104.22.168|:80... connected.HTTP request sent, awaiting response...
So there seems to be something wrong when loading the CSS file for the site.
I don't have the option to format the relationship lines to straight (like I did in the previous version).
Is the option located somewhere else?
I am using straight lines connectors between tables with 90 degrees elbow points. I find that I am spending more time than I wanted to moving around connectors to have a nice and clean look, especially when there are lots of tables involved.
I noticed that when I move the tables around, the connectors are not placed using the shortest distance - if possible - they tend to retain their elbow points but that leads to convoluted links. I have to admit, it's hard to explain without showing it. Check out the two images. Genre is below Film to start with, and the connector is straight. Then I moved Genre to the left of Film and the connector is below them. An optimal connection would have placed the connector between Genre-right to Film-left or Genre-bottom to Film-left. Using the Optimal style to All lines has disadvantages, especially if you have more than one link between two tables - sometimes they are overlapped or very close. The other thing that I want to avoid is selecting Optimal style every time I move a table. I want the tool to do it for me.
I have a task regarding access database. I and my organization is using access database to maintain my access files in well mannered way. But due to varied reasons access file showing error message
Error 3112: Your access database got corrupted will not be able to show the database.
Due to this error message I will not be able to access my access database. I don't have any idea how to recover access database or how to fix access database errors without affecting my original database????? Is there any relevant solution to repair access database?????
I thought of sharing my experience using the sql Generation Dialog.
- It doesn't have a Close button at the bottom. Minor, but a bit annoying when I come to this dialog very often.
- re: Actions: I am not to sure how Actions are supposed to work. Every time I change a setting in that dialog I am scared that I am going to loose that setting so I end up saving the action - The problem is that it creates a new action every time even when I use the same name instead of overwriting the one with the same name and I end-up having to items with the same name in the Load Action drop-down.
How about renaming Action to Generation Settings and changing the behaviour to overwrite the settings with the same name. Otherwise I have to use numbers, Action01, Action02 ... to know which one is the last one which becomes annoying when you make changes and re-generate the script often.
-Not all the foreign keys of the tables I selected are included. In the Referential Integrity tab I checked Always, so I thought all the foreign keys are selected from the tables I selected for generation but that's not true. I had to go Select List -> Relationships and check them there.
That's it for now with this dialog.
Overall, my experience with the tool has been so and so. This morning when I came, some changes I made yesterday were gone. I left the program running. Not sure what happened. Maybe there is no point in mentioning it, but what the heck. Now I got into a paranoid mode and I click Apply every time I have a chance and save very often.
Is there a way to specify distinct captions for the two ends of a relationship between two tables in a physical model?
As an example, from the video rental model, a Customer borrows movies, I wanted to add one caption on the Customer side, Borrows, and on the other side, Borrowed by.
I used before ER/Studio from Embarcadero and you could add descriptions on both ends of a relationship. I was curious if you can do something similar in TDM. I find that sometimes having captions on both sides of a relationship can enhance the readability of the model.
Update: I started to use Rectangle Labels. Is there another way?
I am new to the Toad Data Modeler. I have created a couple for ERDs through this tool. I would say this is a wonderful tool. But after creating the ERDs, there are a couple of changes in the database. I have designed the model in a printable format with great difficulty (as I am not a good designer). But once the change is made, I am not able to revise my ERD. I have tried it through Update Model from Database (I got this idea from a different thread)
Unfortunately, that is not working for me. When I am trying with this. It is asking me to select the tables again from the scratch. Please let me know whether I am doing anything wrong or this is the way the tool behaves. Is there a better way to do that. If I am not clear, please go through the above link. I have the same question that he had.
I have a client who insists on using some reserved words in their database that I'm rebuilding.
Instead of having the argument about best practice and losing their confidence I'd like to be able to add square brackets automatically around ALL entities/attributes when generating the SQL / ADO.
Is this possible?
(I note Toad will delimit entities/attribute values that have spaces so I assume it's possible somehow).
I use the comments and descriptions options in my model to document my database. In SQL Server this information is subsequently added to custom properties in the database which I then extract into administrator reports.
Typos in those comments and descriptions are very bad so I am wondering if anyone has any suggestion for how to spell check these properties without having to cut-n-paste the text into another window.
I prefer to keep all components of a program together.
Unfortunately Toad Data Modeler creates a settings folder
C:\Users\<username>\AppData\Roaming\Dell\Toad Data Modeler\
while the main installation folder is in
How can I move the settings folder to another directory?I prefer a subdirectory like
Therefore Toad Data Modeler should automatically look at first in this customized location before the software looks atC:\Users\<username>\AppData\Roaming\Dell\Toad Data Modeler\
Another solution could be to pass a parameter at the commandline similar to
Is this somehow possible?