What are the challenges you face when working across database platforms? Take the survey

Error: missing IDX file


We have a job that runs daily, comparing the data between two databases and then processing the differences.  Lately, we have been getting the following error during the run:

Error: Comparison of 'server\ecom.Puritan_Catalog' and
'server\ecomxt.Puritan_Catalog' failed: Could not find file
'C:\Windows\TEMP\Red Gate\SDC_d0a2c175d12449eaa61e7f430d53bcab.D.idx'.

Any ideas on what could be causing this?

We are running SQL Data Compare v. professional

Thanks for your help!

Best Answer

  • Options
    sam.blackburnsam.blackburn Posts: 224 Gold 2
    This is a temporary file which is normally deleted when SQL Data Compare exits (or when you close the project when using the GUI).  My guess would be that a cleanup utility running on the same machine has deleted the file while it was in use. 

    If you have difficulty identifying the process that is doing this, an alternative solution would be to set an environment variable called RGTEMP, which will tell SQL Data Compare where to store such temporary files. 
    Software Developer
    Redgate Software


Sign In or Register to comment.