Out of Disk space

[hemantgaur]

I am comparing around 70-80 tables. Tables have huge volume of data and I know the differences are of huge as well. The statement "session.CompareDatabases" executes for around 15 minutes. While it is executing, I notice my disk space in C drive continuously reduces. And eventually runs out of disk space and throws an IO exception and terminates.

Is there a way to force Red gate to write the temp files that it is writing to my D: drive? It would take me a long time to ready a bigger C drive, but would be easier to just add another drive, call it D, and point red gate to write to it.

Please help. This is an urgent issue and stopping us from testing any further.

[simon.jackson]

Hey, there's a couple of things you can do.

In order to choose the location of all temporary files for red gate products you can set the RGTEMP variable. This is described in full here
http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Data%20Compare&c=knowledgebase\SQL_Data_Compare\KB200810000312.htm


You can also turn on "compress temporary files" in the data compare options. There is a slight downside to this, in that you can't sort the results, but it will considerably reduce the disk usage.

[hemantgaur]

that worked perfectly. Though a reboot was required. So just wanted to add that.

Thank you Simon. You were a big help, TWICE in a day.