lgerard
Follow / 16 Oct 2017 at 1:23pm / Toad Data Modeler
Latest post by on 23 Oct 2017 at 12:43pm

change script : add sql

Expand content
Hi everbody ! I use Toad data modeler with git support in order to have distincts versions of my project database. My database model is deployed on many environements, and then, many servers. So...

Hi everbody !

I use Toad data modeler with git support in order to have distincts versions of my project database.

My database model is deployed on many environements, and then, many servers.

So, it's possible i have a environnement with a specific version and another environnement with another version. 

In order to migrate my databases i use the "generate change script" tool wich produce SQL.

What i want to do : insert at each update (Each change script) a new line in a table.

Can i ask Toad adding a specific SQL script when he generate the SQL change script ? This script, always called, will thus be able to contain the version of the database.

Is it possible ?

Thanks for your replies !

55 3 / Create an account to join the discussion.
Robert
Follow / 5 Oct 2017 at 4:08pm / Toad Data Modeler
Latest post by on 23 Oct 2017 at 11:43am

Object permission

Expand content
Hi, please can You help me: how setting Toad Data Modeler for SQL Preview including object permission? I need view SQL script with grants, for examle: CRATE TABLE xyz ( ... ) go GRANT SELECT...

Hi, please can You help me: how setting Toad Data Modeler for SQL Preview including object permission? I need view SQL script with grants, for examle:

CRATE TABLE xyz (

...

)

go

GRANT SELECT on xyz to user_a

go

(I have defined users and groups in fold 'Permissions', but in SQL Script aren't), thanks.

Unanswered 124 8 / Create an account to join the discussion.
costabas
Follow / 20 Oct 2017 at 10:22pm / Toad Data Modeler

Dual Labels for relationships

Expand content
Hi: Can you please add a feature where one can assign dual labels for relationships as seen in this picture: I think having these verbs makes the model more readable. I know I can add labels...

Hi:

Can you please add a feature where one can assign dual labels for relationships as seen in this picture:

I think having these verbs makes the model more readable.

I know I can add labels but labels seem a pain because they don't move along with the connection.

Thanks

11 0 / Create an account to join the discussion.
DJBrown
Follow / 17 Oct 2017 at 5:23pm / Toad Data Modeler
Latest post by on 18 Oct 2017 at 2:16pm

Associative Entities

Expand content
I am a good bit of the way through building a fairly large data model and just realized Toad has an M:N Relationship button that will automatically create the associative entity that resolves the many...

I am a good bit of the way through building a fairly large data model and just realized Toad has an M:N Relationship button that will automatically create the associative entity that resolves the many-to-many relationship. I have been manually placing entities and relationships on my workspace to do this. What I like about the M:N Relationship button is that the associative entity it creates has rounded corners, thus showing it is different than other entities. My question is this: is there an easy way for me to change my manually placed M:N / associative entities to have those rounded corners?

Unanswered 49 2 / Create an account to join the discussion.
Michal Bielamowicz
Follow / 19 Oct 2008 at 10:17pm / Toad Data Modeler
Latest post by on 13 Oct 2017 at 6:41pm

Toad sound on startup of TDM...

Expand content
.. any plans for it ;-) ? Regards, Michal

.. any plans for it ;-) ?

Regards,
Michal

12435 3 / Create an account to join the discussion.