RazorSQL

RazorSQL is a commercial software that can be successfully used for database manipulation. It allows for SQL queries, database editing, database navigation, as well as database administration. The application provides users with both easy to use visual tools and advanced features that allow them to browse, edit, manage, configure and develop databases.

Features at a glance

It is comprised of database tools, data import functionality, a database browser, a SQL query builder, a tool to edit database tables, data compare utilities, a built-in database, export data functionality, database query tool, and a SQL editor. At the moment, the program has been tested with numerous database servers/engines, including MySQL, DB2, Daffodil DB, Apache Derby / JavaDB, DBASE, Firebird, DynamoDB, FrontBase, HSQLDB / HyperSQL, H2, Informix, Interbase, Ingres, Mckoi, Microsoft SQL Server, and Microsoft Access.

Supports a wide range of databases

In addition, it provides support for the Mimer SQL, Netezza, Oracle, OpenBase, Pervasive, PostgreSQL, Pointbase, SimpleDB, SQLite, Solid, Sybase Adaptive Server Enterprise, Teradata, and Sybase SQL Anywhere databases. The tool can also be used to export or import data in/from various formats, generate view, index and table for DDL (Data Definition Language), create, drop, execute and edit stored procedures, triggers and/or functions, as well as to backup databases.

Supports over 20 programming languages

Over 20 programming languages are supported by this application, including XML, SQL, HTML, PL/SQL, TransactSQL, and many others. Another interesting feature is the ability to connect to various database servers through PHP Bridges. As mentioned before, the application is not free and it costs $99.95 per user if you buy a single license, $96.95 per user if you purchase up to nine licenses, $94.95 per user for 10 to 19 licenses, and $92.95 per user if you buy 20 or more licenses.

Under the hood and supported OSes

RazorSQL is written in the Java programming language, but this should not be an inconvenient to use it for all your database tasks, especially because it is supported on Linux, Solaris, Microsoft Windows and Mac OS X operating systems.

What is new in this release:

• Bug Fixes:
• For machines with certain network configurations the process to connect to the database is taking longer than it should
• Cassandra: List, Map, and Set data types not showing correctly in the database browser or generate DDL tools
• Salesforce: excludes query syntax throwing parsing error
• Salesforce: chaining together more than 3 tables in a query throws an SQL parser error
• Salesforce: Empty values being returned if more than two tables are chained together in SOQL joins

What is new in version 6.3.8:

• Enhancements:
• Added PostgreSQL materialized view support
• Added support for creating projects and interacting with projects via a tab on the file system browser
• Enhanced materialized view options on the database browser for Oracle
• Added an option to print line numbers when printing via the web browser option
• Changes:
• Expansion of materialized view node in database browser now shows view columns
• Bug Fixes:
• DynamoDB: All columns not always displaying in select * queries
• PostgreSQL Database browser not differentiating among overloaded functions

What is new in version 6.3.5:

• Enhancements:
• Filter Query Results Tool: Added options for matching any column in a row with equals, contains, or in operations
• Import Tool - If column names included on first line of delimited file or excel spreadsheet, try to populate column number field based on order of column names
• Command Line Export Tool: Added multi-value insert syntax option for supported databases
• Command Line Backup Table Tool: Added multi-value insert syntax option
• Command Line Backup Table Tool: Added included identity column insert option
• Command Line Backup Schema Tool: Added multi-value insert syntax option
• Command Line Backup Schema Tool: Added included identity column insert option
• Changes:
• Changed process for getting PostgreSQL type information to improve performance
• No longer display keep-alive errors for SQLite
• Bug Fixes:
• Database Browser: Informix tables and views not always getting sorted in the correct order
• DyanmoDB: Generate DDL tool not generating column types when tables have both hash and range keys
• DynamoDB inserts against tables with more than one global secondary index throwing errors
• DynamoDB describe table not showing all global secondary indexes

What is new in version 6.3.4:

• Enhancements:
• Added H2 database conversion support to and from HSQLDB, MySQL, Oracle, SQLite, MS SQL Server, PostgreSQL, and MS Access
• Added MonetDB support
• Changes:
• When closing RazorSQL with unsaved files, added a cancel option to the Yes/No save dialog
• New session window no longer required mouse to navigate
• Changed memory settings on Mac OS X 64-bit version
• Bug Fixes:
• DynamoDB select count(*) queries with where clauses - where clauses getting ignored
• Percent of original size field not showing correct values in zip file viewer

What is new in version 6.3.3:

• Enhancements:
• DynamoDB: Add global secondary indexes and local secondary indexes to the describe tool
• DynamoDB: Add global secondary indexes and local secondary indexes color indicator to the database browser
• DynamoDB: Upgraded to latest AWS libraries
• Increased launching performance of edit table tool
• Increased launching performance of alter table tool
• Changes:
• Execute Procedure Tool: For Oracle, now supports REF CURSOR as an IN OUT parameter if no value is set for the REF CURSOR as an IN param
• Bug Fixes:
• DynamoDB - does not support tables with dashes in the name
• DynamoDB: tables with global secondary indexes not showing key information
• DynamoDB: describe tool not showing information for tables with global secondary indexes
• DynamoDB: Tables with no rows not showing columns in the database browser
• DyanmoDB: Unpopulated index columns not showing as columns in database browser
• Read only version does not allow to change databases

What is new in version 6.3.2:

• Enhancements:
• Added MariaDB support
• Added the Oracle 12c JDBC drivers
• Bug Fixes:
• Dynamodb - Export with generate DDL not working for tables with periods in the name

What is new in version 6.3.1:

• Enhancements:
• Added close all query results option to right-click menu of query results tab
• SQLite: Enabled foreign key support by default for new connections
• SSH Client: Added ability to enter separate passphrase for private key file
• SSH Tunnel Tool: Added ability to specify a pass phrase for a private key file
• Added a MariaDB driver option to the MySQL connection type options
• Ship with MariaDB drivers
• Bug Fixes:
• Database Conversion: converting boolean true or false values to SQLite not getting generated with proper syntax
• DynamoDB: Tables with dots in the name not supported for certain operations
• Next Tab and Previous Tab options not working correctly on Mac
• If query results column names are rearranged, and column names and results are copied to the clipboard, the column names are not in the correct order

What is new in version 6.3.0:

• Enhancements:
• Added support for the Cassandra database
• Added an Edit -> Delete Lines Containing option
• Salesforce: Added the ability to connect to a Salesforce sandbox environment
• Function Navigator / Function Selector: Now shows both procedures and functions in Oracle PL/SQL packages
• Query Scheduler: Added option to set start time in seconds from current time
• Query Scheduler: Added option to set the title of the query scheduler window
• Query Scheduler: Added option to determine whether to overwrite or append to the output file if it already exists
• Query Scheduler: Added option to load query text from a file
• Query Scheduler: Added option to load query text from the SQL favorites list
• Query Scheduler: Added file name, interval, executions, and query to status field of query scheduler window
• Changes:
• Continue should be the default button on the Add Connection Wizard screen
• Added additional error notifications for the Export tool
• If a maximum rows value is set in the preferences, that value will get set on the JDBC driver's statement object for each query
• Bug Fixes:
• Salesforce: Using TableName.ColumnName syntax in queries returns null values
• Salesforce: Relationship queries using join tables via dot notation columns (example: Contact.Account.Name) returning null values for columns from the joined tables
• Salesforce queries not always returning rows above initial salesforce request limits
• Mac 64-bit: Various focus issues where windows / dialogs are not getting focus when appearing

What is new in version 6.2.6:

• Bug Fixes:
• Connection to Salesforce not working since previous release
• SQL Server / Sybase: Calculated results in select clauses can return 0.0 instead of null

Requirements:

• Java 2 Standard Edition Runtime Environment

Limitations:

• 30 days full trial