Out of Disk space

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

Out of Disk space

Postby hemantgaur » Wed Aug 25, 2010 9:12 pm

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.
hemantgaur
 
Posts: 20
Joined: Wed Dec 16, 2009 9:15 pm

Postby simon.jackson » Thu Aug 26, 2010 3:59 pm

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/C ... wledgebase\\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.
simon.jackson
 
Posts: 45
Joined: Thu Jan 08, 2009 10:42 am

Postby hemantgaur » Thu Aug 26, 2010 5:00 pm

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. :)
hemantgaur
 
Posts: 20
Joined: Wed Dec 16, 2009 9:15 pm


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest