Index creation bug

nick_pointone

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?

AshaPatel

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?

Thanks,
Asha

nick_pointone

It wasn't set - In fact I had to set it to make the difference script execute properly.