Drop Index Option

seblingsebling Posts: 22
edited August 12, 2005 12:37PM in SQL Compare Previous Versions
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.


  • Brian DonahueBrian Donahue Posts: 6,590 New member

    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.
This discussion has been closed.