SQL Data Compare Files

cccanody · February 13, 2006 2:35PM

How do I change the location where SQL Data Compare stores it's working files when doing a comparison?

I have a large file to compare but limited disk space on the default disk.

cccanody · February 13, 2006 2:54PM

Never mind - I was finally able to get to a FAQ that gave me the answer. It would be helpful if this could be selected at the time of the data compare and not affect all other applications that may be using my profiles TEMP folder.

Brian Donahue · February 14, 2006 1:22PM

Hello,

That's not a bad idea, as the default temporary storage location is on the most abused drive on your computer; the system drive.

You have to go into your system properties and change the environment variables so that the TMP variable points to a larger drive. This, of course, affects your whole system.

cccanody · February 14, 2006 1:29PM

Thanks for the reply

Tom Harris · March 9, 2006 4:04PM

Hi there,

in SQL Compare 5/Data Compare 5 it will be possible for the user to set the location for all temp files.

Thanks,

Tom Harris

Red Gate Software

cccanody · March 9, 2006 4:10PM

Thanks for the update

SQL Data Compare Files

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk