RazorSQL is a software solution for users who need to execute SQL scripts and work with all major databases like Oracle, SQL Server, Sysbase or MySQL. This SQL tool embeds various features that allow users to create, alter, execute, describe and drop database objects such as tables, stored procedures, and functions.
The installation process goes seamlessly, so once you've run the application for the first time, you are greeted by a minimalistic GUI with standard menus and toolbars. It's quite easy to navigate through the main menu, though the interface could've had a more animated skin theme and the toolbar icons could'be been bigger.
Apart from the minor inconveniences mentioned before, RazorSQL is a realiable tool, equipped with lots of useful features. It has an SQL Editor that can be used to edit scripts and run SQL queries. More, with the aid of EditRocket code editor it can support over 20 programming languages such as SQL, TransactSQL, SQL PL, HTML, Java, or XML.
Furthermore, it comes with a built-in database, HSQLDB, that runs with no manual configuration out of the box. Also, the data collected in the databse can be exported in different formats like HTML, Excel, JSON, or XML.
To sum it up, RazorSQL is an important database manager, bundled with useful features and visual tool that allow users to complete their projects or daily tasks. The price seems moderate but you should keep in mind that it requires a powerful end system to perform at high capacity.
v6.0 [Oct 23, 2012]
Database Conversion: Added database conversion tools for converting the following types of databases: HSQLDB, MS Access, MS SQL Server, MySQL, Oracle, PostgreSQL, SQLite
Database Conversion: Added the ability to convert tables from the following database types to the RazorSQL local database: DB2, Derby, Informix, MongoDB, MS Access, MS SQL Server, MySQL, Oracle, PostgreSQL, SimpleDB, SQLite, Sybase
Database Conversion: Added Copy to Local Database option for copying tables from remote dbs to the local RazorSQL database
Added a Create Table from Results Option for creating a table from query results
Added a Create Local Table from Results for creating a local table from query results on a remote database
Added a Create Table from Results option for converting the query results to a table on another database
Added Query Referenced Table option to query results for foreign key columns
Add ability to view images - open an image file and display it
Added Search -> Goto Column option for the SQL editor
Added option to not include column names in output for Execute SQL - output to file
Added Insert - Insert from File option to the Inserts menu
For parameterized queries, add option for automatically wrapping character data in single quotes
Added an option for viewing a status log for each connection that includes queries executed, query times, and rows returned
Added 10 to Fetch Limit Rows option
Added Editor Backups option to the preferences for backing up files on save
Added binary data editing and image viewing with the SQLite JDBC Driver
Added support for binary data editing to the RazorSQL SQLite Driver
Ship with SQLite JDBC driver
SQLite - Auto expand navigator to show Tables, Views, etc.
Allow to change auto commit on the toolbar
Add SSH tunnel support for MongoDB
Added SQL favorites selector shortcut
Added a timeout for how long results / statements will stay open and added a preference for it
Added support for Derby 10.9
Add full screen mode on OS X Lion and Mountain Lion
Better auto-completion support for certain join types
Added a 64-bit only RazorSQL download for Windows
Better memory handling for SimpleDB queries with large result sets
Added Consolas as a fixed-width font
Recognize reserved words in generated SQL, including database specific reserved words
Added additional information to error messages displayed when queries or statements thrown an error
Feature-rich relational database known for its high performance and excellent concurrency
