How can we help you today? How can we help you today?

SQL Azure table cannot be altered because temp table problem

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?
wyx2000
0

Comments

4 comments

Sort by
  • 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
    0
  • Chris Auckland
    Have you had a chance to try SQL Compare 10.2 yet?
    Chris Auckland
    0
  • wyx2000
    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
    wyx2000
    0
  • 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.
    Chris Auckland
    0

Add comment

Please sign in to leave a comment.