SQL Azure table cannot be altered because temp table problem

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

SQL Azure table cannot be altered because temp table problem

Postby wyx2000 » Sat May 12, 2012 7:51 pm

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
 
Posts: 13
Joined: Mon Oct 03, 2005 7:56 am

Postby Chris Auckland » Mon May 14, 2012 8:18 pm

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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby Chris Auckland » Thu May 17, 2012 11:28 am

Have you had a chance to try SQL Compare 10.2 yet?
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Re:

Postby wyx2000 » Fri May 18, 2012 11:51 pm

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
wyx2000
 
Posts: 13
Joined: Mon Oct 03, 2005 7:56 am

Postby Chris Auckland » Mon May 21, 2012 12:48 pm

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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests