We are using the toolkit to generate migration scripts to different environments.
Without having to parse through generated scripts to include the logic, it would be nice to have an option to include script to drop an index if it exists before adding it, or checking to see if it does exist before dropping it.
Ideally that would not be needed as one would assume that the scripts generated are against a specific target server, but we have a need to generate the scripts and then apply them to more than one server.
Any suggestions would be appreciated.
Without having to parse through generated scripts to include the logic, it would be nice to have an option to include script to drop an index if it exists before adding it, or checking to see if it does exist before dropping it.
Ideally that would not be needed as one would assume that the scripts generated are against a specific target server, but we have a need to generate the scripts and then apply them to more than one server.
Any suggestions would be appreciated.