What are the challenges you face when working across database platforms? Take the survey

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

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?


Sign In or Register to comment.