How can change the TMP file location from C:\ drive to another

Ashutosh

Hi 
I am running comparison between two tables having around 14m records. SQL data compare creates multiple .tmp files in C:\Users\abc.xyz\AppData\Local\Temp\Red Gate. Based on the volume of data in comparison increases the size of the file. This is currently consuming lot of space in C:\ drive.
Is there a way i can change the location of these tmp files?

Michelle T

Yes - you can set the RGTEMP environment variable. See https://documentation.red-gate.com/display/SDC13/Getting+better+performance+out+of+SQL+Data+Compare for more details.