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.
RazorSQL - Query, Edit, Browse, and Manage Databases. RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, macOS, Mac OS X, Linux, and Solaris. RazorSQL has been tested on over 40 databases, can connect to databases via either JDBC or ODBC, and includes support for the following databases. RazorSQL 9.3.0 add to watchlist send us an update. Buy now $ 99.95. 22 screenshots: portable version A portable version of this application is available: Portable RazorSQL runs on. RazorSQL 9.3.0 add to watchlist send us an update. Buy now $ 99.95. 22 screenshots: portable version A portable version of this application is available: Portable RazorSQL runs on.
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 9.0.0:
Razorsql 9 0 0 Apr 15
Enhancements:
Added support for Couchbase
Navigator / Database Browser Filter: Allow comma separated values in the contains and not contains fields
Added a Connections -> New Tab (New Connection) menu option to the Connections main menu and context menu
Added a Connections -> New Tab (Copy Editor) menu option to the Connections main menu and context menu
Added a Connections -> Same Tab (Switch Connection) menu option to the Connections main menu and context menu
Added New Session (New Connection) and New Session (Copy Editor) options to the new button popup
Added support for Derby 10.15 for supported operating systems. NOTE: Linux 32-bit and legacy Mac OS X versions do not support Derby 10.15
Copy Table to Another Database: Added a Generate Alter Table checkbox. If checked foreign keys are attempted to be assigned via alter table statements
Changes:
Razorsql 9 0 0 Apr Calculator
Linux 64-bit: Updated Java Runtime Environment to version 11
macOS (Catalina and Mojave version): Updated Java Runtime Environment to 11.0.5
Windows 32-bit and 64-bit: Updated Java Runtime Environment to 11.0.5
Editor Auto Save. If user closes an unsaved file and auto save is on, still prompt if the user wants to save the file
Export Numeric Formatting Changes:
If exporting query results (SQL, Delimited File, XML, HTML, Text): Formatting used is based on query results preference values for Locale options (primary) and decimal separator (if locale option not set)
If exporting query results (XLS, XLSX): No formatting is used. Locale specific preferences within Excel determine how the cells are formatted
If exporting from table(s): Numeric formatting is based on Number Format locale selected on the export window with the default being no specific formatting
SQL -> Recent Queries menu options: Order is now based on order the statement was executed not just the timestamp when the statement was executed
DynamoDB: Scan Requests with where clauses: For tables that have more rows than the 'Max Results Per Query' value set on the RazorSQL connection profile, RazorSQL will continue to scan the table until either more rows than the Max Results Per Query value are returned, or there are no more rows to scan
MySQL and MariaDB connections, autoReconnect property is now set to true by default
Keep Alive: Default keep alive interval changed from 4 minutes to 2 minutes
Keep Alive Preference: Added an option for 0.5 (30 seconds) to the keep alive interval
Bug Fixes:
MongoDB: macOS notarized version: Not allowing connections over TLS / SSL connections that use SNI such as MongoDB Atlas free tier servers
Mac repeat hold key preference is not on the correct line in preferences
Query Results: Create Table from Results on Current Connection throws an error in certain situations
SQL History: When running large numbers of statements through the editor such as thousands of inserts, SQL History process can get backed up and cause delays when trying to exit RazorSQL
Fedora Linux: Very slow startup time / hangs on startup can occur
Database Conversion Multiple Tables: When converting to MySQL, if the table name is a reserved word, the table name is getting wrapped in double quotes instead of tick marks in the generated SQL
DynamoDB: Generate SQL operations from query results: Where clause not always populated
Version 9.1.4:
Import Tool: Delimited Files: Added support for the following date formats for Date columns in addition to yyyy-MM-dd: MM/dd/yyyy (06/22/2020) M/d/yyyy (6/2/2020) MM/dd/yy (06/02/20) d-MMM-yy (2-Jun-20)
Import Tool: Added support for generating insert statements that have multiple rows of values per one statement to reduce overhead for MySQL, PostgreSQL, SQL Server, Derby, DB2, and Athena
Import Tool: Blank rows in spreadsheets and delimited files are now skipped
Import Tool: XLSX Files: Importing cells with formulas is now supported
Import Tool: Enhanced the process for guessing column types and sizes when creating a table during the import process
Import Tool: If first row of file being imported looks to be column names, the start row of the file will be set to row 2 instead of row 1
Athena Export Tool: Added support for generating SQL statements in multiple rows per one insert statement syntax
Oracle: For new installs, default to showing all schemas instead of non-empty schemas. Empty schemas can be hidden by the Edit - Preferences - Database Browser - Oracle: Hide Empty Schemas in Database Browser checkbox
Oracle Editor: Added more line number detail to Oracle query errors