I thought of sharing my experience using the sql Generation Dialog.
It doesn’t have a Close button at the bottom. Minor, but a bit annoying when I come to this dialog very often.
re: Actions: I am not to sure how Actions are supposed to work. Every time I change a setting in that dialog I am scared that I am going to loose that setting so I end up saving the action - The problem is that it creates a new action every time even when I use the same name instead of overwriting the one with the same name and I end-up having to items with the same name in the Load Action drop-down.
How about renaming Action to Generation Settings and changing the behaviour to overwrite the settings with the same name. Otherwise I have to use numbers, Action01, Action02 … to know which one is the last one which becomes annoying when you make changes and re-generate the script often.
-Not all the foreign keys of the tables I selected are included. In the Referential Integrity tab I checked Always, so I thought all the foreign keys are selected from the tables I selected for generation but that’s not true. I had to go Select List -> Relationships and check them there.
That’s it for now with this dialog.
Overall, my experience with the tool has been so and so. This morning when I came, some changes I made yesterday were gone. I left the program running. Not sure what happened. Maybe there is no point in mentioning it, but what the heck. Now I got into a paranoid mode and I click Apply every time I have a chance and save very often.