SQLBrowser Directories

From SQLBrowser

Jump to: navigation, search

There are 4 important directories to know.

Contents

[edit] 1 - Installation Directory

This is where you unzip SQLBrowser. It may be in program files e.g.: 

 c:\program files\sqlbrowser_Jun08_222_Official

Or it can be a directory on a shared drive e.g.: 

 S:\SQLBrowser\sqlbrowser_Jun08_222_Official

Important: This directory must be new for every new installation of SQLBrowser. i.e. do not unzip SQLBrowser over an old distribution
Tip: always unzip the distribution by keeping the root directory. Do not remove the root directory containing the distribution name.
For instance, the 2 directories above are good names for installation directories. On the other hand, c:\sqlbrowser is a bad installation directory as you don't identify the version and you may overwrite it with a newer version 

 How to find the Installation Directory 
 Click 'Help / System Info' and lookup the System Properties List for the property netbeans.dirs. The directories listed are all in the Installation Directory

[edit] 2 - User directory

This is where sqlbrowser saves the user preferences. This directory is by default located on: 

 C:\Documents and Settings\<user>\Application Data\.sqlbrowser
  • Watch out: this directory is Hidden by default on XP.
  • This directoy contains your last windows locations, your templates, your server names etc...
  • Please save this directory tree in case of trouble after an upgrade or some other corruption (see procedure in Troubleshooting)
  • This directory can get big.
  • We strongly advice to repoint this directory to something like c:/temp/sqlbrowserUserDir You do this by using the --userdir command line option See Command Line
  • NB: You may have to delete this directory in case of trouble restarting SQLBrowser after an update. Please refer to SQLBrowser Persistent Configuration to figure out how to save important preferences such as your server names and passwords 
 How to find the User Directory 
 Click 'Help / System Info' and lookup the System Properties List for the property netbeans.user. This directory is the user directory

[edit] 3 - Output Directory

This directory is specified in the Tools / Options menu and is used to produce:

  • the sqlbrowser log file named sqlbrowserlog.txt (to send in case of issues) and
  • the batch analysis HTML report

A typical location for the ouptut directory is: 

 c:/temp/sqlbrowserOutputDir
 How to find the Output Directory 
 Click 'Tools / Options - SQLBrowser / General' and lookup the value for the Output Directory

[edit] 4 - Input Directory or URL

This is the directory or URL from which the dependencies.txt & schema.xml batch analyis output files are read when a server is opened. This directory can be set to the the same value of the output directory, but it more interesting to make it point to the location of a shared drive where a scheduled batch analysis is produced.
see Batch Analysis for more information 

 How to find the Input Directory 
 Click 'Tools / Options - SQLBrowser / Servers'
Retrieved from "http://www.sqlbrowser.com/wiki/index.php/SQLBrowser_Directories"
Personal tools