Toad World® Forums

sync a model to database


#1

The help docs says I can sync a model to database, but the only options I find in the sync wizard is with one model to another.

I REed our database using the modeler. I then altered that model by adding comments to a table. Now I want to generate an alter script to add all those comments to the database itself. How can I do this?

I really hope I don’t have to RE the database again to compare two models. REing the database is a 16 hour process…


#2

Hi,

In full version you have to do the RE again, compare two models and generate alter script for them.
In Beta 3.5.3.1 it is not necessary. You simply open the Sync & Convert Wizard from the updated model and on page Select Right Side of the wizard, via the Reverse Engineering Alias box you can connect to your db directly. So, prior RE is not necessary.

Unfortunately, Beta 3.5.3.1 expires on 1 February and therefore the Beta download link was disabled. Another Beta is not available at the moment, we are working on it. So, you will be able to check out this feature when the new Beta is released, which can be in a week or two.
Thanks for your patience.

In any case, forward engineering is not supported in TDM. So, you need to use a third party software to run the generated alter script in database. If you use Oracle db, you can use Toad for Oracle that is integrated with TDM. (Please see Settings | Options | Toad for Oracle Integration.) You can also select Toad for Oracle as a default editor to open every generated SQL script in Toad for Oracle. (See the Help file for more information.)

Regards,

Vladka