SQL Data Compare 10.7.0.23: Runs out of disk space on C:

Compares and synchronizes SQL database content.

SQL Data Compare 10.7.0.23: Runs out of disk space on C:

Postby SQL_ME_RICH » Fri Apr 25, 2014 1:27 am

Hello -

Attempting to see if SQL Data Compare will work for some table sync needs that we have, but in using the Unlicensed trial version of the tool, I am unable to find a place where I can redirect temporary data storage that the tool is wanting to store during a compare (and my server's local disk only has about 6gb of free space left - more than enough to not warrant any dangers normally, but completely taps out when I run SQL Data Compare against 4 tables that total around 20gb between all 4 of them). The SQL Data Compare is being run on one of the servers being compared, but the target server is a different VM all together with it's own instance and database.

Is there any way for me to tell the program to use another one of the mapped drives on my server? I am running a VM with Windows Server 2008 R2 Standard (SP1), and while my SQL database files are local - I do not have SSMS installed on the server, so it uses a custom program for the SQL editor (isqlw.exe) with the following arguments...

-S "%SN%" -d "%DN%" -E -1 -FU -f "%SF%"

I tried setting the Deployment scripts and Export defaults to mapped drives, but it has no effect on this issue.

Any help / assistance would be much appreciated.

SQL_ME_RICH
SQL_ME_RICH
 
Posts: 64
Joined: Tue May 08, 2012 10:41 pm

Postby Brian Donahue » Fri Apr 25, 2014 10:48 am

SQL Data Compare creates a cache in your user profile to hold the data of large tables. If you want to change the location that this uses, you can set the RGTEMP environment variable. If you do this in the system properties->advanced->environment variables, then all Red Gate tools that use temporary storage will redirect to that folder.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

RGTEMP Doesn't Work

Postby SloopJohnB » Wed May 07, 2014 4:48 pm

Hi -
I ran into the same issue raised by the OP, and tried setting up an RGTEMP environment variable pointing to a drive with more space. But the setting doesn't seem to work. Does it matter if environment variable is a system variable or a user one?
SloopJohnB
 
Posts: 18
Joined: Sat Jul 22, 2006 1:19 am


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest