Error during compare

Compares and synchronizes SQL database content.

Moderators: Chris Auckland, David Atkinson, richardjm, david connell

Error during compare

Postby wesoos » Wed Feb 15, 2012 9:17 pm

When I compare a fairly large database in Azure, with a database locally, using the command line, I get an "Out of memory" error message. I'm using this for daily backups and it's not working...
wesoos
 
Posts: 3
Joined: Wed Sep 14, 2011 10:19 pm

Postby David Atkinson » Wed Feb 15, 2012 11:27 pm

Have you tried this tool instead? It should be more fit for purpose.

http://www.red-gate.com/products/dba/sql-azure-backup/
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby Brian Donahue » Thu Feb 16, 2012 4:08 pm

Hi,

SQL Data Compare is a 32-bit application because of the backup reader capability, so you may have better luck with Azure backup. But if the problem is a lack of free disk space for the cache of data, you could always try setting the RGTEMP environment variable.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests