SQLBrowser Directories

From SQLBWiki

Jump to: navigation, search

Contents

[edit] 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 locate the Installation Directory in SQLBrowser: 
 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] 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

If you are unhappy with this location (e.g. Roaming Profiles) you can override it 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 locate the User Directory in SQLBrowser: 
 Click 'Help / System Info' and lookup the System Properties List for the property netbeans.user. This directory is the user directory


[edit] 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 locate the Output Directory in SQLBrowser: 
 Click 'Tools / Options - SQLBrowser / General' and lookup the value for the Output Directory


[edit] 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 produces its output. see Batch Analysis for more information The Input Directory or URL is set in the options per server


[edit] Persistent Files

  • SQLBrowser saves its configuration in a set of files
  • These files contains your last windows locations, your templates, your server names etc...
  • These files are saved under the 'user directory'. See SQLBrowser Directories if you don't know what is the user directory.
  • This directory can be overriden when passed on the command line through the --userdir argument
  • If this directory is not passed on the command line, its location is, under Windows, in: 
 C:\Documents and Settings\<user>\Application Data\.sqlbrowser
  • This directory contains many configuration files, but the main SQLBrowser files that you want to save are under: 
 C:\Documents and Settings\<user>\Application Data\.sqlbrowser\dev\config\Preferences\com\sqlbrowser
  • Please save this directory tree in case of trouble after an upgrade or some other corruption (see procedure in Troubleshooting)
Retrieved from "http://www.sqlbrowser.com/wiki/index.php/SQLBrowser_Directories"