RazorSQL 8.2.1

Description

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
PostgreSQL:
  • Database Browser: Added user-defined types under the Types node
  • Database Browser: Added a Generate Table Grants option for tables and views
  • Describe Table/View Tool: Added a Grants tab
MySQL:
  • Database Browser: Added a Generate Table Grants option for tables and views
  • Describe Table/View Tool: Added a Grants tab
Oracle:
  • Database Browser: Added a Generate Table Grants option for tables and views
  • Describe Table/View Tool: Added a Grants tab
MS SQL Server:
  • Database Browser: Added a Generate Table Grants option for tables and views
  • Describe Table/View Tool: Added a Grants tab

Screenshots

Advertisement