SQL Data Compare

eprivotteprivott Posts: 6
edited September 20, 2006 12:28PM in SQL Data Compare Previous Versions
What files are created when the Data Compare is ran? Where are they? Can they be deleted? I've noticed alot of disk space used after a sql data compare is ran.



  • Brian DonahueBrian Donahue Posts: 6,590 New member

    Data Compare needs to use a lot of temporary storage files for processing data. By default, these exist in the %TMP% folder, although this can be configured by setting the %RGTEMP% environment variable.

    Once the comparison project is closed, these files are disposed of. I could imagine in the case of a program error in SQL Data Compare, some files may be left behind, but normally they're all deleted when a project is closed or the program is exited normally.
This discussion has been closed.