-
Title
Is it possible to ALTER statements for a single table directly against the database? -
Description
Is it possible to ALTER statements for a single table directly against the database without having to first reverse-engineer the database?
-
Resolution
WORKAROUND:
None.STATUS:
Enhancement request CR76597 has been submitted to Development for consideration in a future release of Toad Data Modeler -
Defect ID
CR76597 -
Additional Information
In TDM it is possible to open a model, run Sync & Convert wizard and select reverse engineering Alias as a "right side" source. That means you can compare your model with physically existing database. On table level it would be too complicated and risky. Imagine adding an attribute to PK in the table. This action will affect all child entities, but if you tried to do only single table-to-table comparison, some updates may be lost. That's why it is recommended to compare model with database and generate alter script. It may take longer, but result should be better.