RazorSQL 8.2.1 – Manage multiple databases from a single application.

December 4, 2018

RazorSQL allows you to query, update, navigate, and manage all major databases from one database tool. With RazorSQL, a SQL query tool, SQL editor, and database navigator, you can run SQL scripts, visually edit, create, alter, and view tables, import and export data, build queries with a query builder tool, and navigate databases with the database navigator. It even comes with a built-in relational database engine that requires no configuration.

The SQL programming editor has syntax highlighting for SQL, PL/SQL, TransactSQL, SQL PL, and Java, automatic function/method lookup, automatic column lookup, key ahead, built-in and customizable templates, multi-tabular display of query results, query logging, and many other features including a tool to call stored procedures and a tool to compare table and/or query data.

RazorSQL has been tested with virtually all popular databases, and includes built in driver support for Cassandra, DB2, Derby, DynamoDB, Firebird, FrontBase, Hive, HSQLDB, Informix, MongoDB, MySQL, OpenBase, Oracle, PostgreSQL, Redshift, Salesforce, SimpleDB, SQLite, SQL Azure, SQL Anywhere, SQL Server, Sybase, Teradata, and others.

What’s New

Version 8.2.1:

General:

Describe Tool: Added a view definition tab for views
PostgreSQL, MySQL, Oracle, SQL Server: Alter View: Now generates grant statements
Firebird: DDL Generator: Added support for generating identities
HSQLDB: DDL Generator: Added support for generating identities
SQL Server and Sybase: If a procedure is executed that does not return results, but returns output, display the output in the query results
Salesforce: Added support for updating and inserting boolean values for CheckBoxes, etc.
Linux: Added a new shell script launcher to Linux for nonreparenting window managers
PostgreSQL: Updated JDBC driver
Linux: increased resolution of desktop / application menu icons
Export Tool: Redesigned export tool file selection flow
MonetDB Database Browser: Changed to use system queries to get tables, views, and functions instead of using driver calls
Changing the SQL editor font causes other text areas such as the preview pane on the import tool to use the changed editor font instead of the default font
PostgreSQL 10: If a schema is empty, tables may still be displayed in database browser
Editor right-click menu not displaying
Export Tool: Loading from Saved Profile: Wrap quotes box selection always set to true