Index creation bug

Why does the tool regularly fail complaining that an index its trying to create already exists?
Surely the tool should drop the existing one first, if it exists before creating the new one?


  • Hello,

    SQL Compare should indeed either drop the existing index before creating the new one, or alter the existing one. Could you check the project options you are using to make sure you don't have the "Ignore indexes" option set and let us know if that's solved your problem?

  • It wasn't set - In fact I had to set it to make the difference script execute properly.
Sign In or Register to comment.