RazorSQL, A database query tool, SQL editor, and database browser.Updated by rs1104 on Thursday, July 3, 2014.
RazorSQL is a SQL database query tool, SQL editor, database browser, and administration tool with support for all major databases and built in connection capabilities for DB2, Derby, Firebird, FrontBase, HSQLDB, Informix, Microsoft SQL Server, MySQL, OpenBase, Oracle, PostgreSQL, SimpleDB, SQL Anywhere, SQLite, SQL Azure, and Sybase. Any other JDBC or ODBC (Windows only) compliant database is also supported. RazorSQL ships with a built in relational database engine that is up and running out of the box and requires no end user administration. Some of the main features contained in RazorSQL are visual tools for creating, editing, describing, altering, dropping, and viewing database objects; tools for importing and exporting data; a database browser for the viewing of database objects and structures; and a robust programming editor with support for SQL, PL/SQL, TransactSQL, SQL PL, PHP, Java, XML, HTML, and twelve other programming languages. Also included are a query builder, tools for creating, editing, and executing stored procedures, triggers, and functions, a tool to compare table data and/or query results, and SQL history.
Platforms: Linux, Mac OS X, Solaris, Windows
Latest releases :
July 3, 2014
Added PostgreSQL materialized view supportAdded support for creating projects and interacting with projectsvia a tab on the file system browserEnhanced materialized view options on the database browser for OracleAdded an option to print line numbers when printing via the web browser optionExpansion of materialized view node in database browser now shows view columnsDynamoDB: All columns not always displaying in select * queriesPostgreSQL Database browser not differentiating among overloaded functions
Salesforce: Added copy to local database option for Salesforce tablesAdded Copy File Path option to File System BrowserImport Tool: Create table from import - table names converted to defaultcase for the databaseLimit size of table references window in query builder to prevent windowfrom going off screenIf there is an at sign in table - wrap in quotesDatabase Conversion: Oracle to H2 and H2 to Oracle conversion files missingImport Tool: Create table from SQL inserts - generated column names sometimes have spaces
See full release history
DynamoDB: Added ability to force a query or scan operation using the select_query or select_scansyntax instead of just selectselect_query * from employee where id = 1DynamoDB: Added ability to specify an index to use for a query operation using a query hintselect_query /*index_name*/ * from table_name where . . .DynamoDB: Enhanced logic to determine when to execute a query request and when to execute a scanrequest when query or scan is not indicated in select queryDynamoDB: added support for in clauses in SQL statementsDynamoDB: Import Tool: Added a checkbox for skipping columns / attributes in generatedinserts when the value is null / emptyAdded ability to set connection properties when using the MS SQL Server JDBC driver from MicrosoftDynamoDB: support beginning comments in queriesDynamoDB: A non-descriptive error is thrown when referencing an attribute in an SQLstatement that does not exist in the tableIf SQL Server jtds connection fails for SSL reasons, and MS SQL Server driver is installed,try connecting with the SQL Server driverChanged the formatting of the query error text to handle line wrapping betterFaster scroll speed on Explain Plan windowIf result columns are moved and put back in the same place - results editor throws errorpreventing changes due to columns being re-arrangedPostgreSQL: editing views taking a long time in certain situationsQuery Builder: add table button window appearing behind the query builder on MacQuery results edit table button not always appearing for supported queries when the querieshave comments in them
Latest News and Reviews :Wordpress VS JoomlaLibreOffice VS OpenOfficeBest Linux Distro 2012Best Linux Server 2012Diablo 3 on LinuxBest Wordpress plugins
- Author / maintainer:
- Richardson Software, LLC
- Web site:
- Alternate download: