I’ve been working with TDM for a while now, but till today I was not able to create an alter script successfully without having to manually change the script afterwards.
My process is that I create the model, then a create script is created with which the database is created. After that when I make changes to the model, I reverse engineer die original database again and create an alter script between the two. (Maybe my process is wrong)
Currently I’m sitting with a problem that the alter script is trying to drop a primary key, but the foreign key constraint still exists, so it doesn’t allow the script to drop the primary key until the foreign key is dropped first.
I’m ok with changing the scripts for now, but can this part of the system please be tested in full again for Oracle and MySQL Databases?