Greetings again team,
As I’ve been using TDM for more and more intense projects, I’m finding that sometimes I need to simply drop and reload my stored procedures to accommodate for some logic changes or a new column added to the schema.
The SQL Generator is wonderful in that there are so many options to choose from. Once it was explained on how to save the generator options for a specific model, I was set! My “default” model drops all objects (if they exist) and rebuilds everything. This is ideal when I need to restart my development environment.
What would you think about the option of having “Generator Profiles” for each model. It would be something the user had to create, but that way I could have a "Full Model’ generator script, a “Stored Procedure Only” generator script, even a “Data Only” or “Data Loading” script as I need it.
All it would do would just save the check box options I have already specified. This would save me time, and potentially errors as well. A couple times in the past I was unchecking and rechecking the options needed for just my procedures and missed unchecking the “drop tables” option. I had missed this when the script ran and I had to rebuild all my test data.
I realize this may be difficult to implement or more of a “niche” feature, but I wanted to bring it up as something for your team to think about.
Keep up the great work!