Drop Index Option
sebling
Posts: 22
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.
This discussion has been closed.
Comments
It's been suggested quite often that we do this. It looks unlikely, however, because the software is not designed to modify databases that had not originally been compared.