Command line Azure Sync not working

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

Command line Azure Sync not working

Postby wesoos » Wed Sep 14, 2011 10:26 pm

I have been using SQL Compare 9 for months now to sync an Azure database with a local database for backing up purposes. I use the command line tools to sync the database and then sync the data, in a scheduled task every night.

Obviously recently, within last few days, Azure support broke due to a Azure release. I applied a patch from you guys in another post, which works fine when I use the GUI. But when using the same command line I have been using for months now, it throws the following error when trying to Sync the databases. "User does not have permission to perform this action."

Please help!
wesoos
 
Posts: 3
Joined: Wed Sep 14, 2011 10:19 pm

Postby Linda Hawksworth » Mon Sep 19, 2011 1:06 pm

The SQL Compare team will take a look to see if they can reproduce this behaviour. In the meantime, have you tried SQL Azure Backup? It has a command line interface. It can be downloaded from:

http://www.red-gate.com/products/dba/sql-azure-backup/
Linda Hawksworth
 
Posts: 192
Joined: Mon Jun 25, 2007 11:32 am

Postby wesoos » Mon Sep 19, 2011 6:27 pm

Guys, actually it is happening in the GUI as well. I am using a SQL server user account to do the synchronization. This account has db_owner role, but for some reason it's not allowing the sync. It registers the databases and does the compare, but throws the error when attempting to sync.

Thanks
wesoos
 
Posts: 3
Joined: Wed Sep 14, 2011 10:19 pm

Postby Brian Donahue » Wed Oct 19, 2011 11:13 am

I've looked at the debugging information you'd sent in and it appears you do not have permission to create a login, so this would have more to do with your role in the "master" database than your actual database role. The Azure dox from Microsoft suggest you need the loginmanager role.

Hope this helps!
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests