What are the challenges you face when working across database platforms? Take the survey

Not handling Clustered->Nonclustered index change

dave.novellidave.novelli Posts: 2
edited August 21, 2008 10:35AM in SQL Compare Previous Versions
I have made a change to my dev database where I changed the primary key index to nonclustered, and created a new clustered index on a completely different field.

Compare attempts to add my new clustered index without first altering the existing clustered index, and an error results.

I can certainly modify the update script manually to get around this - but is there something I'm not doing that would make this work correctly?

Sign In or Register to comment.