RazorSQL 5.6.3

RazorSQL is an SQL query tool, SQL editor, database navigator and database administration tool.

RazorSQL can connect to any JDBC or ODBC (Windows only) compliant database, has been tested on over 25 databases, and includes built-in connection capabilities for DB2, Derby / JavaDB, Firebird, FrontBase, HSQLDB, Informix, Microsoft SQL Server, MySQL, OpenBase, Oracle, PostgreSQL, SQLite, Sybase Adaptive Server Enterprise, and Sybase SQL Anywhere.

RazorSQL provides both easy to use visual tools and advanced features to allow users to do database browsing, editing, management, administration, and programming.

Installation:

Download and unzip razorsql4_2_1.zip. Open a terminal window. Navigate to the directory where you unzipped the zip file and then to the razorsql4_2_1 directory.

Either launch the shell script or the executable jar file:

./razorsql.sh (you may need to execute a chmod on razorsql.sh before launching -- chmod 755 razorsql.sh)

or

java -jar razorsql.jar

If java is not in the path, type the full path to the java program, for example:

/usr/jdk1.6.0_04/bin/java -jar razorsql.jar

If using the shell script and java is not in the path, make sure to edit the script so that the full path to java is specified.


Product's homepage

Here are some key features of "RazorSQL":

· Visual tools for creating, editing, dropping, describing, altering, and viewing tables, views, indexes, and sequences
· Visual Tools for creating, editing, dropping, and executing stored procedures, functions, and triggers
· A database navigator for the viewing of database objects and structures
· A robust programming editor that supports 20 programming languages including SQL, PL/SQL, TransactSQL, SQL PL, HTML, XML, and more.
· Export Tool - Export data in various formats
· Import Tool - Import data from delimited files, Excel files, or fixed width files into tables
· Ships with a built-in relational database engine (HSQLDB) that is up and running out of the box and requires no end-user administration
· Table / SQL Query Compare tool for comparing tables or queries across multiple connections
· Auto column and auto table lookup
· SQL Formatter
· SQL Query builder tool
· SQL Query Scheduler tool
· Command Line Interface
· Works with all major operating systems including Windows, Mac OS X, Linux, Solaris, and any other Java enabled OS
· Tested with Apache Derby / JavaDB, Daffodil DB, DB2, Firebird, FrontBase, H2, HSQLDB, Informix, Ingres, Interbase, Mckoi, Microsoft Access, Microsoft SQL Server, Mimer SQL, MySQL, OpenBase, Oracle, Pervasive, Pointbase, PostgreSQL, Solid, SQLite, Sybase Adaptive Server Enterprise, Sybase SQL Anywhere, and Teradata

Limitations:

· 30 days full trial

What's New in This Release: [ read full changelog ]

Enhancements:

· RazorSQL can now read configuration files such as connection profiles from a central location on launch
· Added a preference for whether to highlight SQL statements on execute
· Added a preference for whether to warn when update / delete statements with no where clause are executed

Changes:

· SQL Editor: If only one statement is present, do not highlight the statement on execute