Is it possible to ALTER statements for a single table directly against the database without having to first reverse-engineer the database?
WORKAROUND:
None.
STATUS:
Enhancement request CR76597 has been submitted to Development for consideration in a future release of Toad Data Modeler
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.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy