Error during compare

wesoos

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...

David Atkinson

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

http://www.red-gate.com/products/dba/sql-azure-backup/

Brian Donahue

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.