Options
SQL Data Compare 10.7.0.23: Runs out of disk space on C:
SQL_ME_RICH
Posts: 112
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
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
Comments
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?