Azure, checksum, and sp_table_validation

jjorczakjjorczak Posts: 5
edited October 19, 2011 1:48PM in SQL Compare Previous Versions
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?
· Share on Twitter

Comments

  • James BJames B Posts: 1,124 Silver 4
    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.
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
  • jjorczakjjorczak Posts: 5
    Thanks. I am wondering this this sp can be deployed to the local database and used?
    · Share on Twitter
  • James BJames B Posts: 1,124 Silver 4
    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.
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
Sign In or Register to comment.