Run out of diskspace in SQL Data compare SDK

Automate and integrate using the SQL comparison API

Moderators: Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Run out of diskspace in SQL Data compare SDK

Postby Philn » Sat May 25, 2013 1:02 am

Hi,
Is there an option to set in the SQL Data Compare API to place the temp files into a different path instead of the C:\\ drive?
I am comparing a large databases with many tables and the default temp files are in C drive which I don't have much empty space.
Thanks
philn
Philn
 
Posts: 7
Joined: Fri Feb 01, 2013 11:53 pm

Postby Brian Donahue » Tue May 28, 2013 10:31 am

Hi Phil,
It's not a method explicitly in the API but what you can do is set the "RGTEMP" environment variable value to the name of a folder on a different drive with lots of free disk space. In .NET, you can use the System.Environment object and add the RGTEMP variable to your own process. That should do the trick!
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Philn » Wed May 29, 2013 12:58 am

Hi Brian,
thanks for replying. I tried your suggestion, but it seems doesn't do anything - Not sure what I am missing.
I put Env variable (RGTEMP) in both user variable and System Variable and the api still doesn't recognize it.
philn
Philn
 
Posts: 7
Joined: Fri Feb 01, 2013 11:53 pm

Postby Brian Donahue » Thu May 30, 2013 3:58 pm

If you're setting it in code you probably want to set it in the process, otherwise you have to restart the process to get the variable read in, which won't do you much good.
Code: Select all
Environment.SetEnvironmentVariable("RGTEMP", "d:\\\\temp", EnvironmentVariableTarget.Process);
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Philn » Mon Jun 03, 2013 10:55 pm

I got it!, I restarted my machine, Doh!, it's work now.
Thanks Brian.
philn
Philn
 
Posts: 7
Joined: Fri Feb 01, 2013 11:53 pm


Return to SQL Comparison SDK 10

Who is online

Users browsing this forum: No registered users and 0 guests

cron