RazorSQL, A database query tool, SQL editor, and database browser.Updated by rs1104 on Thursday, December 4, 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 :
December 4, 2014
Upgraded SSH library - supports more ciphers and fixed bugswith connecting to SSH over non-standard portsChanged settings for how RazorSQL sets statement fetch size for DB2 ODBC driversSalesforce: includes query syntax throwing a parsing error
Add Reload option to right-click menu on sql editor tab for reloading the current fileFTP Window needs to remember its sizeDynamoDB query bug introduced with previous versionCommand Line Interface does not work with DynamoDB
Added Amazon Redshift supportEnable viewing of raise output in NetezzaAdded support for Apache Derby 10.11Export Tool: If halt on export is unchecked, all export files / data not getting writtenSave to FTP menu option not workingCassandra: Can't always handle concurrent requests.Changing the decimal separator in query results preference ignoredfor SQL Server and Sybase
See full release history
Export Tool: Added an option to not halt on errors when exporting multiple tablesAdded UCanAccess JDBC driver supportAllow user to change the location of the built in databaseCommand Line Interface all to pass all information to connect to the databaseon the command lineExample:java -Xms64M -Xmx1200M -jar razorsql.jar -export "jdbc:mysql://192.168.1.11:3307/sample?noDatetimeStringSync=true|com.mysql.jdbc.Driver|/Users/user/Library/RazorSQL/mysql/mysql-connector-java-5.0.8-bin.jar|testuser|testpass" "select * from department" csv "/Users/user/Desktop/export.txt" NO NO NO "DEFAULT" "DEFAULT"Upgraded internal database from HSQLDB 1.8 to HSQLDB 2.3Database conversion: When converting from a database with default upper caseto a database with default lower case or vice versa, no longer wrap generatedcolumn names in quotes if they are not in the default casePostgreSQL function names not displaying in the database browserfor certain PostgreSQL databasesDynamoDB: Errors occur if attributes are not present near the beginningof the table, but do have values later in the tableQuery scheduler does not work with SalesforceGenerate SQL from query results with table name witha space not generating correct SQLSalesforce - unable to query Case table due to SQL syntax errorDatabase Conversion: Boolean types getting converted to Oracle failing on insert
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: