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, Firebird, FrontBase, HSQLDB, Informix, MongoDB, MySQL, OpenBase, Oracle, PostgreSQL, SimpleDB, SQLite, SQL Azure, SQL Anywhere, SQL Server, Sybase, and Teradata.
What’s New
Version 8.0.0:
- BigQuery: Added support for Google BigQuery databases
- KDB+: Added support for the kdb+ database
- MongoDB: Added support for connecting using SSL encryption
- Redshift: Added support for entering AWS IAM credentials when connecting using the Redshift driver
- Redshift: Added support for new Amazon Redshift drivers
- Cassandra: Added a Create Keyspace / Create Schema tool
- Cassandra: Included additional drivers in install
- Firebird: Added ability to convert Firebird tables to the following database types: Access, DB2, H2, HSQLDB, MySQL, Oracle, PostgreSQL, SQLite, and SQL Server
- Added ability to adjust max rows per query setting to toolbar
- Added an auto-backup process for connection profiles
- Updated graphics runtime environments for Windows, Mac, and Linux
- Upgraded MongoDB drivers to version 3.6
- Upgraded MariaDB JDBC driver to version 2.2.3
- Upgraded UCanAccess driver to version 4.0.4
- Upgraded Redshift jdbc driver that gets installed via the auto-install process
- Database Conversion: Empty but not null binary values are converted to null in database conversion inserts
- Objects with a colon in the name now get automatically wrapped in generated SQL
- Salesforce: Max number of rows returned not matching up with max results setting in certain situations
- Ingres Generate DDL: column names not being returned in index DDL
- Ingres Execute Procedure Tool: If procedure has not nullable OUT params, OUT params not getting populated in call response
- PostgreSQL / Redshift: If view definition is not in information_schema, need to query pg_catalog to get view definition
- MySQL via Amazon RDS: MariaDB driver. After running a query that produces a syntax error, subsequent queries fail
- MS SQL Server: Importing unicode characters into nvarchar or nchar fields not prepending generated inserts with N' syntax
- Salesforce: Max Results Per Query value getting ignored
- MS Access Database Conversion: Date conversion from some databases getting length specific in create table statement for date fields
- Firebird: Compound foreign keys not getting generated property in Generate DDL tool
- Database Conversion: Conversion to Oracle timestamps including a size in the create table statements
- Windows: Trying to delete a file via the File -> Open dialog causes RazorSQL to hang
Compatibility
OS X 10.7 or later, 64-bit processor
Screenshots
Download Now
