Location of index files

• 
  Hi Martijn,
  
  We have logged a support ticket for you and will check with our development team and get back to you!

  Anu D October 23, 2015 06:54

  - 0 +
• 
  Hi Martijn,
  
  Thanks for your patience.
  
  At the moment there is no way to change the Index folder location and we have asked dev team to place this as a feature request.
  
  You can clear all the files and SQL Search will recreate them and that might improve the log on process.
  
  Does this help?

  Anu D October 23, 2015 10:41

  - 0 +
• 
  Hi support,
  Having SQL Search tool now distributed with Visual Studio 2017 this problem will affect much more users than before.
  Forever growing profile is a real problem in corporate PCs.
  Please make the index location configurable.
  Also please consider adding a big RED button to clear index files.
  
  Thanks,
  Puterdo.

  puterdo_borato February 15, 2018 09:42

  - 0 +
• 
  Hi @puterdo_borato
  
  Thanks for your post.
  
  You can always make feeature suggestions on our SQL Search Uservoice in my link below.
  
  https://redgate.uservoice.com/forums/101149-sql-search
  
  Kind regards

  RichardL February 19, 2018 14:40

  - 0 +
• 
  Hi,
  
  By default, all of Redgate's SQL tools create temporary files in the Windows Temp directories:
  C:\Windows\Temp
  or
  C:\Users\<user name>\AppData\Local\Temp
  
  You can configure the RGTEMP environment variable, so that temp files our software generates are created in the RGTEMP location. For SQL Search, it will create the index files in this folder and not the default.
  
  If you wish to try out the RGTEMP environment variable, please follow the steps below.
  
  1. On another disk drive, create a folder called RGTEMP. For example,

  D:\RGTEMP
  

  2. Right click 'MyComputer' or 'This PC' and select properties.
  3. Select 'Advanced system settings'.
  4. Click the 'Environment Variables' button.
  5. In the 'System variables' section, click the new button.
  6. For the 'Variable name' enter RGTEMP.
  7. For the 'Variable value' enter the path specified in Step 1, for example

  D:\RGTEMP
  

  8. Click the 'OK' button total of 3 times, to close the dialog windows that opened.
  
  In some cases you may need to restart the machine for the change to take effect.
  
  Once the RGTEMP Environment Variable is in place, the Redgate tools will create their temporary files in the (using my example)

  D:\RGTEMP
  

  folder, which may prevent any issues occurring from using the default Windows Temp directories.
  
  Hope the above helps.
  
  Many Thanks
  Eddie

  Eddie D February 19, 2018 16:32

  - 0 +

Add comment

Please sign in to leave a comment.