Cannot find sp_dbcmptlevel

Forum for users of SQL Compare schema synchronization utility

Cannot find sp_dbcmptlevel

Postby Seonaidh » Wed Oct 05, 2011 5:11 am

Hello

This error occured when registering data sources. I am running a compare for the first time between an emtpy local SQL Express 2008 R2 database and an Azure database

I've since been sent this patch which resolved this issue thanks
ftp://support.red-gate.com/patches/SQL_ ... ePatch.zip
Seonaidh
 
Posts: 3
Joined: Wed Oct 05, 2011 5:05 am

Postby james.billings » Fri Oct 07, 2011 7:38 am

Glad you found the patch - feel free to email support if you have further trouble though!
james.billings
 
Posts: 1121
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Same issue is SQL Source Control

Postby sseelyredbox » Fri Oct 21, 2011 8:34 pm

Is there a chance that the SQL Source Control tool will get this fix for SQL Azure too? I would love to have it:)
sseelyredbox
 
Posts: 1
Joined: Fri Oct 21, 2011 7:51 pm
Location: Chicago, IL

Postby james.billings » Mon Oct 24, 2011 11:07 am

You may find the EAP of SQL Source Control 3 will support it, as it should be using the updated engine from SQL Compare (i've not personally tried it though)

Generally I don't think we'd envisage you'd source control an Azure DB directly, rather, you'd work on a local one then deploy it up to the cloud using SQL Compare.
james.billings
 
Posts: 1121
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: Bing [Bot] and 0 guests