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

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?

Thanks,
Dave
Sign In or Register to comment.