Toad World® Forums

Alter scripts generation bug?


#1

Hi,
I tested the alter script generation feature with a concrete case. Here is what I did:

  • I made changes to some entities in different workspaces.
  • I use the “Sync and Convert Wizard” to “Generate Alter Script”.
  • On the “Select items” page, I deselect some entities.
  • I generate the script.

The generated script includes modifications to the entities I deselected previously. I repeated the operation a couple of times to make sure I was doing everything right (I also had another developer look after me to be sure) and I always got the same result.
Is this a known bug? If yes, when is it planned to be fixed? If no, what am I doing wrong?
Thanks,

gabriel


#2

Hello Gabriel,

Unfortunately, I’ve failed to simulate the problem.
What I did.

  1. Model A - updated model. Entity Customer has five attributes, one of them is a new FK attribute Test (added the TestRelationship from Customer Rating entity).
  2. Model B - the Customer entity has only one attribute (PK), there is no relationship between Customer and Customer Rating entity.
    So, I’m comparing the Customer entity and its changed properties.
  3. I run the Sync & Convert Wizard, leave default settings. On page Select Items, I deselect the Customer entity. Just to check out, I can see all its subitems are deselected automatically and also the TestRelationship. See the attachment.
  4. I generate the alter script. The script doesn’t contain any ALTER statement for the Customer entity.

Gabriel, please try to create two simple models illustrating the problem you encounter and send it to us. There can be many ways how to modify entity properties etc. We need more details. The sample models will be great. Thanks!
(Please send them to modeling@quest.com)

Regards,

Vladka


#3

Hello Gabriel,

Unfortunately, I’ve failed to simulate the problem.
What I did.

  1. Model A - updated model. Entity Customer has five attributes, one of them is a new FK attribute Test (added the TestRelationship from Customer Rating entity).
  2. Model B - the Customer entity has only one attribute (PK), there is no relationship between Customer and Customer Rating entity.
    So, I’m comparing the Customer entity and its changed properties.
  3. I run the Sync & Convert Wizard, leave default settings. On page Select Items, I deselect the Customer entity. Just to check out, I can see all its subitems are deselected automatically and also the TestRelationship. See the attachment.
  4. I generate the alter script. The script doesn’t contain any ALTER statement for the Customer entity.

Gabriel, please try to create two simple models illustrating the problem you encounter and send it to us. There can be many ways how to modify entity properties etc. We need more details. The sample models will be great. Thanks!
(Please send them to modeling@quest.com)

Regards,

Vladka
AlterTable.png


#4

Thank you, Vladka.
I tried to reproduce with a simple project and I can’t. However, I can always repro with the reverse engineering of our DB. I guess there’s something different that I can’t pinpoint. If I find how to repro, I’ll let you know.
Unless you want me to send the 2 txp files I use to create the alter script?

gabriel


#5

Hello Gabriel,

Yes, please. If you can, send them to modeling@quest.com. We will check out the problem on the models.
Please provide us with some information, e.g. if you modify any settings in the Wizard, what entity we can focus on etc.

Thanks!

Regards,

Vladka


#6

Ok, stupid me, I deleted the txp files used to generate the alter script, so I cannot repro and send the files to you.
If I can repro in the future, I’ll come back to you. Thanks for your time.

gabriel