SQLBrowser Directories
From SQLBWiki
Contents |
[edit] SQLBrowser Installation Directory
This 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.:
J:/tools/sqlbrowser_Jun08_222_Official
The only thing that count for this directory is that it is 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] SQLBrowser 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] SQLBrowser 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] SQLBrowser 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 input directory, but it more interesting to make it point to the location of a shared drive where a scheduled batch analysis produces its output.
How to locate the Input Directory or URL in SQLBrowser: Click 'Tools / Options - SQLBrowser / General' and lookup the value for the Input Directory or URL
see Batch Analysis for more information
