Is there a way to direct temporary files to a server file share? I'm trying to create a subset of a few hundred records out of a large sql database. The temp files going into the location currently set are filling up my hard drive with many GB of data.
There is an option in Toad that allows you to specify where to save your temp storage for data compare. You can get to this option by selecting Tools | Options | Data Compare – General.