Softpedia >Linux >Database >Administrative Frontends >RazorSQL >  Changelog

RazorSQL Changelog

What's new in RazorSQL 6.3.16

Jan 3, 2015
  • Bug Fixes:
  • For machines with certain network configurations the process to connect to the database is taking longer than it should
  • Cassandra: List, Map, and Set data types not showing correctly in the database browser or generate DDL tools
  • Salesforce: excludes query syntax throwing parsing error
  • Salesforce: chaining together more than 3 tables in a query throws an SQL parser error
  • Salesforce: Empty values being returned if more than two tables are chained together in SOQL joins

New in RazorSQL 6.3.8 (Jul 3, 2014)

  • Enhancements:
  • Added PostgreSQL materialized view support
  • Added support for creating projects and interacting with projects via a tab on the file system browser
  • Enhanced materialized view options on the database browser for Oracle
  • Added an option to print line numbers when printing via the web browser option
  • Changes:
  • Expansion of materialized view node in database browser now shows view columns
  • Bug Fixes:
  • DynamoDB: All columns not always displaying in select * queries
  • PostgreSQL Database browser not differentiating among overloaded functions

New in RazorSQL 6.3.5 (Apr 30, 2014)

  • Enhancements:
  • Filter Query Results Tool: Added options for matching any column in a row with equals, contains, or in operations
  • Import Tool - If column names included on first line of delimited file or excel spreadsheet, try to populate column number field based on order of column names
  • Command Line Export Tool: Added multi-value insert syntax option for supported databases
  • Command Line Backup Table Tool: Added multi-value insert syntax option
  • Command Line Backup Table Tool: Added included identity column insert option
  • Command Line Backup Schema Tool: Added multi-value insert syntax option
  • Command Line Backup Schema Tool: Added included identity column insert option
  • Changes:
  • Changed process for getting PostgreSQL type information to improve performance
  • No longer display keep-alive errors for SQLite
  • Bug Fixes:
  • Database Browser: Informix tables and views not always getting sorted in the correct order
  • DyanmoDB: Generate DDL tool not generating column types when tables have both hash and range keys
  • DynamoDB inserts against tables with more than one global secondary index throwing errors
  • DynamoDB describe table not showing all global secondary indexes

New in RazorSQL 6.3.4 (Apr 2, 2014)

  • Enhancements:
  • Added H2 database conversion support to and from HSQLDB, MySQL, Oracle, SQLite, MS SQL Server, PostgreSQL, and MS Access
  • Added MonetDB support
  • Changes:
  • When closing RazorSQL with unsaved files, added a cancel option to the Yes/No save dialog
  • New session window no longer required mouse to navigate
  • Changed memory settings on Mac OS X 64-bit version
  • Bug Fixes:
  • DynamoDB select count(*) queries with where clauses - where clauses getting ignored
  • Percent of original size field not showing correct values in zip file viewer

New in RazorSQL 6.3.3 (Feb 26, 2014)

  • Enhancements:
  • DynamoDB: Add global secondary indexes and local secondary indexes to the describe tool
  • DynamoDB: Add global secondary indexes and local secondary indexes color indicator to the database browser
  • DynamoDB: Upgraded to latest AWS libraries
  • Increased launching performance of edit table tool
  • Increased launching performance of alter table tool
  • Changes:
  • Execute Procedure Tool: For Oracle, now supports REF CURSOR as an IN OUT parameter if no value is set for the REF CURSOR as an IN param
  • Bug Fixes:
  • DynamoDB - does not support tables with dashes in the name
  • DynamoDB: tables with global secondary indexes not showing key information
  • DynamoDB: describe tool not showing information for tables with global secondary indexes
  • DynamoDB: Tables with no rows not showing columns in the database browser
  • DyanmoDB: Unpopulated index columns not showing as columns in database browser
  • Read only version does not allow to change databases

New in RazorSQL 6.3.2 (Feb 12, 2014)

  • Enhancements:
  • Added MariaDB support
  • Added the Oracle 12c JDBC drivers
  • Bug Fixes:
  • Dynamodb - Export with generate DDL not working for tables with periods in the name

New in RazorSQL 6.3.1 (Feb 7, 2014)

  • Enhancements:
  • Added close all query results option to right-click menu of query results tab
  • SQLite: Enabled foreign key support by default for new connections
  • SSH Client: Added ability to enter separate passphrase for private key file
  • SSH Tunnel Tool: Added ability to specify a pass phrase for a private key file
  • Added a MariaDB driver option to the MySQL connection type options
  • Ship with MariaDB drivers
  • Bug Fixes:
  • Database Conversion: converting boolean true or false values to SQLite not getting generated with proper syntax
  • DynamoDB: Tables with dots in the name not supported for certain operations
  • Next Tab and Previous Tab options not working correctly on Mac
  • If query results column names are rearranged, and column names and results are copied to the clipboard, the column names are not in the correct order

New in RazorSQL 6.3.0 (Jan 17, 2014)

  • Enhancements:
  • Added support for the Cassandra database
  • Added an Edit -> Delete Lines Containing option
  • Salesforce: Added the ability to connect to a Salesforce sandbox environment
  • Function Navigator / Function Selector: Now shows both procedures and functions in Oracle PL/SQL packages
  • Query Scheduler: Added option to set start time in seconds from current time
  • Query Scheduler: Added option to set the title of the query scheduler window
  • Query Scheduler: Added option to determine whether to overwrite or append to the output file if it already exists
  • Query Scheduler: Added option to load query text from a file
  • Query Scheduler: Added option to load query text from the SQL favorites list
  • Query Scheduler: Added file name, interval, executions, and query to status field of query scheduler window
  • Changes:
  • Continue should be the default button on the Add Connection Wizard screen
  • Added additional error notifications for the Export tool
  • If a maximum rows value is set in the preferences, that value will get set on the JDBC driver's statement object for each query
  • Bug Fixes:
  • Salesforce: Using TableName.ColumnName syntax in queries returns null values
  • Salesforce: Relationship queries using join tables via dot notation columns (example: Contact.Account.Name) returning null values for columns from the joined tables
  • Salesforce queries not always returning rows above initial salesforce request limits
  • Mac 64-bit: Various focus issues where windows / dialogs are not getting focus when appearing

New in RazorSQL 6.2.6 (Dec 11, 2013)

  • Bug Fixes:
  • Connection to Salesforce not working since previous release
  • SQL Server / Sybase: Calculated results in select clauses can return 0.0 instead of null

New in RazorSQL 6.2.5 (Dec 6, 2013)

  • Enhancements:
  • Added Retina Display support for Mac 64-bit version
  • Query Results - added row count display for query results for queries executed without using the fetch all rows option if all rows have been retrieved from the query
  • Changes:
  • Database Browser - added logic to always trim spaces from tables for databases where table are retrieved from the driver as opposed to executing system queries
  • FTP Connection Window - mouse click no longer needed to connect
  • Changed default font on Mac 64-bit versions to enable bold in default Monaco font
  • Bug Fixes:
  • Execute SQL Fetch All Rows option displays extra blank row in the query results after the last row

New in RazorSQL 6.2.4 (Nov 22, 2013)

  • Enhancements:
  • Added auto download and install option for the MS SQL Server driver for SQL Server and SQL Azure
  • Added razorsql_portable.exe to the Windows version for launching a self-contained version of RazorSQL that does not store data outside of its directory structure
  • Changes:
  • Upgraded JRE to version 1.7.0_45 on Windows and Linux versions
  • Upgraded DejuVu Sans Mono fonts to the latest versions
  • Made MS SQL Driver the default driver for SQL Azure
  • Bug Fixes:
  • SQL Server and Sybase - Large numbers being rounded when returned in scientfic notation from the driver

New in RazorSQL 6.2.3 (Oct 25, 2013)

  • Enhancements:
  • Added a fetch all rows button to the query results toolbar and a fetch all rows option to the results menu for fetching any remaining rows not yet retrieved from a database query
  • Added a Connections -> Change Current Database / Schema menu option
  • Changes:
  • Typing enter in query results search field now executes search
  • The escape key was not closing certain dialog windows
  • Certain numbers being converted to scientific notation in MS SQL Server and Sybase are now displayed in decimal
  • Focus in query results menu item no longer sets selection to first cell in results if a cell is already selected
  • Next Word, Previous Word, Select Next Word, Select Previous Word, Delete Word, and Backspace Word menu items / shortcuts no longer considers underscore as word separators
  • Bug Fixes:
  • Informix Generate DDL - create table DDL for int8 columns are getting generated with sizes

New in RazorSQL 6.2.2 (Sep 26, 2013)

  • Changes:
  • Upgraded SQLite JDBC driver version - added support for wal databases
  • Bug Fixes:
  • For certain multi-monitor display configurations, the max window size of RazorSQL is getting set to the primary display maximum resolution
  • SQL -> Execute SQL Output to File option throwing error
  • Derby Network databases - Auto download - both the derby.jar and derbyclient.jar files need included in the driver location field

New in RazorSQL 6.2.1 (Sep 13, 2013)

  • Enhancements:
  • Added XML and HTML as format options in the command line export tool
  • Added Add Query to SQL Favorites option to right-click menu on query results tab
  • Bug Fixes:
  • Errors connecting to Salesforce not giving detailed error information

New in RazorSQL 6.2.0 (Sep 13, 2013)

  • Enhancements:
  • Added support for Salesforce
  • Added support for HSQLDB 2.3
  • Added menu item to query results tab for Copy Results to Clipboard (No Column Names)
  • DB2 LUW: Added ability to specify connection properties when creating a connection
  • Teradata: Added ability to specify connection properties when creating a connection
  • Changes:
  • Editor: Select to Begin of Line, Select to Begin of Paragraph, and Select to Begin of Document options not setting cursor position to the beginning of the selection
  • Upgraded SSH library - new encryption algorithms supported
  • DynamoDB - Backup, export, and generate insert tools no longer include column names and null values in insert statements for columns that have no value in the table
  • Changed behavior of SQL editor when executing queries and the last statement in the editor is missing the statement delimiter
  • Bug Fixes:
  • DynamoDB: Not all tables are being returned in database navigator for databases with large numbers tables

New in RazorSQL 6.1.7 (Aug 7, 2013)

  • Enhancements:
  • Added Show Distinct Values in Column option to the Column Name header of the query results table
  • Added Generate In Clause for Selected Cells option to right-click menu of query results cells and query results tab
  • Database conversion menu now enabled for all database types - non-supported databases can now be converted to either HSQLDB or the Local Database
  • Improved performance of Connect / Add Connection window load time
  • Changes:
  • When clicking on a query results tab, the status component text is updated to display the query time for the query executed on that tab
  • Added column selection mode indicator to editor status panel
  • Bug Fixes:
  • Derby: Edit table tool not working when trying to edit query results and using lowercase table names in the select
  • The Insert Text At Column dialog does not allow you to insert only spaces

New in RazorSQL 6.1.6 (Jul 25, 2013)

  • Changes:
  • Enhanced parameterized query parser to work better with non-select statements such as inserts, updates, and deletes and enhanced parser to work better with operators and special characters
  • Mac OS X 64-bit: Updated included JRE to latest build that contains fixes for certain freezing issues
  • Changed how RazorSQL exits so that it gives open connections a longer time to close before exiting
  • Bug Fixes:
  • Export Tool: SQL Server: date format not working for date column when using the jTDS driver
  • Export Tool: When a custom date format is requested, date columns in formats other than the default are not getting converted
  • Export Tool: Export as Text - inserting a blank line in results in certain situations

New in RazorSQL 6.1.4 (Jul 6, 2013)

  • Enhancements:
  • Added installation of Desktop shortcut to Linux distributions that support it
  • Bug Fixes:
  • DynamoDB: Connections always pointing to default US-East region
  • Mac OS X 64-bit - Upgraded runtime environment that includes fixes for crashing issues on certain machines

New in RazorSQL 6.1.2 (Jul 3, 2013)

  • Enhancements:
  • SQL Azure: Added support for editing triggers and viewing trigger contents
  • Changes:
  • PostgreSQL Database Browser: Automatically expand schemas when expanding the database node
  • Bug Fixes:
  • Mac 64-bit version - Certain keyboard shortcuts using Shift such as next character, previous character, next line, previous line, next paragraph, and previous paragraph are executing twice for each keyboard event instead of once

New in RazorSQL 6.1.0 (Jun 5, 2013)

  • Enhancements:
  • Added support for Amazon DynamoDB
  • Added ability to change look and feel to different color themes
  • PostgreSQL: Added the ability to view output from functions such as RAISE NOTICE statements
  • Database Navigator: Increased speed of initial load for MS Access
  • Added a preference for whether to strip comments from queries
  • Added a View -> Reset Display Sizes to Default option
  • Added an option to reset all preferences to defaults (Edit - Reset Preferences)
  • Changes:
  • Changed behavior of when a new tab is created and when the current tab is loaded when opening files
  • Query Builder: if percent symbols not entered by the user for LIKE and NOT LIKE operators, value is automatically wrapped in percent symbols by RazorSQL
  • Increased frequency of how often SQL history is written to disk
  • SQL Server: Stop filtering db_owner schema from database browser
  • Updated PostgreSQL JDBC driver that ships with RazorSQL
  • Updated Jsch SFTP library to the latest version
  • Max Rows per Query for SimpleDB and DynamoDB is now a required field when adding a connection profile

New in RazorSQL 6.0.7 (Apr 5, 2013)

  • Enhancements:
  • PostgreSQL Backup and Export Table tools - Now generate create sequence statements prior to the create table statements if a column references a sequence
  • PostgreSQL Backup and Export tools - added option for whether to include serial columns in generated insert statements
  • Added ability to view print output for Sybase SQL Anywhere and Sybase IQ
  • Auto-detect certain statement separators for the Import from SQL file and Execute SQL script processes
  • Changes:
  • Made database name a required field when creating new PostgreSQL connections
  • Bugs:
  • PostgreSQL Export / Backup Tools - Not generating DDL for serial columns correctly
  • Edit Table Tool - When text has line breaks, text is getting formatted incorrectly in popup window
  • Using keyboard shortcut with Shift on Mac causes action to occur twice in some instances

New in RazorSQL 6.0.6 (Mar 23, 2013)

  • Enhancements:
  • MS SQL Server - Added a backup database tool
  • Added a Execute All Statements - Fetch All Rows option
  • Added Informix PAM authentication support
  • Added a preference for whether to display the Executing window during query execution
  • Added an executable to launch RazorSQL in read-only mode on Windows
  • Added options for launching RazorSQL with graphics acceleration turned off for Windows and Mac.
  • Changes:
  • Remember the Match Case setting on Find / Replace in Files
  • Bugs:
  • MySQL Database Browser: Users without show databases permission not getting a categorized list of databases
  • Installation missing the SQL Server ASP bridge file
  • Edit Table tool - when columns with null values are part of the table key for updates or deletes, SQL syntax getting generated as = null instead of is null

New in RazorSQL 6.0.4 (Feb 26, 2013)

  • Enhancements:
  • Added create schema tools for H2, HSQLDB, Derby, and PostgreSQL
  • Command Line Tool: Added an option to specify an import file start row on the import command
  • Command Line Tool: Added a fetch size override parameter to the export command
  • Added a schema selection dropdown to the main toolbar for H2 database connections
  • Changes:
  • Updated included PostgreSQL JDBC driver to the latest version
  • For SQL Server and Sybase, multiple result sets can now be automatically displayed without using the "Fetch All Rows" execution option if the first result set returned contains fewer than the "fetch size" number of rows
  • Updated graphics runtime environment for Windows, Mac, and Linux versions
  • Bugs:
  • Try to export more than 65536 rows in XLS format, hangs
  • Using very large fonts in the navigator causes letters to get cut off
  • HSQLDB: Explain plan not working for newer versions of HSQLDB
  • Fix for potential stability issues for certain Mac OS X 64-bit machines

New in RazorSQL 6.0.3 (Jan 31, 2013)

  • Changes:
  • Edit table tool cells now adjust margins with font size increases
  • Sybase IQ - default result set holdability changed to forward only
  • Bugs:
  • Convert query results to local database, if a local schema name is entered, results conversion throwing error

New in RazorSQL 6.0.2 (Jan 18, 2013)

  • Enhancements:
  • Added ability to connect via private key file for SSH tunnels
  • Added ability to connect via private key files for the SFTP client
  • Included MySQL sample database in templates
  • Added ability to add connection properties to Sybase JConnect driver
  • Import tool tries to automatically recognize if the first row of the import file contains column names and sets the value for the first row field accordingly
  • Changes:
  • Database Navigator: Enabled the edit option on the database navigator context menu for views
  • Database Navigator: Changed the query used to get Sybase databases
  • Execute SQL Script - If query is empty, do not attempt to execute it
  • When selecting from template, put cursor position back at the beginning of the insert
  • More help error message for Sybase optimizer errors when in read uncommitted mode
  • Bugs:
  • Firebird: Smart commit option not working correctly
  • Oracle CLOB Editor - requiring table case to be upper-case in order for clob editing to work
  • FTP / SFTP Client - List of FTP sites does not scroll or get bigger
  • Oracle Database Conversion via ODBC driver throwing errors when data type is of type decimal
  • Database Converter: MYSQL bit data type throws error during conversion
  • Database Converter: MS Access to PostgreSQL conversions using double instead of float8
  • Database Converter - Tables and columns with spaces in insert statements not getting formatted correctly when converting from databases with different formatting rules
  • MySQL generate index ddl and index show info not always factoring in the table the index is assoicated with. Causes problems when a database has multiple indexes with the same name

New in RazorSQL 6.0.1 (Dec 6, 2012)

  • Enhancements:
  • Import Tool: Add ability to save import settings for reusable import operations
  • Export Tool: Add ability to save export settings for reusable export operations
  • Export Tool: Add an option to open the exported file after the export is complete
  • SQL Editor: Add a "Open file after complete" option to the Execute SQL -> Output to file option
  • Connection Wizard: Give ability to add Oracle connection properties
  • Command Line Export: Give option to pass in database password override on the command line interface for the import, export, execute, backup table, and backup commands
  • General: Added keyboard shortcuts and options to the Window menu for moving between query results tabs
  • Changes:
  • Netezza - Limit open cursors to one per connection
  • Change colors for edited, inserted, and deleted rows on edit table tool so they are no so bright
  • Bugs:
  • SQL Editor: Auto-complete not working for certain multi-table joins
  • SQL Editor: Code -> Line Comment option not generating correct comment syntax when connected to MySQL
  • SQL Editor: Text - To Upper and To Lower - if null is highlighted everything gets capitalized instead of just null
  • Sybase: Sybase - when using aliases in a stored procedure that executes a select statement, the query results are displaying the actual column names and not the aliases
  • SQL Server edit function tool changing create to alter in certain situations when it should not be
  • Title on create table from results window not correct
  • Radio buttons on create table from results not mutually exclusive
  • FTP download/upload progress not shown correctly when transferring large amounts of data
  • Query Results: Generate SQL Updates - if multiple tables with the same name across schemas / databases, sometimes clauses get duplicated in generated SQL

New in RazorSQL 6.0.0 (Oct 11, 2012)

  • Enhancements:
  • Database Conversion: Added database conversion tools for converting the following types of databases: HSQLDB, MS Access, MS SQL Server, MySQL, Oracle, PostgreSQL, SQLite
  • Database Conversion: Added the ability to convert tables from the following database types to the RazorSQL local database: DB2, Derby, Informix, MongoDB, MS Access, MS SQL Server, MySQL, Oracle, PostgreSQL, SimpleDB, SQLite, Sybase
  • Database Conversion: Added Copy to Local Database option for copying tables from remote dbs to the local RazorSQL database
  • Added a Create Table from Results Option for creating a table from query results
  • Added a Create Local Table from Results for creating a local table from query results on a remote database
  • Added a Create Table from Results option for converting the query results to a table on another database
  • Added Query Referenced Table option to query results for foreign key columns
  • Add ability to view images - open an image file and display it
  • Added Search -> Goto Column option for the SQL editor
  • Added option to not include column names in output for Execute SQL - output to file
  • Added Insert - Insert from File option to the Inserts menu
  • For parameterized queries, add option for automatically wrapping character data in single quotes
  • Added an option for viewing a status log for each connection that includes queries executed, query times, and rows returned
  • Added 10 to Fetch Limit Rows option
  • Added Editor Backups option to the preferences for backing up files on save
  • Added binary data editing and image viewing with the SQLite JDBC Driver
  • Added support for binary data editing to the RazorSQL SQLite Driver
  • Ship with SQLite JDBC driver
  • SQLite - Auto expand navigator to show Tables, Views, etc.
  • Allow to change auto commit on the toolbar
  • Add SSH tunnel support for MongoDB
  • Added SQL favorites selector shortcut
  • Added a timeout for how long results / statements will stay open and added a preference for it
  • Added support for Derby 10.9
  • Add full screen mode on OS X Lion and Mountain Lion
  • Better auto-completion support for certain join types
  • Added a 64-bit only RazorSQL download for Windows
  • Better memory handling for SimpleDB queries with large result sets
  • Added Consolas as a fixed-width font
  • Recognize reserved words in generated SQL, including database specific reserved words
  • Added additional information to error messages displayed when queries or statements thrown an error
  • Changes:
  • Database Browser: Change firebird query for retrieving sequences
  • Sybase: make sure result sets are always read-only
  • Query log, don't store queries in memory, store them in a file
  • SQL history, just log to file, on exit, trim the file down to the size requested by the user
  • Import Tool: Handle importing date columns from Excel to Oracle
  • Import Tool: Handle importing timestamps from Excel to Oracle
  • Import Tool: Delimited File Import - Now accepts the following date formats for Oracle: MM/DD/YYYY YYYY-MM-DD
  • Remove Execute Batch option for SimpleDB since it is not currently supported
  • Make View JSON for row and Edit JSON for row windows for MongoDB resizable
  • Can now recognize more often when an Access table has a primary key
  • Create Table Tool: Changed sytnax when creating an MS Access table that has a primary key
  • For the SQLite JDBC driver, when there is a syntax error, the error message is not helpful
  • Access: Generate DDL Not generating Primary key even if it is defined
  • Upgrade version of SQLite shipping with RazorSQL
  • Added transaction isolation setting to the create connection profile process
  • Changed default transaction isolation to read uncommitted for DB2, MS SQL Server, and Sybase
  • When editing table results or query results, when the cell in table is clicked on for editing, the font used is not the font set on the table
  • Don't ship with any Derby drivers. Don't pre-select any versions. Add all Derby drivers to the auto-download option
  • Change RazorSQL local data storage directory location on Mac and Windows to align with standards for each OS
  • Update JRE to version 1.7 for the Windows versions
  • View row in column mode is now resizable
  • Added more tips of the day
  • Increase max memory on Mac and 32-bit Windows versions
  • Bugs:
  • PHP Classes syntax highlighting issue
  • HttpUtil: Need to also set httpsProxyHost and httpsProxyPort
  • SQL Server - Tools like Copy Table, etc. that take build catalog, schemas, tables selection box only include schemas from the currently selected database
  • PostgreSQL: Backup tools - Not pulling in PostgreSQL catalog to information schema queries causing RazorSQL to go to the driver to get type information
  • MongoDB: Clicking the Edit option on the database navigator on the non-default database throws an error
  • Mysql: Data getting converted to Hex that should not be:
  • Oracle FLOAT data type size getting generated as 0 in the generate DDL tool
  • When checking for identity in Export tool, sometimes throwing error
  • SQL Server rename column - if column name or table name has spaces, should not be wrapping in quotes
  • When doing an auto-complete / auto-lookup in HSQLDB, MySQL, and Derby, not factoring in the Schema
  • Trim Spaces option being ignored on the command line export client
  • MySQL, H2, HSQLDB - If multiple tables with the same name in various databases / schemas clicking to edit the table in the query results may throw an error
  • If you drag columns around in the query view window and do an edit, the generated SQL references the incorrect columns
  • Connect to a database, hit the connect button, click on the Add Connection Profile tab, click continue, can't put cursor in any of the fields

New in RazorSQL 5.6.4 (Jul 17, 2012)

  • Enhancements:
  • Added support for Mac retina displays
  • Added support for MongoDB slaveOK command
  • Changes:
  • Added Gatekeeper signing for Mac OS X Lion
  • Updated H2 driver
  • Bugs:
  • Auto-complete shortcut not working in certain situations
  • Amazon SimpleDB: Some unicode characters not accepted via SQL insert and update statements

New in RazorSQL 5.6.3 (Jan 4, 2012)

  • Enhancements:
  • RazorSQL can now read configuration files such as connection profiles from a central location on launch
  • Added a preference for whether to highlight SQL statements on execute
  • Added a preference for whether to warn when update / delete statements with no where clause are executed
  • Changes:
  • SQL Editor: If only one statement is present, do not highlight the statement on execute

New in RazorSQL 5.6.2 (Dec 6, 2011)

  • Enhancements:
  • Added an SSH tunnel option to the add connection profile process.
  • Added the ability to specify a file that includes a query to execute for the command line export tool
  • Added support for Sybase functions for the Sybase database browser
  • Added an option to specify a custom delimiter in the command line export tool
  • Added an option to specify characters at the end of each row for the delimited file option of the export tool
  • Enhanced the linux launch script
  • Changes:
  • SimpleDB Export Tool: when generating insert statements or XML files, if an attribute does not exist for a given item, do not list the attribute in the column list and do not include null for the value in the value list of the insert statement
  • SimpleDB Export Tool: If the domain has attributes that are not attached to one of the first 100 items, but are attached to a later item, those attributes are not getting included in the export. Changed this behavior for the insert, xml, and Excel export options
  • SimpleDB: If no proxy information is entered, RazorSQL will now use the system proxy information by default when connecting to SimpleDB
  • SimpleDB: When loading query results, dynamically update the results to include any attributes that were not tied to items in the first 100 rows
  • Auto Complete: If there is nothing to complete, bring up a table list
  • Added keywords to the SQL syntax highlighting file
  • The binary data editor is no longer enabled on join queries. It is only supported on queries against single tables
  • The view as image option is now available for join query results on certain databases
  • Bug Fixes:
  • Informix auto complete is not trimming table names

New in RazorSQL 5.6.1 (Oct 31, 2011)

  • Changes:
  • Command Line Export with insert statement option - escape quotes now defaults to on
  • Bug Fixes:
  • SQL Server export query results with unfetched rows sometimes inserting N at the end of data
  • Load time decrease due to class loading error between version 5.5.5 and 5.6.0

New in RazorSQL 5.6.0 (Oct 19, 2011)

  • Enhancements:
  • Added support for MongoDB
  • Add the ability to connect via proxy servers for Amazon SimpleDB connections
  • HSQLDB: added support for switching schemas to the toolbar
  • Derby: added support for switching schemas to the toolbar
  • Add option to display the query text before results for Execute SQL - output to text options
  • Added a preference for setting the decimal separator on query results
  • Changes:
  • Autocomplete / auto lookup - column names now wrapped in quotes when necessary
  • Increase default max row count for SimpleDB to 5000
  • Export to Excel, set the cell type and format based on the type of the column
  • Import from Excel, if the cell value is a date, format it as a JDBC date
  • Bug Fixes:
  • Executing statements with statement delimiters in comments throwing an error due to parser not factoring in comments
  • Command line generator: wrap locations that have spaces in quotes
  • Alter table in MySQL with a connection without a database selected, throwing no database selected error

New in RazorSQL 5.5.3 (Jul 14, 2011)

  • Enhancements:
  • SQL Editor: Parameterized query input window now gives option to save the parameter value for the session
  • Added a Clear Saved Query Parameters option to the SQL menu
  • Bug Fixes:
  • SimpleDB Database Navigator: The view contents option for domains with dots or dashes fails
  • SimpleDB: insert syntax for inserting into domains with dots or dashes not accepting tick marks around domain
  • SimpleDB: database navigator only showing up to 100 domains
  • SimpleDB: generate select statement option is including itemName() in the select when it should not be

New in RazorSQL 5.5.0 (Apr 14, 2011)

  • Enhancements:
  • Added support for SQL Azure
  • Added support for showing rows as they become available with the Execute SQL Fetch All Rows option
  • Added the following HTML wizard tools: button, check box, file select, form, image, link, ordered list, radio button, select box, table, text area, text input, unordered list
  • Added page down button to query results toolbar
  • Added support for writing unicode characters in the export to excel option
  • Added options to only generate DDL to the backup database/schema, backup table, and command line backup and backup table tools
  • Added character encoding dropdown box for MySQL JDBC
  • Automatically include set identity insert on and off calls for MS SQL Server for tables in the backup and export tools that are exported / backed up and identity columns are included
  • Added Execute Editor Contents as One Statement option to the SQL menu
  • Added a fully qualify object name option to the Generate DDL tool
  • Added support for displaying output for postgresql vaccuum command when used with the verbose option
  • Added text to html converter
  • Added open and sidekick tabs to the file system browser
  • Added javascript templates
  • Added php templates
  • Added javascript inserts
  • Added the following options to the context menu of the editor tabs: close all except current, rename, move, copy file path, size, get info, and sort tabs
  • Added ability to change the results header column font
  • Added support for not including PostgreSQL serial columns in edit table tool generated inserts
  • Added auto completion for alter, drop, and truncate table commands
  • Added Window menu option for moving focus to query results
  • Added Window menu option for moving focus to the editor
  • Added a sort columns button to the describe tool
  • Added preference for whether to show query results rows as they become available
  • Added Support for HyperSQL / HSQLDB 2.1
  • Support page on RazorSQL performance tuning
  • Changes:
  • Changed the method for getting PostgreSQL trigger definitions
  • Oracle - implemented work-around for connection errors throwing a Locale Not Recognized error
  • Import tool: when importing from a file of SQL statements, and an error occurs, display the entire statement that errored in the error log
  • Foreign key columns are now sorted by name on the describe tool
  • Copy SQL Server identity table, column lists and identity insert ON/OFF now generated
  • Raise the max lines on a file RazorSQL will check on the import tool to get sizes, etc.
  • Changed the method to get MySQL procedure and function contents
  • Keywords as columns and table names not getting wrapped in quotes
  • Default ssl=request onto the end of jtds urls for SQL Server
  • Running a use query should not be returning a query tab
  • Updated download URLS for drivers that do not ship with RazorSQL
  • Bug Fixes:
  • MySQL Bridge create table for certain versions of MySQL not launching
  • MySQL Generate DDL (Manual) tool not displaying default values in create table statements
  • MS SQL Server Generate DDL tool not displaying default values correctly when the default values is non-numeric
  • Command line call generator, Show Column Names and Convert Nulls are backwards in the generated command
  • Edit button is active on query results for certain types of join queries when it should not be
  • SQLite - Throwing can't get result set meta data error on certain join sytnax queries with no results
  • If turn keep alive off, next time open preferences it still shows 4
  • Auto completion not working in certain situations
  • Generate DDL Tool - PostgreSQL serial column default value clauses missing ending paren
  • PostgreSQL backup tools, not including database in the DDL queries causing issues when determining serial columns
  • Query Results: hitting page down, after next batch of rows are retrieved, cursor goes back up to the top
  • MySQL: Viewing procedure columns in a procedure outside of the current database is causing the current database to be switched
  • For some databases, procedure parameters of type OUT are being displayed as RETURN
  • MySQL procedures / functions with escaped single quotes - all single quotes not being escaped
  • If using the GO statement separator, and GO is part of an object name, query is not parsed correctly
  • Database browser edit menu option for functions and procedures inside of Oracle packages not working correctly
  • Line breaks are not showing up as spaces in the query tooltip on the query results tab
  • PostgreSQL PHP bridge not functioning
  • Amazon SimpleDB - throwing error when querying domains with unicode characters
  • Select into throwing no result error for Sybase IQ
  • Import tool, if lines end with the delimiter, not able to get column names from the file
  • Import tool does not work for table names with spaces on MySQL bridge
  • Import tool: when importing from a file of SQL statements, and there are errors, the statement number is not getting incremented correctly in the error log
  • PostgreSQL function parameters not always displaying correctly in the database browser
  • PostgreSQL edit function and view function contents options not always displaying correct argument lists and return types

New in RazorSQL 5.4.0 (Feb 10, 2011)

  • Enhancements:
  • Added support for Amazon SimpleDB
  • Added SimpleDB domain data editor
  • Added SimpleDB Add, Edit, and Delete Attributes tools
  • Added SimpleDB Backup database and domain tools
  • Added SimpleDB Import Tool
  • Added SimpleDB Export Tool
  • Added SimpleDB Create and Delete Domain Tools
  • Added support for writing SQL select, insert, update, and delete statements against SimpleDB
  • Added an SQL parser tool that will parse an SQL statement and display syntax errors
  • Added Apache Derby 10.7 driver to the auto download process
  • SQL Editor: Added a word wrap option via the preferences
  • SQL Editor: Added a word wrap guide option via the preferences
  • FTP / SFTP: Added a create new site button to the save to ftp menu options
  • Compare Tool: Added the ability to compare ordered or unordered data when comparing tables
  • Compare Tool: Added row counts for each compared object in addition to differences
  • Help: Added database specific help links to the help menu
  • Changes:
  • SQL Anywhere and Sybase IQ procedure editor - changed to retrieve procedure text from the source column instead of definition column if available
  • SQL Anywhere and Sybase IQ alter view - changed to retrieve view text from the source column instead of the definition column if available
  • SQL Anywhere and Sybase IQ - changed procedure editor to use alter sytnax instead of drop / create
  • JDBC escape processing is now defaulted to false on all connections
  • Added JDBC escape processing preference
  • HSQLDB / HyperSQL: If no user is entered, SA is defaulted
  • SQLite: Check for existence of SQLite database file before connection when user specifies connect to existing database
  • SQLite: Default database creation to the user's home directory if not path is provided in the create database option
  • SQLite: Added a check to see if SQLite database is writable by RazorSQL
  • When GO or something similar is used as the statement delimiter, put a space before the GO when generating SQL statements via the query results or when saving edits from query results
  • Oracle Database Browser: Added a hint to the query to get schemas
  • Remember the location of the "Executing . . ." box that displays when a query is running
  • Derby: When adding a Derby connection profile, require user to select which Derby version they want to use
  • Added failover query if no MySQL procedure or function results are returned
  • Added query to get MySQL parameter columns from information schema for MySQL 5.5 or greater
  • Bug Fixes:
  • Unable to connect to Derby 10.7
  • MySQL procedure and function columns not displaying in the database navigator when browsing databases other than the one specified in the initial connection
  • MySQL procedure and function columns not displaying in procedure editor and view content tool when using the MySQL PHP bridge
  • Derby - for certain versions, generate ddl generating invalid DDL for identity columns
  • DDL Generator: When a table has multiple primary keys with spaces / special chars in the column names, the primary key clause is not getting generated correctly.
  • Alter Table Tool: When altering a table and adding multiple columns with spaces / special chars as a primary key, the primary key clause is not getting generated correctly
  • Not defaulting current schema in HSQLDB / HyperSQL 2.0 and newer
  • First site created is not displaying in save/open to ftp dropdown

New in RazorSQL 5.3.0 (Dec 21, 2010)

  • Enhancements:
  • Added SFTP / FTP client available in the tools menu
  • Added Open from SFTP / FTP option available in the File menu
  • Added Save to SFTP / FTP option available in the File menu
  • Added Bookmark found lines option to Find / Replace tool
  • Added row count option to right-click menu of database navigator
  • Added an option to trim leading / trailing spaces to export tool and command line export
  • Added date and timestamp formatting options to the Export tool
  • Added Generate SQL Inserts option to command line export tool
  • Added date and timestamp formatting options to command line export tool
  • Changes:
  • Added catalog / schema to Generate DDL alter table foreign key clause (DB2, MySQL, MS SQL Server, Oracle, PostgreSQL) when catalog / schema is different than the catalog/schema of the table
  • Automatically strip unnecessary semi-colons from more types of queries when user highlights ending semi-colon for databases that don't support ending semi-colons
  • Increased max memory to 512MB (Windows and Mac)
  • SQL Anywhere, default first column type in create table tool is pre-selecting as bigint instead of int
  • Increased scrollbar scroll increment on compare tool
  • Bug Fixes:
  • Command line documentation not correct for -execute option
  • Drop table tool not working for databases that do not have schemas or catalogs
  • PostgreSQL create table tool and other tools showing extra column types other than the standard types
  • Create table tool not removing size column value for new SQL Server 2008 date column types
  • Query results formatting not working on SQL Anywhere timestamp and datetime columns
  • Milliseconds not getting formatted correctly in certain situations for custom timestamp query results formatting
  • MS SQL Server: Generate Table DDL not generating identity info if table is not in same database as current database

New in RazorSQL 5.2.5 (Oct 27, 2010)

  • Enhancements:
  • Added Execute SQL - Output to File options for one statement and execute all statement options
  • Added reconnect option to reconnect to the disconnected connection for a tab
  • SQL Editor: Added Column Selection Mode option (Edit - Column Selection Mode)
  • Added connect, disconnect, and reconnect options to tabbed pane context menu
  • Added XMLHttpRequest object to JavaScript code builder
  • Changes:
  • Upgraded PostgreSQL JDBC driver
  • Execute Script tool no longer requires statement separators to be contained in the script.
  • Hitting shift end with selected text now keeps text selection accordingly
  • Hitting shift home with selected text now keeps text selection accordingly
  • Bug Fixes:
  • Error thrown when trying to connect via the RazorSQL JDBC bridge using versions 5.2.3 and 5.2.4
  • When there are multiple result sets for one query, copying the results to clipboard / editor does not work on the extra result sets
  • Copy Table tool not executing SQL correctly if statement separator is not default
  • JavaScript code builder not showing methods for DOM objects
  • JavaScript auto method lookup does not work if equals assignment does not have spaces
  • If javascript var does not start with "var", auto lookup doesn't work

New in RazorSQL 5.2.4 (Oct 13, 2010)

  • Enhancements:
  • Added Table Relationships tool
  • Performance improvements for exporting tables and backing up databases and tables
  • Performance improvements when using the Execute - Fetch All Rows option
  • Added JavaScript compressor
  • Added JavaScript validator
  • Added standard C library function lookup to Objective-C
  • Added standard c library autocompletion to Objective-C
  • Added auto signature display on ( for Objective-C for standard c libraries
  • Added C-style bracket event closures to Objective-C
  • Show in Browser option now prompts for which browser to launch such as Firefox, Safari, Opera, Chrome, and Internet Explorer
  • Changes:
  • The Show in Browser option for HTML files now only creates temp files if the currently active tab has not been saved to the file system and is not modified
  • Bug Fixes:
  • MS SQL Server export of a query executed with fetch all option errors when using ODBC driver
  • SQL Anywhere database browser showing duplicate owners in some instances
  • XML Validator does not show line number of error when validating against a file on the file system

New in RazorSQL 5.2.2 (Sep 17, 2010)

  • Enhancements:
  • Added support for Sybase IQ
  • Added support for the DELIMITER command for changing SQL statement delimiters
  • Add close all except current option to right-click menu of query results
  • Display current sql statement delimiter on editor status panel
  • Added Edit -> Text -> Insert International Chars option
  • Added Edit -> Text -> Remove White Space option
  • Added Edit -> Text -> Remove Lines Containing option
  • Added Edit -> Text -> Remove Lines Starting With option
  • Bug Fixes:
  • Single and double quote keys not working on certain international keyboard layouts
  • HTML Entities tool not working
  • Auto column lookup not determining table correctly for certain join situations

New in RazorSQL 5.2.1 (Aug 27, 2010)

  • Enhancements:
  • Added a connect at startup option for connection profiles to automatically connect when RazorSQL launches
  • Added -profile command line option to automatically connect RazorSQL to a profile on startup
  • Changes:
  • Window sizing adjustments
  • Bug Fixes:
  • Preferences window not displaying on certain Mac versions
  • Drop multiple tables option showing empty initial dialog for databases that don't support catalogs or schemas

New in RazorSQL 5.2.0 (Aug 25, 2010)

  • Enhancements:
  • Added DB Tools - Execute SQL Script option
  • Added smart commit mode. Executes commits after statements until a non-select statement is executed
  • Added preference for specifying query results date format
  • Added preference for specifying query results timestamp format
  • Added Tools - Execute Ant Build for integration with Ant
  • Add backup option to the command line tool for backing up databases / schemas from the command line
  • Add execute option to the command line tool for executing files of SQL statements from the command line
  • Added backup table option to the command line tool for backuping up tables from the command line
  • Add unicode support for SQLite on Windows
  • Added Command Line Call Generator tool for generating RazorSQL command line options
  • Added preference for whether or not to sort table columns in database browser
  • Added context menu item for sorting and unsorting table columns in database browser
  • Added jump to compiler error line number option on Java compiler
  • Added jump to compiler error ling number option on Mac Objective-C compiler
  • Added table columns option to database object search tool for most databases
  • View menu items can now be configured as custom keyboard shortcuts
  • SQL Server import tool - added option for turning IDENTITY_INSERT to ON before doing the import
  • Added option to Oracle thin driver for adding multiple hosts / ports for RAC connections
  • Changes:
  • Allow use of "max" keyword for column lengths when creating tables
  • Made HTML link help system more responsive to mouse clicks
  • Bug Fixes:
  • Selecting into temp table throws error for SQL Server
  • Selecting into variable my throw error in MySQL
  • Generate DDL Tool: SQL Server 2005 and 2008 varbinary, varchar, and nvarchar columns with a column length of max displaying -1 for the column size
  • Database Object Search: Search right-click menu option in the search results window not working
  • Schemas not displaying for some SQL Anwyhere versions

New in RazorSQL 5.1.6 (Jul 6, 2010)

  • Enhancements:
  • Added a binary data / BLOB editor
  • Changes:
  • Query Results: Column names sometimes displayed in header even if column aliases were used.
  • Updated auto download to grab latest JTOpen driver
  • Oracle blobs now show as (BLOB) in query results
  • RazorSQL now launches in 64-bit mode by default on 64-bit Macs
  • Interbase tables have trailing spaces in auto table lookup
  • Interbase queries using aliases now show aliases in the column header
  • Bug Fixes:
  • Selects using table aliases not handled correctly in edit table tool and cell editor
  • SQL Server: varbinary(max) columns get generated as varbinary(-1) in DDL tools

New in RazorSQL 5.1.5 (Jun 9, 2010)

  • Enhancements:
  • Added a create table option to the import tool
  • Added a delete all rows option to the generate SQL menu
  • Added ability to sort multiple columns to the sort query results tool
  • Added a charset selection dropdown to the MySQL create table tool
  • Updated HSQLDB JDBC drivers
  • Updated Derby JDBC drivers
  • Added auto-install JDBC driver option for HSQLDB 2.0 JDBC drivers
  • Added auto-install JDBC driver option for Derby 10.1, 10.2, 10.3, 10.4, and 10.6 JDBC drivers
  • Added connection type options for JDBC type 4 and type 2 for DB2 on z/OS to the connection wizard process
  • Added an AJAX example template
  • Added AJAX inserts to the HTML inserts tool
  • Updated Windows JRE
  • Updated Linux JRE
  • Changes:
  • Changed Interbase database browser to use system queries to get tables, views and system tables
  • Bug Fixes:
  • Generate SQL delete option does not end statements with statement separators

New in RazorSQL 5.1.4 (May 23, 2010)

  • Enhancements:
  • SQLite performance improvements
  • Performance improvements for the Execute SQL - All Statements option
  • Added support for easier setup for HSQLDB and Apache Derby database connections for drivers not included with RazorSQL

New in RazorSQL 5.1.3 (May 18, 2010)

  • Enhancements:
  • SQL Editor: Auto completion enhancements
  • Oracle Database Browser: Added right-click menu option for viewing table and column comments
  • Import Tool: Save last start and width values for a specific table for fixed width file imports
  • Changes:
  • Added low screen resolution support for database browser menus
  • Added additional pl/sql file extension recognition
  • Launching improvements
  • Added himem files for launching RazorSQL with increased memory settings
  • Bug Fixes:
  • Blurry icon problem on Windows 7
  • Generate DDL tool not generating enum values for MySQL
  • Generate DDL tool not generating MySQL auto increment

New in RazorSQL 5.1.2 (Apr 15, 2010)

  • Enhancements:
  • Editor: Added auto detection for UTF 8 and UTF 16 files
  • Editor: Added progress bar and ability to cancel Find in Files and Find / Replace in Files tools
  • Results: Make view query option syntax highlighted
  • Upgraded Informix JDBC driver
  • Upgraded H2 JDBC driver used via the auto download process
  • Added binary translation flag to JTOpen connections
  • Editor: Added methods and anonymous functions to the JavaScript function / method navigator
  • Editor: Clicking on a line number highlights the entire line
  • General: Added ability to change the editor caret color
  • Editor: Enabled support of $ and ^ regular expression symbols for the Find and Find / Replace tools
  • Changes:
  • Added validation to ensure Windows domain is entered when using Windows authentication with SQL Server
  • Bug Fixes:
  • Generate DDL Tool: Create table not always putting non-numeric default values in the correct format
  • Column names with spaces not getting wrapped in quotes for edit table cells and results generate SQL tools
  • SQL Server edit procedure tool sometimes converting "create" to "alter" inside of procedure
  • Python syntax highlighting errors with certain text
  • When syntax highlighting is off, keywords are always showing as black, even when custom colors are set

New in RazorSQL 5.1.1 (Feb 26, 2010)

  • Enhancements:
  • Added option to choose file encoding to the Export Tool
  • Added option to choose file encoding to the Backup Tools
  • Added option to choose file encoding to the Import Tool
  • Added charSet configuration property for PostgreSQL JDBC driver
  • Added charset configuration property for SQL Server jtds driver
  • Added named pipe configuration property for SQL Server jtds driver
  • Upgraded Oracle JDBC drivers to 10.2.0.4
  • Upgraded jTDS JDBC drivers to 1.2.5
  • Added backup options to editor right-click DB Tools menu
  • Add exec as an SQL keyword
  • Right-click on a line number in the editor now adds or removes a bookmark
  • Added smart comment (control or comment /)
  • Add Undo Chunk to right-click menu on editor
  • Add bookmarks menu to the right-click menu on editor
  • Print using browser enhancements for better translation of font size, bolds, and italics
  • Added Run on Local Web Server options to the PHP, Perl, Python, and Ruby tools menus
  • Added Java util for wrap selection in If
  • Added Java util for wrap selection in Else
  • Changes:
  • File, Edit, and Inserts menu now have better support for lower resolutions
  • View Open Editors option now makes sure it is visible on screen if resolutions were changed
  • Validate the execute program processes to make sure the program actually exists
  • Change scroll buffer value so that auto window scrolling does not start until cursor is closer to end of the window
  • Uncomment option now takes into account all selected lines when uncommenting line comments
  • All Text menu tools now perform their functions on selected text only if there is text selected
  • Better handling of line break conversions when transferring files from Mac to Windows and vice-versa
  • Better adherence to default operating system line break formatting rules
  • Made the CSS and HTML validator results windows resizable
  • Bug Fixes:
  • Certain Results menu options getting disabled on certain types of queries when they should not be
  • Sybase Database Browser not showing tables, views, or system tables when using certain roles
  • Right-click on File System Browser text field not showing popup menu on Mac
  • Shift down not highlighting line when the line is the last line in the editor
  • Word Count character count option not factoring in multi-character line breaks for windows
  • Editor status bar selected text length not factoring in multi-character line breaks for windows

New in RazorSQL 5.1.0 (Feb 16, 2010)

  • Enhancements:
  • Added Backup Database / Schema option (DB Tools -> Backup Schema or Database)
  • Added Backup Table (DB Tools -> Backup Table)
  • Table Editor: Added better support for editing text with tabs and line breaks
  • Table Editor: Added a right-click menu to the data cells
  • Query Results Editor: Added support for editing text with tabs and line breaks
  • Export Tool: Allow user to specify SQL statement separator for the generated SQL
  • Export Tool: Multiple Tables Option now has checkboxes for selecting / deselecting tables, views, and system tables
  • Export Tool: The SQL export option how has a Generate DDL option for generating Create and Alter table statements for the exported tables
  • Export Tool: The XML export option now has an option to escape XML special characters
  • Import Tool: Import from SQL file now allows user to select the SQL statement separator
  • SQLite Database Browser: Increased performance for table column information display
  • SQL Editor: PostgreSQL stored function editor now uses the create or replace syntax
  • SQL Editor: Firebird procedure editor now uses the create or alter syntax
  • Generate DDL Tool: Added the option to select the SQL statement separator in the generated DDL
  • Generate DDL Tool: Added a fully qualify object names option
  • Generate DDL Tool: MySQL engine information is now generated for Create Table statements
  • Generate DDL Tool: MySQL char set information is now generated for Create Table statements
  • SQL Editor: Added Undo Chunk option
  • SQL Editor: Added more options to editor right-click menu
  • SQL Editor: Added error codes to error messages when the codes are available
  • View Procedure / Function / Trigger contents window is now resizable and remembers size and location
  • Describe Tool: Enhanced the foreign key tab
  • SQL Editor: Find / Replace window now remembers last location
  • Help: Added support articles and common support questions to the Help menu
  • Change Fixes:
  • PostgreSQL Database Browser: Changed logic to retrieve available schemas
  • Informix Generate DDL Tool: A default value is always getting set in Create Table DDL when using the ODBC driver
  • SQL Server Generate DDL Tool: procedures are now generated as Create instead of Alter
  • Generate DDL Tool: Objects with spaces or special chars are now wrapped in quotes
  • File, Edit, and Inserts menus now have better support for lower resolutions
  • Import Tool: Generate output file browse button option does not have an option for typing in the file name
  • Export Tool: Increased the scroll speed on the multiple tables selection window
  • Bug Fixes:A
  • Execute Procedure Tool: If there is a date out parameter, a validation message about entering a valid date is being thrown
  • Execute All Option: Reloading database navigator during execution when create or alter statements are found
  • Generate DDL Tool: Schemas box values not getting updated when database box changes value
  • Generaet DDL Tool: If no tables, views, or indexes are found, no DDL is being displayed
  • Table Editor: Line breaks are removed when editing cells with line breaks when not using the "Edit in New Window" option

New in RazorSQL 5.0.6 (Jan 22, 2010)

  • Enhancements:
  • SQL Editor: For Mac, added more emacs key bindings (control k, control d, and control y)
  • SQL Editor: Added Code - Utils - HTML Entity Selector option
  • Bug Fixes:
  • Auto Column Lookup: Column names sometimes duplicated
  • SQLite Database Browser: Not all column names showing for tables in certain situations

New in RazorSQL 4.5.15 (Aug 25, 2009)

  • Bug Fixes:
  • MySQL views not showing in database navigator

New in RazorSQL 4.5.11 (Jun 25, 2009)

  • Enhancements:
  • Added InterSystems Cache database support
  • Added FileMaker support
  • Added characterEncoding and useUnicode properties to MySQL connection properties screen
  • Added SQLite 3.6.15 precompiled binary to Linux distribution
  • Changes:
  • Updated built-in Apache Derby JDBC drivers to version 10.5
  • Upgraded Linux JRE to 1.6.0_14
  • Upgraded Windows JRE to 1.6.0_14
  • Upgraded SQLite in Windows version to 3.6.15
  • Removed Mckoi and PointBase from the main database connection list
  • Bug Fixes:
  • Oracle Trigger contents not always able to be retrieved
  • SQLite: not displaying tables that have numeric / decimal columns with scale values correctly
  • SQLite: occasional communication errors between RazorSQL and SQLite

New in RazorSQL 4.5.10 (Jun 5, 2009)

  • Enhancements:
  • Added View - View Open Editors component
  • Added View as HTML in Browser option to the Edit - Text menu
  • Bug Fixes:
  • Right-click Copy not working correctly in query results
  • Format of query results copying not always correct

New in RazorSQL 4.5.9 (Jun 3, 2009)

  • Enhancements:
  • Bookmarks positions are now saved by default on exit
  • Added Search -> Bookmark Selector tool
  • Bug Fixes:
  • Alter View - no semi-colon after drop view and create view
  • SQLite Alter View - only showing last line of view in alter statement
  • Sybase alter view not working correctly with Sybase JConnect JDBC driver
  • Sybase generate DDL on views not working with Sybase JConnect JDBC driver
  • Oracle alter view not working correctly
  • Oracle generate DDL on views not working
  • File System Browser: Delete option not working on Windows
  • Text menu in editor popup menu does not have any values
  • Firebird and Interbase Alter Table Tool - drop column generates incorrect syntax.
  • Query scheduler only remembers first line of a query

New in RazorSQL 4.5.8 (May 20, 2009)

  • Enhancements:
  • DB2 Database Browser enhancements
  • Enhanced support for DB2 on iSeries, AS400, System I
  • Added a preference for Maximum rows to retrieve for a query
  • Added one click connection option to database browser
  • Changes:
  • Font anti-aliasing now defaulted to on in SQL editor for all systems
  • Bug Fixes:
  • Oracle auto completion / auto column lookup - values not being returned for lower case table names
  • Export Query Results - Export as Insert Statement option not activated for certain select * query formats
  • Edit Table Button - Not always being activated when it should be for certain formatted queries
  • Export Tool not always wrapping text values with single quotes when it should be for export as SQL insert statements option

New in RazorSQL 4.5.7 (May 13, 2009)

  • Sped up load time
  • Enhanced Oracle OCI support
  • Allow Oracle Connect As option for all Oracle JDBC connections, not just built-in connections
  • Query scheduler - remembers last information entered
  • Auto populate Oracle OCI driver location if OCI client library is found
  • Changes
  • Updated keep alive queries for several databases
  • Attempt to reconnect dead connections needs to explicity call close on the original connection
  • Put a limit on the number of times reconnecting dead connections
  • Removed JDBC driver already loaded warning message
  • Bug Fixes
  • Query Scheduler - missing line break after first line in output
  • Copy results and columns to clipboard fetches more rows when the entire query results have not been retrieved

New in RazorSQL 4.5.6 (Apr 24, 2009)

  • Enhancements
  • Add ability to change the SQL statement delimiter / termination character via the preferences window
  • Add ability to make a direct ODBC connection to Microsoft Access without setting up an ODBC datasource
  • Bug Fixes
  • SQL Server - not all schemas are being shown in the navigator with certain configurations
  • On save confirmation window, if close window by not using cancel button when prompted to save changes, treats it as a No response
  • Import Tool - When entering specific import file column values that are not all inclusive, if the table column count is greater than the delmited file column count, values not getting picked up correctly.
  • Oracle Generate DDL - generating a 0 size for a number field in some cases

New in RazorSQL 4.5.1 (Feb 19, 2009)

  • This release adds enhancements to the edit table tool and the import tool.
  • Performance enhancements to the database browser, especially for Oracle and SQL Server, are included.
  • Several minor bugfixes have been made.

New in RazorSQL 4.5.0 (Jan 6, 2009)

  • A DDL Generation tool for all major databases was added.
  • The data import and export tools were enhanced.
  • A table and view search tool was added.
  • Auto SQL statement generation was added for tables and views.