Common Support Questions
Are administrator privileges required for installing RazorSQL on Windows machines?
Administrator privileges are not required to install RazorSQL. However, the
default setting for the Windows installer is to install RazorSQL in the
Program Files directory, which is probably not writeable for your logon id if
you do not have administrator privileges. There are two ways to get around
this:
1. The easiest is to download the latest razorsql<version>_windows.zip
file from http://www.razorsql.com/download.html
to your desktop. Then extract the zip file and navigate to the
razorsql<version> directory and launch razorsql.exe or razorsql.bat.
2. The second way is to launch the razorsql<version>_setup.exe Windows
installer and when given the choice as to where to install RazorSQL, be sure
to change the directory from the Program Files directory to a directory you
have write access to such as your desktop.
How to increase maximum memory settings for RazorSQL.
For Windows machines, the max memory setting is contained in a file called
razorsql.bat located in the RazorSQL installation directory. In this file,
there is a line containing the text -Xmx384M or -Xmx256M depending on the
version of RazorSQL you are using. Increase the number before the M, which
stands for MegaBytes, to increase the memory. To take advantage of the
change, RazorSQL must be launched by double-clicking razorsql.bat.
For Mac OS X machines, right-click on the RazorSQL application file and select
"View Package Contents". Edit the Info.plist file. In this file, there is a
line that contains either -Xms16m -Xmx256m or
-Xms16m -Xmx384m depending on the version of RazorSQL you
are using. Increase the 256 or 384 number to increase the memory.
For Linux / Unix machines, edit the razorsql.sh shell script. Increase
the number after the -Xmx to increase the available memory for RazorSQL.
How to save a query using RazorSQL.
There are a couple of ways to save the queries depending on how they were
executed.
For individual queries, the easiest way to save the query is to press
the "Save Query" button located on the query results toolbar or the
"Save Query" option located in the right-click menu of the query
results tab. You will then be prompted for where to save the
query to on your file system.
If you typed the query into the sql editor, you can do a
File -> Save or File -> Save As to save the editor contents to a
file on your computer.
If you did not execute the query from the editor, but used the navigator
or query builder to execute the query, you can click on the "view query"
icon in the query results toolbar or right click on "Query 1" and select
"View Query" to see the query that was executed. You can then do a
control-A / command-A and control-C / command-C to copy the query
to your clipboard.
Also, all queries you execute are stored and can be viewed by
selecting Connections -> View SQL History or Connections -> View Query Log. The
SQL History by default stores 20,000 lines of history. The query log
stores the history for the current connection.