Hello Toad Team,
i’am using the button “reverse engineering” to create a model from a mysql-5.1 database with the default settings from the wizard (Toad 188.8.131.52) and connection via tcp/ip as data provider.
This works good and the model is created …
But now i wonder why i need to manually relate a database-name to the model, like you see
in the following screenshot (i would have expected that the database-name of the database would be related automatically by the wizard?)
After that i need to relate all my entities with this database by using “Tools”->“Schema/Owner Assignment”. Only if i do this the “DDL Script” and the “Change Script” Generation will create sql scripts that are database-specific. So far this is all ok with me. In my opinion generated SQL-Scripts should always specify the database-name, because only then they can be executed safely, so that not the wrong database is filled with data or somethin like that. Example:
ALTER TABLE **DEV_V720.**SHIPPING_COSTS ADD PRIMARY KEY (Country,ArtType,OrderValue,ShopID)
ALTER TABLE **DEV_V720.**SHOPASPECT ADD PRIMARY KEY (ShopAspectID)
So far all ok with me…
But now when i want to synchronize the model with the database, to merge new changes from the database into the model (via “Model”->“Synchronize”->“Update Model”) all those schema/owner assignments will be shown as changes. Is there any way to hide those irrelevant changes ?
thanks in advance for help
orbiz Software GmbH