Azure, checksum, and sp_table_validation

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

Azure, checksum, and sp_table_validation

Postby jjorczak » Mon Oct 17, 2011 3:37 pm

When trying to do a checksum compare with a SQL Azure database, SQL Data Compare reports that 'sp_table_validation' is not found. Is there a workaround for this?
jjorczak
 
Posts: 3
Joined: Mon Oct 17, 2011 3:27 pm

Postby james.billings » Wed Oct 19, 2011 5:29 pm

Thanks for your post.

The procedure you mention doesn't appear to exist in Azure (at least, if I connect to an Azure instance and try to execute it, it says it doesn't!)

As this is the procedure that's used to perform the checksum in \"normal\" SQL, the workaround is to basically turn that option off.

I'll have a chat to the developers though to see if there's some alternative offered in Azure that it could use instead.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby jjorczak » Wed Oct 19, 2011 6:40 pm

Thanks. I am wondering this this sp can be deployed to the local database and used?
jjorczak
 
Posts: 3
Joined: Mon Oct 17, 2011 3:27 pm

Postby james.billings » Wed Oct 19, 2011 6:48 pm

No idea; it's a system one so if it's not supported in Azure I would guess there's a reason for that. It may be to avoid performance problems, or possibly it's because it relies on some other feature in SQL Server that's also not present in Azure.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: Google [Bot] and 2 guests