SQL Azure table cannot be altered because temp table problem

wyx2000

When I move table difference to SQL Azure, SQL compare will need create temp table and then copy data over, but the temp table created doesn't have cluster index, and SQL Azure doesn't allow table without cluster index, so that prevents the migration, is there any way to solve it? OR will there a new version soon that have it fixed?

Chris Auckland

Thanks for your post.

This has actually been fixed in the next update (10.2); which should be released tomorrow.

Our internal tracking code for this is SC-5128

Chris Auckland

Have you had a chance to try SQL Compare 10.2 yet?

wyx2000

Chris Auckland wrote:

Have you had a chance to try SQL Compare 10.2 yet?

Where do I download 10.2? I tried the SQL bundle trial, it still gives me 10.1

Chris Auckland

You can get it from 'help > Check for updates'.

CFU is likely to be the first place you can get patches, as the release process to make it into the bundle takes a little longer.