Command line Azure Sync not working

Forum for users of SQL Compare schema synchronization utility

Command line Azure Sync not working

Postby wesoos » Wed Sep 14, 2011 9: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!
Posts: 3
Joined: Wed Sep 14, 2011 9:19 pm

Postby Linda Hawksworth » Mon Sep 19, 2011 12: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:
Linda Hawksworth
Posts: 192
Joined: Mon Jun 25, 2007 10:32 am

Postby wesoos » Mon Sep 19, 2011 5: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.

Posts: 3
Joined: Wed Sep 14, 2011 9:19 pm

Postby Brian Donahue » Wed Oct 19, 2011 10: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: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests