Make Working With Many Schemas Easier in the Project Creation Wizard
We have dozens of schemas in our shared test database, and they're all part of the same project, so they would be versioned together.
The current flow of the project creation wizard makes adding all these schemas one at a time to the new project a real pain.
So, at the moment, when creating the project, we have to choose a single schema from Step 3 (Choose a Schema), then type in the name of the schema to serve as the folder name in Step 4 (Choose a Folder), then click "Add another schema..." and do the same thing again for the next schema, etc., over and over again.
It would be nice if you could just select the dozen or so schemas we need to be versioned all in one step, and then simply default the folder names in version control to be the schema names and be done with it - if the user wants to change the folder names, they can, but in our case, defaulting the folder to the schema name would be fine, so after choosing all the schemas all in one step, we'd be done.
I realize that would take some rearrangement - perhaps in the meanwhile, you could simply default step #4's (Choose Folder/New Folder) new folder field to be the name of the schema in the wizard.
In Redgate Change Control, our migrations-based versioning tool, users can specify multiple schemas in a comma separate list. We’re working to merge these tools together and have 1 tool for versioning database changes. When we do this, we’re hoping to make working with multiple schemas easier.
Please let me know if you have any questions about this.