I’m currently evaluating the Toad Modeler for usage in our organization. I’m using the trial version 22.214.171.124 against an existing MS Access 2000/2003 database to reverse engineer modifiy and recreate it.
We also have MySQL, MS-SQL and Oracle databases running so I’ll be looking at transfering our models from one engine to the others.
I encountered a problem regarding indexes for some of the concerned tables: indexes have been created for a few of them, but with no fields indicated in the “item” section of the “Indexes” tab.
There we no such indexes on the original Access tables, and it went seemlessly when I recreated the Access DB, but created a syntax error when I converted the model to test it against a MySQL DB on the following statement:
CREATE INDEX EQUIPEMENTEQUIPEMENT_IMPLANTE ON EQUIPEMENT_IMPLANTE ();
That error (creating an index without indicating the indexed attribute) went unnoticed by the “Verify model” function. Is this a normal behavior? Have I missed a manipulation in my process (other than manually checking all indexes?)
Thanks for the insight!