Softpedia >Mac >Developer Tools >RazorSQL >  Changelog

RazorSQL Changelog

What's new in RazorSQL 10.5.4

Apr 9, 2024
  • Changes:
  • Export: Improved XLSX export performance
  • Mac: Native file dialogs now use dark mode if the machine is in dark mode
  • SQL -> Recent Queries (All Connections) and Recent Queries (This Connection) now display queries in order of the most recent query executed
  • Connections -> View SQL History: Changed ordering on query to get history text to prevent truncation of history data
  • Status Log: Queries that error during execution are now logged to the status log
  • SSH Tunnel: A warning is displayed if multiple connection profiles use the same local port for an SSH tunnel
  • Bug Fixes:
  • Execute SQL - Output to File: Statements that do not return a result may cause an error to be thrown

New in RazorSQL 10.5.3 (Jan 26, 2024)

  • Changes:
  • Database Conversion: When converting to MySQL or MariaDB, generated inserts can now be generated as insert, insert ignore, or replace
  • Oracle: Updated JDBC driver to 23.3
  • Bug Fixes:
  • Connection Profiles Screen: Driver Location field not showing up correctly for some database types

New in RazorSQL 10.5.2 (Jan 11, 2024)

  • Changes:
  • Added support for Salesforce Data Cloud

New in RazorSQL 10.5.1 (Dec 14, 2023)

  • Changes:
  • Added support for Access 2019 to Mac/Linux and Windows UCanAccess connections
  • Upgraded UCanAccess driver to version 5.0.1
  • Upgraded included HSQLDB database to version 2.5.1
  • Bug Fixes:
  • Save password button missing from Databricks Add Connection window
  • Add Connection Process: Configure connection property window is sometimes too big for the screen

New in RazorSQL 10.5.0 (Dec 3, 2023)

  • Enhancements:
  • Added support for Databricks
  • AWS Athena: Added support for the SAML browser plugin connection property
  • JDBC Driver Location selection: Automatically search the target folder for other .jar files and present them for selection in multiple jar files located
  • Bug Fixes:
  • RazorSQL may not start correctly if the file system browser panel is adjusted in certain ways

New in RazorSQL 10.4.7 (Nov 14, 2023)

  • Bug Fixes:
  • Alter Table Tool: Add Column screen Length / Precision field not appearing correctly for some databases
  • Auto Column Lookup: Tables with spaces in the name not handled correctly with auto column lookup

New in RazorSQL 10.4.6 (Oct 17, 2023)

  • Enhancements:
  • SQLite JDBC: Added the ability to pass properties via the JDBC URL using the following syntax: jdbc:sqlite:db?prop1=value1&prop2=value2 . . .
  • Changes:
  • SQLite JDBC: Gave the ability to load extensions via the following JDBC URL property: enable_load_extension=true
  • msyqli PHP bridge PHP file is now compatible with PHP 8
  • Bug Fixes:
  • If Strip comments preference is selected, queries with comments embedded inside a line are not always parsed correctly
  • License code validation slow on some machines
  • Oracle: ending semi-colon not getting stripped from alter session statements when using semi-colon as the delimiter

New in RazorSQL 10.4.5 (Sep 13, 2023)

  • Enhancements:
  • Command Line Export: Added the ability to export in text format
  • DB2 JTOpen Driver: Added the ability to set the naming property to support system or sql naming
  • Changes:
  • Firebird: BLOB SUBTYPE TEXT columns are no longer treated as binary data
  • Firebird Database Conversion: BLOB SUBTYPE TEXT columns now get converted to character data

New in RazorSQL 10.4.4 (Jul 19, 2023)

  • Changes:
  • Query Results Delete Row: Window size is sometimes too large
  • Database Conversion: Added MariaDB as a supported type
  • Bug Fixes:
  • Database Conversion: Databases of the same type appearing in the Execute on Connection list
  • If upgrading an old version of RazorSQL that uses the Windows Legacy UI, an error occurs on launch
  • Keep Alive reconnect closed connections: Database browser not always working correctly after reconnection
  • DB Tools -> Generate DDL: Generating table and view DDL for databases that support catalogs and schemas was not including the schema name in generated DDL if no schema was selected.

New in RazorSQL 10.4.3 (Jun 7, 2023)

  • Bug Fixes:
  • RazorSQL Legacy User Interface menus stopped working in version 10.4

New in RazorSQL 10.4.2 (May 28, 2023)

  • Enhancements:
  • Snowflake: Added support for switching databases to the toolbar
  • Bug Fixes:
  • Snowflake: Query errors when using certain Snowflake JDBC drivers with Java version 17

New in RazorSQL 10.4.1 (May 26, 2023)

  • Bug Fixes:
  • AWS Redshift connections with the Redshift JDBC driver failing on certain machines

New in RazorSQL 10.4.0 (May 10, 2023)

  • Changes:
  • Added support for Derby 10.16 for systems supporting JRE 17
  • Import Tool: Execute as Batch option added back in when executing a file of SQL statements. Was removed erroneously for Postgres, MySQL, Athena, and SQL Server
  • Updated included JRE to version 17.0.7 for systems that support it
  • Bug Fixes:
  • Results Generate Update Statements: Columns with null values causing issues with update generation

New in RazorSQL 10.3.3 (Apr 26, 2023)

  • Enhancements:
  • Upgraded SFTP / SSH library: More algorithms now supported and more private key file formats now supported
  • Added an entry for English (No Commas) to the locale specific number formatting drop-downs in the query results preferences and in the export tool
  • Changes:
  • Updated PostgreSQL JDBC driver to version 42.6
  • SQL Generation: Columns with pound sign in the name get wrapped in quotes automatically
  • Query Results: Changed key mappings for Home, End, Control / Command Home, and Control / Command End to be the following: Home: Go to first cell of current row End: Go to last cell of current row Control / Command Home: Go to first cell of results Control / Command End: Go to last cell of results
  • General: Changed the modality of certain dialogs to prevent blocking
  • Bug Fixes:
  • Command Line: Convert Table: convert table option throwing an error
  • Query Result next tab / previous tab shortcut does not work if going past first tab or past last tab

New in RazorSQL 10.3.2 (Mar 21, 2023)

  • Enhancements:
  • Firebird: Windows: Added the ability to connect directly to Firebird 4 database files without a running server
  • Firebird: Windows: Added the ability to download and install the Firebird 4 embedded client when adding a new connection
  • Added a copy results to editor option for Show Found on Find window
  • Added a copy results to editor option for Find / Replace in Open Editors
  • Changes:
  • Firebird: Updated the new dataabase creation process when creating a new Firebird 4 database
  • SQL Editor: When connecting to a connection profile with an Associate File attached to it, no longer opens a new tab if associate file is already open and unsaved
  • Export: If wrap all values in escape characters is set to true, if column names are included they also get wrapped

New in RazorSQL 10.3.1 (Feb 23, 2023)

  • Enhancements:
  • Command Line Tool: Added a Wrap All Values in Double Quotes option to the Export command
  • Added option to copy result column names (only names) to clipboard to Results menu and query results tab right-click menu
  • Added a reconnect all option to the Connections menu
  • Changes:
  • Windows: If screen is maximized when RazorSQL is closed, RazorSQL will open in a maximized state on the next launch and remember the previous un-maximized size
  • Mac: If in full screen mode on close, RazorSQL will open using the dimensions of the window prior to entering full screen mode
  • Bug Fixes:
  • SQL Editor: Oracle: Ending semi-colon not always getting stripped when appropriate
  • MySQL: SQL generation tools are wrapping BIGINT and TINYINT column type values in single quotes
  • SQL Server Copy Table: Database names not getting wrapped in quotes when necessary when copying tables with identity columns

New in RazorSQL 10.3.0 (Jan 25, 2023)

  • Enhancements:
  • Added support for the following SQL Server / Azure authentication types when using the 11.x SQL Server JDBC Driver:
  • Active Directory Interactive - Multi Factor Authentication
  • Active Directory Service Principal
  • Windows Authentication from another domain
  • Added support for DB2 type 4 driver when connecting to Informix
  • Changes:
  • SQL Server / Azure: Added the MS SQL Server 11.2 JDBC Driver
  • Informix: When executing select into statements against Informix when using the DB2 driver, empty error messages are no longer displayed
  • Bug Fixes:
  • Reconnect process: Reconnect process may throw an error in certain situations

New in RazorSQL 10.2.0 (Dec 7, 2022)

  • Enhancements:
  • RazorSQL Built-in Database Engine: Improved performance for large tables and reduced memory consumption
  • Teradata: Added support for additional authentication options
  • Query Results: Added a selected rows value on the status bar
  • Changes:
  • Query execution time for the original query stays in the status window even after fetching more rows from the result set
  • Database Browser: Streamlined drop and truncate table and drop view GUI flow
  • Updated Teradata driver to version 17
  • Bug Fixes:
  • Create table from results: Changing column name in the create table section may result in error
  • SimpleDB: itemName() column not getting generated correctly via the Generate SQL tools

New in RazorSQL 10.1.1 (Dec 7, 2022)

  • Enhancements:
  • Added support for H2 version 2
  • New H2 Connections: Will auto detect H2 database version and set driver accordingly
  • SQL Query Builder: Added the following join types: Left Outer, Right Outer, and Full Outer
  • Changes:
  • Save choose encoding should default to the file encoding preference
  • Bug Fixes:
  • Query Results: Delete Row: If result set has remaining rows that have not been fetched, delete row throws an error

New in RazorSQL 10.1.0 (Oct 20, 2022)

  • Enhancements:
  • Added support for CockroachDB
  • Added support for HSQLDB 2.7
  • Added support for the allowLocalInFile MariaDB connection property and the allowLoadLocalInFile MySQL connection property
  • Changes:
  • When selecting the JDBC option for databases that have installed drivers, pre-populate the driver class and driver location options
  • Bug Fixes:
  • Connection Wizard: Connection properties not getting set correctly when using MariaDB driver with a MySQL database type
  • SQL Server Drop Index: Table name not always getting populated when dropping an index from a custom schema

New in RazorSQL 10.0.9 (Oct 4, 2022)

  • Enhancements:
  • Database Browser: Added a View Data Dictionary option to the right-click menu for the following database types: Oracle, MySQL, MariaDB, SQL Server, and PostgreSQL
  • Changes:
  • Salesforce: Support all lowercase for SOQL join syntax for column names
  • Bug Fixes:
  • SQL Server Edit Table Tool: Identity columns not recognized correctly when database name has certain characters

New in RazorSQL 10.0.8 (Oct 4, 2022)

  • Enhancements:
  • Query Results -> Find All Rows Containing Value: A new result set is now created and the original result set is preserved
  • SQL Server: When using the Microsoft SQL Server driver, error line numbers are attempted to be displayed in error messages
  • Changes:
  • Oracle: Added additional syntax highlighting keywords
  • Workaround for error messages not displaying properly on certain external monitors
  • Update for cursor placement issue when using multiple monitors with different scaling factors
  • Updated MS SQL Server JDBC driver
  • Mac / Linux: MS SQL Server JDBC driver is now the default driver instead of jTDS

New in RazorSQL 10.0.7 (Aug 3, 2022)

  • Changes:
  • Create Table from Query Results: Improved performance
  • Salesforce: Added support for the format function
  • Vertica: Updated included Vertica driver to version 12
  • Bug Fixes:
  • Edit Table Tool: SQL Server Identity columns not getting recognized correctly for tables not in the default schema
  • Shift Selection Right menu mnemonic also used by Preferences menu item
  • Create Table from Query Results: Queries with aggregate functions throw errors in certain situations

New in RazorSQL 10.0.6 (Jul 13, 2022)

  • Enhancements:
  • Command Line Call Generator: Windows: Give the ability to generate a .bat file with the command embedded in it Mac / Linux: Give the ability to generate a .sh file with the command embedded in it
  • Command Line Call Generator: On Windows systems added a Schedule Command button that has options for creating a task in the Windows Task Scheduler
  • Bug Fixes:
  • Command Line Call Generator: Multi-line syntax section not appearing in certain situations
  • Windows: When scaling above 100%, clicking the mouse may put the cursor position left or right of the mouse pointer location on the screen when using certain font sizes

New in RazorSQL 10.0.5 (Jun 23, 2022)

  • Enhancements:
  • Filter Query Results now opens a new query results tab with the filtered results and original results are no longer overwritten
  • Added the ability to search on keyboard shortcuts when assigning shortcuts via the Preferences -> Keyboard Shortcuts tab
  • Query Results: Added the ability to drag column names to the SQL editor
  • Changes:
  • Database Browser: When the system navigator is used to populate the database browser, the database type is included in the top level name of the browser
  • Bug Fixes:
  • Code -> Inserts -> Insert Selector throws error when editor syntax type is set to T/SQL
  • Insert Selector and Describe Table share the same default keyboard shortcut
  • Mac: When find dialog is visible, auto complete returns focus to the find dialog instead of the editor

New in RazorSQL 10.0.4 (Jun 14, 2022)

  • Enhancements:
  • Added support for using the PostgreSQL pgpass file format when authenticating JDBC connections
  • Added support for using a password file (a file containing nothing but the password) when authenticating JDBC connections
  • Database Conversion: When converting to MySQL / MariaDB, added the ability to choose the generated SQL insert type (INSERT, REPLACE, or INSERT IGNORE)
  • Added Test Connection call to DB Tools -> Command Line Call Generator
  • Added Connect call to DB Tools -> Command Line Call Generator
  • Informix: Added the ability to set the DBDATE connection property for setting the date format
  • Changes:
  • SQL Server: DDL Generation: create index statements no longer generated for default primary key indexes when generating table DDL
  • Firebird to PostgreSQL Table Conversion: Double and Float columns now get converted to PostgreSQL double precision columns
  • Salesforce: Comments are stripped from queries automatically
  • Bug Fixes:
  • SQL Server: Alter table add column not supporting entering max for column length
  • Edit Table Tool: If sort query results preference is set to true, causes problems with the edit table tool
  • PostgreSQL: IN_OUT parameters not supported in the call procedure tool
  • Call Procedure Tool: Error messages are not always displaying to the screen

New in RazorSQL 10.0.3 (May 13, 2022)

  • Enhancements:
  • Added the ability to set a client timezone via the Preferences -> Query Results Tab. Note: This setting will not have an effect for drivers that do not use the client machine timezone for date / time display
  • Changes:
  • Windows: Default fixed-width font is Consolas if found (previously Courier New)
  • Windows: Default non-fixed width font is Segoe UI if found (not all components were using Segoe UI)
  • Most unicode characters are now displayable even if the user selects a custom font
  • Bug Fixes:
  • MySQL: Create function tool puts IN keyword in front of parameters
  • File System Browser: Windows / Linux: File names may get cut off
  • File System Browser: Highlight color foreground of date and size labels not matching with the file name label
  • Mac: If dark mode is selected from the view menu, switching the selection to Auto Detect Dark / Light Mode no longer turns auto detection back on
  • Mac: File System Browser: If Auto Detect Dark / Light Mode is on, and Mac is in Light or Gray mode, highlight colors are not correct on the file system browser
  • Lookup / auto complete display list / tooltip text: Font size not always based on the current editor font

New in RazorSQL 10.0.2 (May 2, 2022)

  • Enhancements:
  • Mac: Improved performance of using the arrow keys to select next or previous lines or characters
  • Bug Fixes:
  • Certain windows were not displaying the correct text color in Dark Mode
  • RazorSQL no longer launching on some Windows 7 machines

New in RazorSQL 10.0.1 (Apr 28, 2022)

  • Changes:
  • When moving from a high resolution monitor to a non-high resolution monitor, RazorSQL is no longer automatically maximized unless the previous width and height are greater than the maximum screen resolution on the new monitor
  • When connecting to MS Access via the UCanAccess driver, the Import Tool create new table option now uses INT instead of INTEGER for non-decimal numeric columns that are smaller than BIGINT
  • Better detection of dropped connections when using the UCanAccess driver for MS Access
  • When connecting with the UCanAccess driver, the objects that need wrapped now use [ and ] instead of double-quotes
  • Bug Fixes:
  • Dark Mode: Matching bracket / paren highlight color difficult to see
  • Mac: View menu is not displaying the currently set look and feel selection correctly in some cases
  • When connecting to MS Access via the UCanAccess driver, date fields were being wrapped with single quotes instead of # in the import tool and Generate SQL options

New in RazorSQL 10.0 (Apr 21, 2022)

  • Enhancements:
  • Enhanced the dark mode. Dark mode can be selected via the View -> Dark Mode menu option. Previous dark mode can now be selected via the View -> Legacy Dark Mode menu option.
  • Added a Light Mode look and feel that can be selected via the View -> Light Mode menu option
  • Windows / Linux: Changed the default user interface look and feel. The previous look and feel can be selected via the View -> Legacy UI Mode menu.
  • Mac: Dark mode / Light mode is now detected automatically by default. This setting can be changed in the View menu
  • Syntax Highlighting Colors: Added the ability to set different syntax highlighting colors for dark vs non-dark user interfaces
  • Colors: Added the ability to set different foreground and background colors for dark vs non-dark user interfaces
  • Reduced startup time by approximately 10%
  • Auto Completion / Auto Lookup: Added column data types and sizes to the popup window
  • Windows: Improved user interface scaling on Windows systems that use scaling over 100%
  • Linux: RazorSQL will automatically scale display on some Linux systems
  • Binary Data Editor: Edit area now expands as window gets bigger
  • MySQL copy table to another database. Added option to select INSERT, REPLACE, or INSERT IGNORE insert syntax
  • Changes:
  • Removed some icons from the default toolbar layout. The toolbar layout can be customized via the Edit -> Preferences menu
  • Preferences: Added ability to reset colors to their defaults
  • Removed DejuVu Sans Mono fonts from inside Windows installation
  • Updated mariadb driver to version 3.0.4
  • Updated MySQL driver auto download process to use driver version 8.0.28
  • Auto lookup / auto completion window font now set relative to the size of the editor font
  • Auto lookup / auto completion window location better adjusts to the position of RazorSQL on the screen
  • Bug Fixes:
  • Auto lookup / auto completion window may display offscreen if RazorSQL is partially off the screen
  • Mac: If text size is increased via the view menu, popup menu fonts do not increase

New in RazorSQL 9.5.2 (Mar 3, 2022)

  • Enhancements:
  • Added the ability to search for connection profiles by name
  • Query Builder: Added IN and NOT IN options to the Search tool
  • Changes:
  • Toolbar: Quick Connect Box: Show more visible items on click
  • Upgraded Snowflake driver installed via the auto download process to version 3.13.9
  • Firebird backup: $RDBPRIMARY and $RDBFOREIGN indexes no longer get generated in backup files when backing up a database or table. Foreign and primary keys are generated in the create table statements

New in RazorSQL 9.5.1 (Feb 9, 2022)

  • Enhancements:
  • Added support for SAP Hana
  • Changes:
  • If Display Executing . . . Window During Query Execution setting is un-checked, View Contents and Show Info queries initiated from the database browser no longer show the Executing window
  • Mac: Big Sur and Monterey dialog settings set back to old behavior, to go back to original behavior go to Help -> Set System Property, set Name to D_OWNER and value to NULLWINDOWAT
  • Bug Fixes:
  • FTP / SFTP Transfer: Deadlock can occur when uploading files in certain situations
  • Mac Apple Silicon version: Auto updater not working

New in RazorSQL 9.5.0 (Jan 12, 2022)

  • Changes:
  • Windows 32-bit and 64-bit java runtime upgraded to 11.0.13
  • Linux 64-bit java runtime upgraded to 11.0.13
  • Mac Apple Silicon java runtime upgraded to 11.0.13
  • Firebird: Query Results: If a binary column has character data, RazorSQL will try to show the character data instead of displaying the value in Hex format
  • Removed legacy log4j version 1.2 files from Apache poi.jar file used for reading and writing Excel files. RazorSQL no longer has a reference to any version of log4j. NOTE: RazorSQL has never included log4j 2 - the version affected by the Log4Shell security vulnerability
  • Bug Fixes:
  • Prompt to Save changes when reloading a query results tab with unsaved changes not working correctly
  • Linux: Display issue first time double clicking results cell in query results

New in RazorSQL 9.4.9 (Nov 15, 2021)

  • Enhancements:
  • Athena: Added the following connection properties for authenticating with Azure AD: AwsCredentialsProviderClass, tenant_id, client_secret, client_id
  • Athena: Added the following connection properties for authenticating with ADFS: AwsCredentialsProviderClass, idp_host, idp_port, preferred_role, ssl_insecure
  • Changes:
  • Command Line Import: Delimited file import is now supported for JDBC drivers that do not support batch operations
  • Added support for drivers that have multi release jar files such as SAP Hana
  • Upgraded Athena driver to version 2.0.25

New in RazorSQL 9.4.8 (Oct 7, 2021)

  • Enhancements:
  • Added a Tools -> Base64 Encoder tool
  • Added a Tools -> Base64 Decoder tool
  • Changes:
  • MS SQL Server: When connecting with the jTDS driver, new connections now set the ssl property to "request" by default
  • Upgraded included SQL Server jTDS driver to version 1.3
  • Cassandra: Apache Thrift Driver: Hex values are now displayed for blob types
  • Bug Fixes:
  • Mac: US International keyboards: quote, double quote, and back quote typing behavior is not correct

New in RazorSQL 9.4.7 (Sep 16, 2021)

  • Changes:
  • Command Line Processor: Added a -testConnection command that has two arguments: -testConnection "Connection Profile Name"
  • Removed id as a postgresql reserved word
  • Command Line Process: More error information is now displayed on the console in the event of an error
  • DB2: JTOpen Driver: Added the ability to set connection properties
  • Vertica: Added the ability to set connection properties
  • Bug Fixes:
  • Database Conversion and Query Generation: SQL not always getting generated correctly when the preference wrap generated database objects is set to always

New in RazorSQL 9.4.6 (Aug 17, 2021)

  • Enhancements:
  • Added a Results -> Re-execute Query Every X Seconds menu item and added the menu item to the right-click menu of the query results tab
  • Oracle: Added Enabled DBMS Output and Disable DBMS Output options to the Connections menu
  • Changes:
  • Upgraded Salesforce API to version 52
  • Upgraded Firebird Jaybird JDBC driver to version 4.0.3

New in RazorSQL 9.4.5 (Jul 20, 2021)

  • Changes:
  • Added the ability to set connection properties such as query timeout on BigQuery connections
  • MySQL: Export and Backup tools now escape backslashes in data
  • Athena: New Connections: If the endpoint override property is specified, the AWSRegion should not be set

New in RazorSQL 9.4.4 (Jun 16, 2021)

  • Changes:
  • Upgraded SQLite driver to version 3.34
  • Bug Fixes:
  • SQLite connections do not work on Apple Silicon machines

New in RazorSQL 9.4.3 (Jun 2, 2021)

  • Enhancements:
  • Added the ability to connect directly to Firebird database files (versions 2.0 - 3.0) without a running Firebird server on Windows machines
  • Added the ability to create new Firebird ODS 11.2 (2.5) database files via the Create Database Tool and when adding new Firebird connections
  • Oracle Database Browser: Enabled calling DBMS_METADATA.GET_DDL on indexes under tables
  • Oracle Database Browser: Enabled calling DBMS_METADATA.GET_DDL on constraints under tables
  • Bug Fixes:
  • Cassandra timeuuid column should not have single quotes in generated SQL

New in RazorSQL 9.4.2 (May 12, 2021)

  • Enhancements:
  • Filter Navigator: Top Level Objects. Added a drop-down for Include Selected and Exclude Selected to determine whether to include top level objects in the navigator or exclude them from the navigator
  • Added a Connections - View Status Log menu option. View Status Log can now be assigned a keyboard shortcut
  • Bug Fixes:
  • DB2 to MySQL conversion. DB2 graphic columns getting converted with a G prefix in generated insert statements in certain situations

New in RazorSQL 9.4.1 (May 12, 2021)

  • Enhancements:
  • Added configurable connection property support for Interbase
  • Bug Fixes:
  • ODBC connections throw errors on certain machines due to a missing library

New in RazorSQL 9.4.0 (Apr 26, 2021)

  • Enhancements:
  • Added support for the Intersystems IRIS database
  • Added ability to set connection properties for Informix
  • Added sslConnection as an Informix connection property
  • Query Results: Added a preference in the query results tab for beeping when a query that takes longer than a certain number of seconds completes
  • Bug Fixes:
  • SQL Formatter: Ignore commas in parens does not handle nested parens correctly

New in RazorSQL 9.3.4 (Apr 14, 2021)

  • Enhancements:
  • PostgreSQL: Added additional ssl related connection properties
  • Changes:
  • select into queries now display the number of rows returned in the file in the updated rows section of the status window
  • If query results columns are re-arranged, edit table tool is disabled
  • DynamoDB Edit Table Tool from Query Results: Non select * queries get re-written as select * queries when lauching the edit table tool
  • Bug Fixes:
  • ExecuteAll - execution can hang in certain situations

New in RazorSQL 9.3.3 (Mar 25, 2021)

  • Changes:
  • Salesforce: Added support for date functions in the select clause
  • Salesforce: Added support for case sensitive aliases
  • Users can now enter 0 for the connection level maximum rows value. This will not limit the number of rows returned. Note that this may cause performance problems for some databases
  • Bug Fixes:
  • Input focus leaves text area sometimes when query returns no results

New in RazorSQL 9.3.2 (Mar 1, 2021)

  • Changes:
  • Database Browser: Case is now ignored when sorting tables
  • MongoDB SSL Connections: Now defaults to TLS version 1.2
  • Cassandra SSL Connections: Now defaults to TLS version 1.2
  • Database Conversion: If the new table field contains a period, the new table name is no longer wrapped in quotes in the generated SQL
  • MongoDB: Updated SQL reserved word list
  • Bug Fixes:
  • Sybase / SAP IQ: Alter Table Tool does not generate DDL for rename table or rename column
  • H2 Database Conversion: Auto increment columns cause invalid DEFAULT clause in generated DDL

New in RazorSQL 9.3.1 (Feb 8, 2021)

  • Enhancements:
  • Added a New Tab (Share This Connection) menu option to the right-click menu of the SQL Editor tab
  • Added a Results -> Export Query Results menu option
  • Command line call generator: Added example output for using the commandFile syntax to execute multiple commands per call
  • Changes:
  • Athena: Added the ability to set connection properties on the Simba Athena JDBC driver
  • Upgraded DB2 JDBC driver to version 4.28.11
  • Upgraded PostgreSQL JDBC driver to version 42.2.18
  • Bug Fixes:
  • Cassandra: If using the fetch all rows toolbar button or keyboard shortcut, a not supported error is displayed after all rows are returned
  • Cassandra: Exporting or Backing up a table with a timestamp column throws an error
  • Cassandra Export Multiple Tables: If no keyspace is selected, an error is thrown on the start of the export

New in RazorSQL 9.3.0 (Jan 13, 2021)

  • Enhancements:
  • Query Builder: Added the ability to select the same column multiple times in the query
  • RazorSQL Command Line Process: Added the ability to execute multiple commands per call using the -commandFile "command file path" option. The command file should contain one RazorSQL command line process command per line
  • SQL Editor Tab right-click menu: Added a New Tab -> Share Connection menu item
  • H2 Database Object Search: Added the ability to search for triggers
  • HSQLDB Database Object Search: Added the ability to search for triggers
  • H2 Database Browser: Added support for triggers
  • HSQDLB Database Browser: Added support for triggers
  • Changes:
  • BigQuery Database Browser: If project id entered in the connection does not come back from the driver meta data call, include it in the browser list anyway
  • Updated H2 driver to version 1.4.199
  • H2, HSQLDB, Derby, and SQLite Embedded: When closing a connection, some resources from the connection may not have been eligible for garbage collection
  • Bug Fixes:
  • SQL Editor: Single quotes inside of multi-line comments were not getting ignored when determining statement delimiter positioning

New in RazorSQL 9.2.7 (Dec 13, 2020)

  • Bug Fixes:
  • When pasting data into the editor an extra line break may be inserted at the end

New in RazorSQL 9.2.6 (Dec 11, 2020)

  • Changes:
  • Snowflake Generate DDL: Columns of type variant should not have a size
  • Editor: When pasting data, editor tries to convert data to plain text
  • macOS: Changed bundled JRE to version 11.0.9.1
  • Bug Fixes:
  • macOS: RazorSQL may crash if switching keyboard input

New in RazorSQL 9.2.5 (Nov 25, 2020)

  • Enhancements:
  • Cassandra: Added a timestampFormat connection property. For new connections this defaults to utc. For connections created previously, this defaults to the old behavior of local_date. utc displays timestamps in utc format. Other options are local and local_date. local displays timestamps using the timezone of the local machine as the format. local_date displays timestamps in date format using the timezone of the local machine.
  • Changes:
  • Added the following system property options. If opening new dialog windows on macOS Big Sur is causing issues, do the following:
  • Help - Set System Property
  • Put D_OWNER in the Name
  • Put NULLWINDOWAT in the Value
  • If still issues, put NULLWINDOW in the Value
  • Upgraded MongoDB driver to 3.12.7

New in RazorSQL 9.2.4 (Nov 16, 2020)

  • Changes:
  • macOS version: Upgraded included JRE to 11.0.9
  • Bug Fixes:
  • macOS version: Possible RazorSQL crash when connecting or disconnecting external displays
  • HSQLDB to SQL Server Table Conversion: Converting tables in the HSQLDB PUBLIC schema throws an error

New in RazorSQL 9.2.3 (Nov 10, 2020)

  • Enhancements:
  • Added a File -> Open File (Current Tab) menu option (control / command + shift + o) for replacing the current editor contents with contents from a file
  • File System Browser: Add a Open File (Current Tab) option
  • Toolbar open file icon: Added the ability to open the file in the current tab

New in RazorSQL 9.2.2 (Oct 15, 2020)

  • Enhancements:
  • DynamoDB: Added support for inserting / updating data to columns with a list data type. NOTE: Data must be in a valid JSON format
  • DynamoDB: Added support for the SQL drop table statement
  • Bug Fixes:
  • Salesforce: Values not displaying for queries with aggregrate functions that use aliases for the column name / aggregrate function name

New in RazorSQL 9.2.1 (Oct 7, 2020)

  • Enhancements:
  • Export Tool: Export Delimited Filess: Option to set escape character to something other than double quote
  • Export Tool: Export Delimited Files: Added option to wrap everything in escape character
  • Cassandra 3x DDL Generation: Added support for generating with clustering order by clauses to generated table DDL
  • Changes:
  • Database Conversion: SQL Server to H2 conversion: newid() in default column values is now converted to random_uuid()
  • Bug Fixes:
  • Cassandra 3x DDL Generation: primary key columns may not be in the correct order in primary key clause of create table statement
  • DynamoDB and SimpleDB Import Tool: An error occurs when including column names in the generated import SQL
  • File Selection: When selecting a file from the file system for certain operations, the user is not prompted for whether to overwrite the file when the user selects an existing file

New in RazorSQL 9.2.0 (Sep 17, 2020)

  • Enhancements:
  • Added support for Amazon AWS Keyspaces
  • Cassandra: Added the ability to set the consistency level on the connection when creating a new Cassandra connection. The consistency can be set by clicking the Configure button next to the Conn. Properties field.
  • Added an Edit -> Move to First Visible Line (control / command + page up) menu option for moving the cursor to the first visible line in the editor
  • Added an Edit -> Move to Last Visible Line (control / command + page down) menu option for moving the cursor to the last visible line in the editor
  • Query Results Tab Right-click Menu: Added a Copy Selected Column Names and Results to Clipboard option
  • Results: Added an Arrange Columns in Alphabetical Order option to the Results menu and Results tab right-click menu
  • Results: Added a Goto Column option to the Results menu and Results tab right-click menu
  • Changes:
  • Cassandra: Database Browser now reloads automatically when creating a new table
  • Mac: macOS Big Sur: Display changes to better support Big Sur
  • Selected text is no longer moved when using tab or shift+tab if control/command key is pressed
  • Bug Fixes:
  • Execute All: Execute All no longer stops executing if query type can't be determined. Unknown query type is now used in this case

New in RazorSQL 9.1.6 (Aug 25, 2020)

  • Changes:
  • Cassandra blob columns now display values in hexadecimal format
  • The tab key is now allowed as part of a custom keyboard shortcut
  • Added a system property for turning off the update check. Set UPDATE_CHECK to FALSE in Help -> Set System Property
  • Mac: Changed type of dialog used for certain save operations to prevent freezing issues on certain machines
  • Bug Fixes:
  • Procedure Excecution: Method can't be called twice error displays in certain circumstances
  • Generate SQL Select and Generate SQL In Clause: If columns in results table are rearranged by dragging, SQL generation uses incorrect column names

New in RazorSQL 9.1.5 (Jul 29, 2020)

  • Enhancements:
  • Import Tool: Added ability to change the delimiter / line break escape character to something other than double quote
  • Import Tool: Added option to forego delimiter / line break escaping
  • Added an execute SQL button on generate SQL popup window
  • DynamoDB Database Browser: Changed Row Count option to the following
  • Row Count (Estimate): This method gets the row count from the DynamoDB table meta data. This count is updated by DynamoDB every 6 hours
  • Row Count (Full Scan): This method scans the whole table to get the row count. This method uses more resources to get the count
  • Changes:
  • Execute Procedures: Errors that occur in a procedure are displayed even if the procedure was able to return results prior to the error. Previously the error was not reported
  • Local Database / HSQLDB: create table tool defaults creating tables as cached (on-disk) tables instead of in-memory. Memory tables can be created by selecting the Memory option in the Table Type drop-down
  • Bug Fixes:
  • Import Tool: Create New Table from Data: size and scale drop-downs may be uneditable when they should not be

New in RazorSQL 9.1.4 (Jul 17, 2020)

  • Enhancements:
  • 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
  • Changes:
  • 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

New in RazorSQL 9.1.3 (Jun 18, 2020)

  • Changes:
  • Import Tool: Importing from a saved profile no longer pre-populates the delimited file end row. The last row of the file is assumed by default
  • SQLite: Added a Change File button for quickly changing the SQLite database file on an existing SQLite connection profile
  • Oracle Database Browser: Changed default query to get all schemas
  • Bug Fixes:
  • Database Browser: Folders are duplicated sometimes, especially when using the enter / return key to make the connection from the Connection Wizard window
  • Windows 4k Monitors: Icons on the database browser are too small

New in RazorSQL 9.1.2 (May 28, 2020)

  • Changes:
  • Database Object Search and Database Data Search can now be assigned keyboard shortcuts
  • Bug Fixes:
  • Firebird: Binary Data Editor: Queries against tables in the SQL editor where the table name does not match the case of the table name as stored in the database do not allow the binary data editor to launch
  • DB2 Call Procedure Tool throws error in certain situations
  • Athena Database Browser: Table name is not pre-populated when selecting the drop table option
  • Oracle SQL Editor: describe table statements are not bringing up the describe tool
  • Edit Table Tool: Database name / schema name not always getting wrapped in ticks or quotes when special characters are contained in the name
  • macOs Catalina: Command line interface throwing an error on some machines

New in RazorSQL 9.1.1 (May 5, 2020)

  • Enhancements:
  • Added a Tools -> URL Encoder tool
  • Added a Tools -> URL Decoder tool
  • Database Object Search: View Contents on a column name now scrolls to and selects the first row in that column in the query results
  • Amazon Athena: Added the ability to generate DDL for views
  • Changes:
  • Amazon Athena Database Browser: Object types are now set to Tables and Views. Tables are listed in Tables section and Views are listed in Views section
  • Amazon Athena: Generate Table DDL now uses output from the show create table command
  • Bug Fixes:
  • Athena Database Browser: View Contents -> Limit Results options not working
  • Mac: Two browser tabs display when clicking connection help off of WizardAdd

New in RazorSQL 9.1.0 (Apr 15, 2020)

  • Enhancements:
  • Query Results: Added the ability to sum, average, find mininum, and find maximum for selected cells only in addition to all cells
  • Firebird: Create Database Tool and Add Connection Tool: Added the ability to create Firebird version 4 / ODS version 13 database files
  • File System Browser and Project Browser: Added right-click menu option for Open File Share Connection
  • File System Browsser and Project Browser: If there are active database connections, double-clicking a file prompts for whether to open the file and share a current connection
  • Added support for Yellowbrick
  • Changes:
  • BigQuery Database Browser: Only datasets under a particular project are shown in the project's tree
  • BigQuery Database Browser: SQL generation now includes the project id in the generated SQL
  • Toolbar: Show File System Browser button is now shown on the toolbar by default
  • Linux: Web browser display: If x-www-browser is available, this command is used to open web browsers on Linux systems
  • Bug Fixes:
  • SQL Editor: Tab names can be incorrect if switching tabs in the middle of adding a new connection tab
  • SimpleDB: Inserting or Updating records that have SQL keywords with tick marks does not remove tick marks from keywords prior to sending to SimpleDB

New in RazorSQL 9.0.9 (Mar 18, 2020)

  • Enhancements:
  • PostgreSQL: Added information to error messages about statement line number and approximate editor line number of errors
  • Changes:
  • JavaScript Validator: Leading line feeds in text can cause an issue with the validator
  • Snowflake to Local Database Conversion: Number data type conversion is now supported
  • Salesforce: The All Rows syntax in queries is no longer case sensitive
  • Database Object Search: Added a View Contents right-click option for column name search results
  • Upgraded Cassandara datastax driver to version 3.8.0
  • Upgraded BigQuery driver to version 1.2.2.1004. This fixes an issue with numeric columns not being able to be queried
  • Bug Fixes:
  • Mac: Popup windows may not close property in certain situations
  • Font selector can't display the names of certain fonts

New in RazorSQL 9.0.8 (Mar 6, 2020)

  • Enhancements:
  • Query Results: Added the following options to the right-click menu of each results column and to the results menu: Average Values in Column, Count Values in Column, Count Distinct Values in Column, Max Value in Column, Min Value in Column, Sum Values in Column
  • DynamoDB: Added the abilty to query against nested maps up to 5 layers deep using SQL syntax Example query: select * from test_nested_map where outermap.innermap.innermap2.height = 60; outermap, innermap, and innermap2 are all maps in this example
  • DynamoDB: Added the ability to use syntax similar to the AWS command line for table scans. See RazorSQL DynamoDB SQL Support for details
  • Compare Tool: Improved performance
  • Added new DynamoDB scan expression and SQL syntax templates
  • Bug Fixes:
  • Salesforce: Queries with column lists and NOT like clauses throwing parser errors

New in RazorSQL 9.0.7 (Feb 25, 2020)

  • Changes:
  • Keep Alive: For databases / drivers that only support one open result set at a time, Keep Alive will no longer run if there is an open result set
  • PostgreSQL SQL Editor: Updated PostgreSQL keywords
  • Connection Wizard: RazorSQL hosted driver downloads now come from a secure AWS S3 server
  • SQL Server Database Browser: use queries to switch the database are no longer run when executing a View Contents query from the table node *BUG: SimpleDB: Edit Table Tool, Query Builder, and Results SQL Generation:
  • Bug Fixes:
  • SimpleDB: Edit Table Tool, Query Builder, and Results SQL Generation: Generated SQL should not allow updates to itemName() columns. This is not supported by SimpleDB
  • Linux Version: Edit Table Tool: Right-click menu not displaying
  • Generate DDL: SQL Server ODBC Driver: Identity information not displaying

New in RazorSQL 9.0.6 (Feb 19, 2020)

  • Enhancements:
  • Connection Wizard: Connection Profile Tree: Added the following options to the right-click / context menu: Connect, Add Profile, Copy Profile, Delete Profile
  • Edit Table Tool: Added the following options to the cell right-click / context menu: Add Row, Copy Row, Delete Row, Preview SQL, Execute SQL
  • Changes:
  • Derby Embedded databases are shut down on disconnect instead of on RazorSQL exit
  • Bug Fixes:
  • Auto Commit on / off values not showing up on connection profile screen

New in RazorSQL 9.0.5 (Feb 11, 2020)

  • Changes:
  • Query Results: Editing Cells: If column has a value and then value is removed, set the column value to null instead of empty
  • Generate DDL: If default value for a column is set to null, do not wrap null in quotes in DDL
  • Adding SQL Server Connections: MS SQL Server JDBC driver: instance name in host or database name is now supported. RazorSQL will extract the instance name and put it into the instanceName connection property
  • Export: ODBC connections: Handle no data found errors without stopping export
  • Bug Fixes:
  • Query Results: Editing Cells: If column is null, and column is clicked on but no value is entered in the column, update statement is still generated
  • Create Table Tool: Data type combo box size not correct when adding columns

New in RazorSQL 9.0.4 (Feb 11, 2020)

  • Enhancements:
  • Copy Table to Another Database: Added an Inserts Only (No DDL) option
  • Added preference to turn off displaying column type and length next to column name for the Database Browser
  • Changes:
  • Oracle: 12c JDBC driver updated from version 12.1 to version 12.2
  • Bug Fixes:
  • Database Browser: Generate DDL for a trigger under a table not working

New in RazorSQL 9.0.3 (Jan 9, 2020)

  • Changes:
  • Performance improvements for MySQL database conversion
  • Performance improvements for loading large XLSX files
  • MySQL: When using the MySQL Connector/J driver, the useCursorFetch property is set to true by default
  • Windows Installer: Added the option to install for all users or current user only
  • Bug Fixes:
  • DynamoDB: Error when launching edit table tool from query results in certain situations

New in RazorSQL 9.0.2 (Jan 3, 2020)

  • Changes:
  • Import Tool: Copies of Excel files are created and opened for reading to prevent out of memory situations from corrupting original Excel file
  • Import Tool: Improved performance when importing from XLSX files
  • Upgraded Apache POI Excel library to version 4.1.1
  • Bug Fixes:
  • Import Tool: Import from XLSX. Error thrown in certain situations when trying to read xlsx files
  • Import: Errors occurred during import message displaying behind the import dialog on Mac

New in RazorSQL 9.0.1 (Dec 20, 2019)

  • Enhancements:
  • PostgreSQL: Added support for procedures
  • Amazon Redshift: Added support for procedures
  • Amazon Redshift: Added support for connecting via AWS credentials files
  • Changes:
  • PostgreSQL Create User: Added support for the create role option
  • Database Conversion: SQL Server to Oracle and vice-versa. Converter converts default values of GETDATE() to SYSDATE and vice-versa
  • RazorSQL log file size capped at 1 GB
  • Added a preference for max SQL History database size in megabytes
  • Bug Fixes:
  • Redshift: Database Object Search returning all non-views in certain situations when tables option is selected
  • PostgreSQL DB Tools -> View Function Contents. Drop-down showing function name concatenated with the function specific name
  • PostgreSQL DB Tools -> Edit Function / Procedure. Drop-down showing function / procedure names concatenated with the specific name

New in RazorSQL 9.0.0 (Dec 12, 2019)

  • 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:
  • 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

New in RazorSQL 8.5.5 (Nov 20, 2019)

  • Enhancements:
  • Added the following Preference: Editor: Auto Convert Files to UTF-8 if Unencodable Chars. If the editor contents contain characters that are not encodable by the default encoding, the contents are saved in UTF-8 format if this preference is selected
  • Changes:
  • Mac: Adjusted font sizes for higher resolution displays
  • UI: Better support for displaying unicode data in labels and drop-downs
  • Import Tool: Encoding set automatically on files encoded with UTF-8
  • Bug Fixes:
  • Athena: Version 1 Athena driver no longer returning table names in database browser

New in RazorSQL 8.5.4 (Nov 13, 2019)

  • Enhancements:
  • Added support for HSQLDB 2.5
  • Changes:
  • Athena: New Connections now default to using the Athena Simba JDBC driver instead of the old version 1 driver. Older connections using the old version 1 driver may no longer show table names in the database browser. The connections should be created again using the new driver
  • General: Fonts: Default fonts changed to better match system defaults and better support display of unicode characters
  • SQL Editor: Editor font graphics settings changed to better match system defaults

New in RazorSQL 8.5.3 (Nov 7, 2019)

  • Enhancements:
  • DynamoDB: Added support for querying for is null and is not null on map attributes
  • Query Results: Added font auto detection that tries to select an appropriate font if the current font can't display characters in the results
  • Changes:
  • DynamoDB Database Browser: Expanding a table to show columns now lists key columns first and then remaining columns in alphabetical order
  • DynamoDB: Running a select * query now puts the key columns first and the rest of the columns are ordered alphabetically
  • DynamoDB: If specifying a column list in a select query against a table, the columns displayed in the results are in the same order as the column list in the select statement
  • Mac Catalina / Mojave version: Changed default max memory settings based on total memory available.
  • MySQL Connection Properties: Added the characterEncoding property as an option when using the MySQL JDBC driver
  • Bug Fixes:
  • DynamoDB: is null and is not null syntax in select statements only checking for existence of attribute on the table and not whether it has been set to a NULL attribute value
  • SimpleDB: Drop Domains generating tick marks around domains with special characters

New in RazorSQL 8.5.2 (Oct 24, 2019)

  • Changes:
  • Edit -> Copy History and Edit -> Paste History: Duplicate entries no longer shown
  • MySQL to HSQLDB Database Conversion: Unique indexes are included in conversion
  • Bug Fixes:
  • PostgreSQL Backup Table: Index DDL does not always include the statement separator
  • Javascript Validator: macOS Catalina: Javascript Validator not working on macOS Catalina
  • HSQLDB: Import from XLSX: Date Values include timestamp on generated inserts
  • Query Results: Add Row: For tables with 0 rows, 2 rows blank rows are appearing in the edit table tool instead of one

New in RazorSQL 8.5.1 (Oct 21, 2019)

  • Enhancements:
  • Backup Table: Added certain index DDL to the backup single table output
  • Bug Fixes:
  • DynamoDB Export Query Results - invalid cursor state in certain situations
  • Mac Catalina: Import Tool: Unable to import XLSX files
  • Mac Catalina: Crash when bringing up Finder window with preview enabled for certain file types

New in RazorSQL 8.5.0 (Oct 9, 2019)

  • Enhancements:
  • Query Results: Added an Add Row button to the toolbar, and Add Rows options to the Results menu, and right-click menus
  • Query Results: Added a Delete Row button to the toolbar and Delete Row options to the Results menu and right-click menus
  • Added an Edit -> Copy History menu that displays recent text that has been copied to the clipboard from the editor
  • Added an Edit -> Paste History menu that displays recent text that has been pasted to the clipboard from the editor
  • SQL Editor: Auto Completion: After selecting a table name after typing insert into, an option for generating an insert statement with the table column names and value place holders for the selected table displays
  • SQL Editor: Auto Completion: After selecting a table name after typing update, an option for generating the set column name clause of the update statement is presented
  • SQL Editor: Auto Completion: After selecting a table name after typing delete or delete from an option for generating the column name clause of the delete statement is presented
  • Changes:
  • SQL Editor: Auto Completion: If table name is selected after the keyword delete, "from" is automatically inserted between the delete and the table name
  • Upgraded DB2 JTOpen JDBC driver to the latest version
  • Increased the max number of files in the recent files menu option
  • Bug Fixes:
  • Call Procedure Tool: If the procedure called returns a result set, the call procedure tool was executing the procedure twice in certain situations

New in RazorSQL 8.4.7 (Oct 9, 2019)

  • Changes:
  • Query Results: Selecting the Compare Query Results option from a query results tab populates both queries in the compare tool if there is more than one query results tab
  • Bug Fixes:
  • Preferences that should not require restarting RazorSQL to take effect are requiring restart
  • Auto Updater not working for Windows machines
  • HBase connection help information is missing

New in RazorSQL 8.4.6 (Sep 25, 2019)

  • Enhancements:
  • Added support for the following HBase drivers: Apache Phoenix JDBC Driver, CData HBase JDBC Driver
  • Preferences: Added a preference for changing the query results selection color
  • Changes:
  • Preferences: Added more categories to make preferences easier to find

New in RazorSQL 8.4.5 (Sep 12, 2019)

  • Enhancements:
  • AWS Athena: Added the ability to specify an AWS properties file for authentication
  • Oracle Execute Function Tool: Added the ability to call functions with OUT parameters that also return a result
  • Oracle Database Browser: Added the ability to call DBMS_METADATA.GET_DDL for Oracle synonyms

New in RazorSQL 8.4.4 (Aug 27, 2019)

  • Enhancements:
  • MongoDB: Added support for connecting to MongoDB via a connection string
  • AWS Athena: Added support for passing in a session token in addition to an access key and secret key for authentication
  • Cassandra: Added the ability to select SSL encryption when setting up the connection profile on the add connection profile screen
  • Changes:
  • If auto save preference is set to true, tabs with file associated to them no longer prompt for save on exit. Files are saved automatically
  • Bug Fixes:
  • Query Scheduler: Column Aliases ignored for MySQL when printing the column names to the output
  • MongoDB: Connection Profile screen. Changing the value of the Use SSL Encryption checkbox does not get saved
  • Oracle Import Tool: apostrophes / single quotes in text not getting escaped in certain situations

New in RazorSQL 8.4.3 (Aug 1, 2019)

  • Enhancements:
  • Editor: Added Auto Save functionality for automatically saving editor tabs that have associated files every n seconds. Auto save settings can be configured in the Edit -> Preferences -> Backups / Auto Save preferences tab
  • Added functionality to periodically backup RazorSQL user data such as connection profiles, preferences, favorites, etc. Backup user data settings can be configured in the Edit -> Preferences -> Backup / Auto Save preferences tab
  • Export Utility: Added the ability to set date and timestamp formats when exporting multiple tables
  • Added an Edit -> Restore User Data from Backup option to the Edit menu for restoring user data (preferences, connection profiles, built-in database, etc.) from a previously created backup file (Edit -> Backup User Data)
  • Changes:
  • FTPS Client: Connections to servers with expired certificates is now possible
  • Bug Fixes:
  • Salesforce: Certain queries against the Order table are not parsing correctly

New in RazorSQL 8.4.2 (Jul 19, 2019)

  • Enhancements:
  • FTP Client: Added support for explicit FTPS connections
  • Oracle: Call Function Tool: Added support for calling functions that return ref cursors

New in RazorSQL 8.4.1 (Jul 9, 2019)

  • Enhancements:
  • Oracle Database Browser: Added ability to generate grants for procedures, functions, and packages
  • MS SQL Server Database Browser: Added ability to generate grantes for procedures and functions
  • DB2 LUW Database Browser: Added ability to generate grants for tables, views, and procedures
  • Changes:
  • Updated to jsch SSH library to version 0.1.55
  • DB2: Edit Procedure and Edit Function: Includes information about using create or replace syntax to preserve permissions

New in RazorSQL 8.4.0 (Jun 28, 2019)

  • Enhancements:
  • Added auto update capabilities to the Windows and Mac versions
  • Changes:
  • Added version 19.3 of the Oracle JDBC driver
  • Updated Firebird JDBC driver to the latest version
  • Editor: First time save of a file, file name is populated based on file type
  • Bug Fixes:
  • XML Validator: Schemas with maxOccurs values of more than 5000 throwing validation errors

New in RazorSQL 8.3.6 (Jun 7, 2019)

  • Changes:
  • Import Tool: When importing from XLSX files, if cell format is not set to scientific notation, values get converted from scientific notation to regular numbers
  • Query Results to the Same Tab: Queries that don't return results no longer take up space in the query results section
  • Query Results to the Same Tab: Better setting of columns widths after the first result set
  • Bug Fixes:
  • ODBC Connections: If query results number formatting preference is changed, numeric columns do not display data

New in RazorSQL 8.3.5 (May 31, 2019)

  • Enhancements:
  • Added Remove Line Breaks, Duplicate Line, and Text to HTML converter options to the Edit - Text menu
  • Changes:
  • Upgraded SQLite JDBC driver to version 3.27.2.1
  • Upgraded hive uber jar to the latest version
  • Bug Fixes:
  • DynamoDB: Tables with lists that contain number, string, or binary sets, or tables with lists of lists that contain those sets throwing errors in the database browser and when trying to query
  • Mac Notarized Version: SQLite connections using SQLiteJDBC throw an unsatisfiedlinkerror
  • Mac Notarized Version: Connections to SQL Server / SQL Azure not working when using the Microsoft SQL Server driver
  • Oracle Create Table Tool: First column size and scale are not editable until switching the data type
  • DB2 Generate Alter Table DDL / Describe Tool: Generated foreign key references may not be correct if the same constraint name is used across multiple tables
  • MySQL Alter Table DDL: Generated foreign key table may be empty

New in RazorSQL 8.3.4 (May 13, 2019)

  • Enhancements:
  • Salesforce Database Browser: Added option to view limited results from tables
  • SimpleDB Database Browser: Added option to view limited results from domains
  • Query Results: Execute SQL (Multiple Results Output to Same Tab): Resizing the query results now also resizes each result set inside the query results tab
  • Execute SQL (Multiple Results Output to Same Tab): For scripts or procedures that return multiple result sets, all results are shown in the same tab
  • Changes:
  • Execute SQL (Multiple Results Output to Same Tab): No longer requires multiple queries to be executed
  • Bug Fixes:
  • Sybase / SAP IQ: When using the SQL Anywhere driver, if query returns multiple result sets, only the first one is displayed
  • Add Connection Wizard: MySQL driver connection properties are displaying when the MariaDB driver is selected
  • Toolbar Customizer: Execute Multiple Results to the Same Tab button is not displaying in toolbar customizer in the preferences

New in RazorSQL 8.3.3 (May 2, 2019)

  • Enhancements:
  • PostgreSQL: Added support for json and jsonb types
  • PostgreSQL Database Conversion: Added support for json and jsonb types
  • Bug Fixes:
  • H2 to MS Access Conversion: H2 bigint data types were not converting to the correct type

New in RazorSQL 8.3.2 (Apr 25, 2019)

  • Enhancements:
  • Table(s) Conversion Process: Added an option for only generating SQL insert statements and not generating create and alter table DDL
  • Command Line Table Conversion: Added an option for only generating SQL insert statements and not generating create and alter table DDL
  • Changes:
  • File System Browser: Compress Files: symbolic links no longer followed to add files from sym links
  • Oracle: certain unprintable chars filtered from query results display
  • H2: If selected database file ends in .h2.db, .h2.db is stripped from file name in generated JDBC URL
  • Bug Fixes:
  • SQL Server Alter View: Extra line breaks getting inserted into view definitions in certain cases

New in RazorSQL 8.3.1 (Apr 11, 2019)

  • Enhancements:
  • Import Tool: Added an option for whether or not to fully qualify table names in generated insert statements for delimited, Excel, and fixed width imports
  • Database Browser: Added support for View Contents - Limit Results for SQLite, HSQLDB, and H2
  • Added an Edit -> Backup User Data menu option for backing up all user specific RazorSQL data such as preferences, connections, etc. to a zip file
  • Query Results: Added a locale specific number formatting option on the Edit -> Preferences -> Query Results screen
  • Changes:
  • Associate File: If file is already open on an unconnected and unmodified tab, connect that tab instead of creating a new tab
  • Launch Edit Table Tool from query results: If the query is a select * query and all the results are retrieved, use the already retrieved results for editing instead of re-executing a new query
  • Edit Table Tool: Max rows to retrieve per table now use the connection profile specific max rows setting instead of the global max rows setting from the preferences
  • Edit Table Tool: Query to populate uses a limit clause for certain databases to prevent retrieval of extra rows and improve performance
  • Bug Fixes:
  • Connection Wizard: If profile is deleted, copied, or renamed, profile tree does not update immediately

New in RazorSQL 8.3.0 (Mar 29, 2019)

  • Enhancements:
  • Connection Wizard: Added a tree view for existing connection profiles for faster selection
  • Connection Wizard: Added the ability to categorize connections inside sub-folders
  • Added a columnEncryptionSetting configurable property for the MS SQL Server JDBC driver
  • DynamoDB: Added the ability to scan for values inside of Map columns. See https://razorsql.com/docs/dynamodb_sql_support.html for syntax details
  • Connection Process: Added the ability to associate a file to a connection profile. Whenever the connection profile is connected, the file will load in the SQL editor.
  • Changes:
  • Salesforce: Updated API version to 45
  • Execute procedure tool - if procedure returns a result set, results are now displayed in the query results tab of the main window
  • Oracle: If DBMS Output is turned on, and query / statement does not return results but does return output, output is displayed in the query results section
  • Added ability to call SQL Server / Sybase functions that return a table via the Call Procedure Tool
  • Import Tool: Create Table from Import: If data values are decimal, will pre-populate decimal type with estimated precision and scale set on the create table window
  • Bug Fixes:
  • MySQL and MariaDB: Column aliases not always appearing as column names in query results for queries that use aliases for the column names
  • Initial screen size may be larger than current screen for multiple monitor machines having monitors with different resolutions

New in RazorSQL 8.2.5 (Mar 6, 2019)

  • Enhancements:
  • DynamoDB: Added support for parallel scans with a comment hint syntax. For example, select /*parallel:5:100*/ * from table where id < 10000 5 is the number of parallel threads 100 is the max results returned per thread
  • Salesforce: Describe Table Tool: Added a Reference Table column to the Columns tab
  • Salesforce: Query Builder: Added the ability to add more than one table to select queries
  • Query Results: Create Table from Results: Added option to create table from results on another connection of the same database type
  • Changes:
  • Edit Table Tool: Changed so that the table containing the table data always expands to the full size of the window and has a smaller minimum size
  • Auto Reconnect: If database is disconnected, and auto reconnection process works, set the selected database on the connection to the database at the time the connectio was lost instead of the database set on the connection profile
  • Salesforce: Added support for toLabel function in queries
  • PostgreSQL: Changed display of int2, int4, and int8 columns to smallint, integer, and bigint
  • The following files are now handled as zip files when opening: .odb, .odf, and .odt

New in RazorSQL 8.2.4 (Feb 8, 2019)

  • Enhancements:
  • Added a Recent Queries (All Connection) option to the SQL menu
  • Added a Recent Queries (This Connection) option to the SQL menu
  • Firebird: Added a DB Tools -> Create -> Create Database tool
  • Firebird: Added the ability to create a new database when setting up a new Firebird connection
  • Changes:
  • Added a preference to enable turning off storage of SQL history

New in RazorSQL 8.2.3 (Jan 18, 2019)

  • Enhancements:
  • Microsoft Access: Added the ability to create a new MS Access database using the Create New Database option when adding a new MS Access connection
  • Changes:
  • MongoDB: Decimal values bigger than a certain value are no longer returned in scientific notation
  • Bug Fixes:
  • Last record missing from edit table tool if user filters query results and then launches Edit Table Tool on query results
  • Right-click menu not working on editor tabs

New in RazorSQL 8.2.2 (Dec 20, 2018)

  • Enhancements:
  • Added a Connections -> Favorites menu. Connections can be set as a favorite either when creating intially or when connecting by checking the Add to Favorites box
  • Changes:
  • Mac Editor: For keyboards with HOME and END keys, Shift + Home and Shift + End now select to begin or end of line
  • Edit Table Tool: If multiple monitors, edit table tool is centered on screen of current monitor
  • Bug Fixes:
  • DB2 to Oracle Database Conversion: Precision of decimal columns not always getting set to correct number
  • When saving an export data profile for a query, line breaks in the query getting lost

New in RazorSQL 8.2.1 (Dec 5, 2018)

  • Enhancements:
  • Query Results: Edit Query: Control or Command + U now executes the query in the text area
  • MySQL DDL Generator: Added support for generating on delete cascade and on update cascade clauses to alter table statements
  • MySQL to HSQLDB Database Conversion: Added support for on delete cascade and on update cascade clauses in alter table statements
  • Edit -> Preferences -> Fonts -> User Input / Messaging Font option now changes all messaging fonts and user input fonts
  • Added a prefernence to the Preferences -> Query Results tab called Horizontal Scroll Sensitivity to allow adjusting the horizontal scroll sensitivity of the query results
  • Changes:
  • MySQL to HSQLDB Database Conversion: Primary key clause is generated in create table DDL for auto increment / identity columns
  • Main SQL Editor and pop-up editors: Focus can be transferred away from editors using control + tab
  • Query Results: Edit Query: Control tab can be used to switch from sql area to buttons without using mouse
  • MySQL Database Conversion: bit(1) columns now convert to bit(1) on HSQLDB
  • Database Conversion: When converting single tables, alter table statements are now generated in comments at the end of the conversion script
  • Bug Fixes:
  • MySQL: When sql mode is in strict ANSI compliance, table keys not displaying
  • MySQL to HSQLDB Database Conversion: Identity columns not getting generated correctly in DDL
  • Edit Table Tool: If multiple monitors with varying resolutions, Edit Table Tool window may be too wide or too tall for the current screen
  • Interbase: Boolean type missing from create table type drop-down

New in RazorSQL 8.2.0 (Dec 5, 2018)

  • Enhancements:
  • Describe Tool: Added a view definition tab for views
  • PostgreSQL Database Browser: Added user-defined types under the Types node
  • PostgreSQL Database Browser: Added a Generate Table Grants option for tables and views
  • PostgreSQL: Describe Table/View Tool: Added a Grants tab
  • PostgreSQL, MySQL, Oracle, SQL Server: Alter View: Now generates grant statements
  • Oracle Database Browser: Added a Generate Table Grants option for tables and views
  • Oracle: Describe Table/View Tool: Added a Grants tab
  • MySQL Database Browser: Added a Generate Table Grants option for tables and views
  • MySQL: Describe Table/View Tool: Added a Grants tab
  • MS SQL Server Database Browser: Added a Generate Table Grants option for tables and views
  • MS SQL Server: Describe Table/View Tool: Added a Grants tab
  • Firebird: DDL Generator: Added support for generating identities
  • HSQLDB: DDL Generator: Added support for generating identities
  • SQL Server and Sybase: If a procedure is executed that does not return results, but returns output, display the output in the query results
  • Salesforce: Added support for updating and inserting boolean values for CheckBoxes, etc.
  • Changes:
  • PostgreSQL: Updated JDBC driver
  • Linux: increased resolution of desktop / application menu icons
  • Export Tool: Redesigned export tool file selection flow
  • MonetDB Database Browser: Changed to use system queries to get tables, views, and functions instead of using driver calls
  • Changing the SQL editor font causes other text areas such as the preview pane on the import tool to use the changed editor font instead of the default font
  • Bug Fixes:
  • PostgreSQL 10: If a schema is empty, tables may still be displayed in database browser
  • Editor right-click menu not displaying
  • Export Tool: Loading from Saved Profile: Wrap quotes box selection always set to true

New in RazorSQL 8.1.1 (Oct 26, 2018)

  • Ingres: If comments in a query cause an error, RazorSQL will strip them
  • Added support for Java 10 and Java 11 to the Java compiler
  • Registration Screen now provides more information about license eligibility, upgrades, and archived downloads
  • Minor changes to Windows installers to improve performance

New in RazorSQL 8.1.0 (Oct 11, 2018)

  • Enhancements:
  • Added the ability to display results from multiple queries in the same tab via the Control / Command + 8 shortcut or the upward facing green arrow on the toolbar.
  • Mac: Added a dark mode look and feel option via the View -> Dark Mode menu option
  • Cassandra: Datastax Driver: Added ability to set connect timeout and read timeout connection properties
  • Changes:
  • Import Tool: More detailed error information when an error occurs and the one statement at a time option is checked
  • Cassandra: Datastax Driver: Set the connection timeout based on the value in the preferences
  • Query Results: If no column name or alias returned for query, column name given generic title
  • Bug Fixes:
  • SQL Formatter: Ignore commas in parens not working correctly
  • DynamoDB count query not working

New in RazorSQL 8.0.9 (Sep 26, 2018)

  • Enhancements:
  • Import Tool: Added option to convert empty values to a null value instead of empty string
  • Added the ability to import SSL certificates via the Help -> Import SSL Certificate menu item
  • Changes:
  • Import Tool: SQL Server: If values for bit columns are true or false, converted to 1 or 0
  • Ingres: Columns in database browser and describe tool now display in order of ordinal position
  • Query Results: Reduced horizontal scroll sensitivity
  • Query Results: When in edit mode, typing the escape key turns off edit mode
  • Export Tool: JSON Format: ampersand, single quote, greater than, and less than signs no longer use XML escape syntax
  • Bug Fixes:
  • PostgreSQL Database Browser: For newer versions of PostgreSQL, expanding the Triggers node under Tables in the database browser does not show the triggers for the table
  • PostgreSQL: insert and delete statements with returning clause throwing an error
  • Command Line Export: JSON Format: Null values not supported
  • Favorites: Opening a file from favorites menu not working

New in RazorSQL 8.0.8 (Sep 18, 2018)

  • Changes:
  • Opening a file that may be certain types of database files prompts for whether to open or connect
  • Import Tool: Fixed width importer: Performance changes
  • Bug Fixes:
  • Syntax Highlighting: Not able to change colors for the SQL syntax highlighting set

New in RazorSQL 8.0.7 (Sep 13, 2018)

  • Enhancements:
  • File System Browser and FTP / SFTP Browser: Added ability to sort by file type
  • Added print editor contents using web browser and print editor contents with line numbers using web browser options to the File -> Print menu
  • Added print query results using web browser and print query results with line numbers using web browser options to the File -> Print menu
  • Added the ability to open the same file in multiple tabs via the Edit -> Preferences -> Editor / GUI -> Allow Same File in Multiple Tabs preference
  • Changes:
  • File -> Open: If a SQLite database is detected, prompts for whether to connect to the database or edit the database file in the editor
  • Upgraded DB2 driver to version 3.72. Now supports TLS version 1.2
  • Upgraded SQLite driver to version 3.23
  • Bug Fixes:
  • Cassandra: Non-select statements with comments prior to the statement throwing errors
  • SQLite: Certain images / binary data / blobs are not getting displayed in hex value in query results causing potential hanging issues
  • MongoDB: When authentication is enabled, can't connect with role that doesn't have listDatabases / listCollections.
  • Salesforce: If a parent field referenced in the query has a null value and a child field referenced in the query has the same name as another field in the query, the value is getting set incorrectly

New in RazorSQL 8.0.6 (Sep 5, 2018)

  • Changes:
  • MySQL: Automatic handling of timezone errors for new MySQL driver
  • Mac: Editor: Decreased mouse drag sensitivity to allow double and triple clicks to highlight words
  • Updated local help documentation

New in RazorSQL 8.0.5 (Aug 17, 2018)

  • Enhancements:
  • Export Tool: Added ability for user to input a custom query for export
  • MySQL Create User Tool: Added support for MySQL 8 create user syntax
  • Changes:
  • Import Tool: XLSX Importer: Changed time zone behavior to not do timezone conversion on date fields
  • Bug Fixes:
  • Mac: Connection help links on the add connection profile screen require a double-click instead of a single-click

New in RazorSQL 8.0.4 (Aug 9, 2018)

  • Enhancements:
  • Redshift Database Browser: Added support for showing external tables via Redshift Spectrum
  • Salesforce: Added support for USING clauses in select queries
  • Changes:
  • Increased the default query timeout from 300 seconds to 900 seconds
  • RazorSQL Plugins: Plugins now only load from the plugin directory under the user's home directory

New in RazorSQL 8.0.3 (Aug 1, 2018)

  • Enhancements:
  • Added support for the Snowflake database
  • Import Tool / Execute SQL Script: Added better support for importing / executing MySQL dump file formats
  • Import Tool / Execute SQL Script: Allow for embedded semi-colons in text when statement separator is semi-colon
  • Changes:
  • Salesforce: Updated Salesforce API calls to version 43.0
  • SQL Editor: Added None as a syntax highlighting type

New in RazorSQL 8.0.2 (Jul 20, 2018)

  • Enhancements:
  • DynamoDB Export: Added ability to export tables / queries with very large result sets
  • Added preference for switching the caret to a block instead of a line
  • Added preference to turn on / off the blinking caret
  • Changes:
  • DynamoDB: Increased max error retry value and network timeout settings
  • Bug Fixes:
  • SQL Formatter: Not supporting keywords inside double quotes correctly
  • Import: Column information for table can get duplicated in certain situations
  • Tables with the same name but different case get duplicate columns on describe table for certain databases

New in RazorSQL 8.0.1 (Jun 26, 2018)

  • Bug Fixes:
  • SQL Server / SQL Azure: Indexes that are not in the default schema are not displaying in the database browser
  • Import Tool: Unable to retrieve column names for tables or schemas not in the default case of the database
  • kdb+: Edit Table Tool: Not generating insert, update, or delete statements correctly for numeric columns
  • If connecting to Athena before DynamoDB, the DynamoDB connection fails. To fix, re-create Athena connection
  • If connecting to Redshift using the Redshift driver before connecting to Dynamodb, an error occurs. To fix, re-create Redshift connection.
  • Call Procedure Tool: When wrap objects in generated sql preference is set to always, call procedure tool does not work in certain situations
  • SQL Server Database Conversion: parens are getting generated in default value clause in create table statement for databases that do not support parens in default value clauses

New in RazorSQL 8.0.0 (May 15, 2018)

  • Enhancements:
  • 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
  • Changes:
  • 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
  • Bug Fixes:
  • 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

New in RazorSQL 7.4.10 (Mar 19, 2018)

  • Enhancements:
  • Cassandra: Added support for the DataStax driver. Thrift protocol no longer needs to be enabled to connect
  • Cassandra Database Navigator: Added support for views for Cassandra version 3 and newer
  • Cassandra Database Navigator: Added option for running limit queries
  • FTP Client: Improved speed of FTP download and upload processes
  • Changes:
  • SQL Server and Sybase: When using GO as a statement separator, it is no longer case sensitive
  • Database Navigator: Cassandra: Show all keyspaces not just the ones that have tables
  • Bug Fixes:
  • FileMaker: Export, Edit Table Tool, and Generate Insert, Update, and Delete options on query results not generating date, time, and timestamp syntax correctly

New in RazorSQL 7.4.9 (Mar 9, 2018)

  • Enhancements:
  • H2 Connections: H2 driver can now be auto-installed
  • Derby Network Connections: Added option to create the database on connect if it does not yet exist
  • Changes:
  • Query results binary data: Convert to hex now happens by default in query results unless convert to hex preference is manually unchecked
  • Drop Table and Truncate Table tools - Drop/Truncate statements are automatically regenerated when new table is selected
  • Bug Fixes:
  • Ingres: Ingres procedure columns not recognized as inout or out in certain situations

New in RazorSQL 7.4.8 (Mar 5, 2018)

  • Enhancements:
  • Firebird: Added support for connecting to Firebird 3 databases without making wirecript configuration changes
  • Firebird: Added support for the binary data editor and image viewer for blob subtype 0 / blob subtype binary columns
  • Added support for Derby 10.14
  • Changes:
  • Upgraded Firebird JDBC driver
  • Bug Fixes:
  • Ingres: Procedure names not correct in certain situations
  • Row limit not supported with old versions of MySQL connector/j driver. RazorSQL now does not attempt to set row limits for old MySQL driver versions

New in RazorSQL 7.4.7 (Mar 1, 2018)

  • Enhancements:
  • Salesforce: Added row count option to Salesforce database navigator right-click / context menu
  • Salesforce: Added support for streaming Salesforce results to allow support for larger exports
  • DynamoDB and SimpleDB: Added support for AWS STS temporary credential session tokens for authentication
  • DynamoDB and SimpleDB: Added support for using AWS credentials files for authentication
  • SAP / Sybase ASE: Added ability to set NEWPASSWORD property on connections to change expired passwords
  • Changes:
  • AWS Secret Key needs to be masked when adding a new connection profile
  • Athena JDBC driver download updated to latest version
  • MySQL: Updated reserved word list to support reserved words added in MySQL version 8
  • Bug Fixes:
  • Oracle Packages with overloaded functions and / or procedures not supported correctly
  • Command Line Process: Connection via SSH tunnel not supported

New in RazorSQL 7.4.6 (Feb 14, 2018)

  • Enhancements:
  • Query Scheduler: Added ability to add date time onto generated file name
  • Sybase IQ / SAP IQ: Added support for autoincrement / identity columns to the generate ddl tool
  • Database Conversion: Added support for including default values in generated create table statements for MySQL, HSQLDB, Oracle, H2, and SQL Server
  • Changes:
  • Sybase IQ / SAP IQ: Generate DDL generates create index statements that have many spaces after the index name
  • SQL Favorites Menu: Added sub-menus for instances when there are too many favorites defined to fit on the screen
  • Added several missing keywords to sql syntax files
  • Bug Fixes:
  • If going from a multiple monitor setup to a single monitor setup, certain windows like the Find dialog may display offscreen
  • Mac: Dragging and dropping table and column names to the editor does not work after 7.4.5 release
  • SQL History: If multiple versions of RazorSQL are open, sql history may get overwritten
  • GenerateDDL and Database Conversion: If a table has multiple foreign keys referencing the same column on another table, generate ddl was combining the alter table statements for the foreign keys into one statement

New in RazorSQL 7.4.5 (Jan 31, 2018)

  • Enhancements:
  • Added ability to drag and drop files to editor for opening
  • Added ability to create and open file sets (File -> Open File Set) menu option for opening a set of files with one operation
  • Added ability to use the show create commands for procedures, functions, and triggers to the database navigator
  • Database Navigator: Enabled Generate DDL option in addition to the Edit option for functions, procedures, triggers, packages, and package bodies for supported databases
  • Bug Fixes:
  • MS SQL Server: Generate View DDL / definition from a database other than the currently selected database or a schema other than dbo is limiting the view definition to the first 8000 characters
  • Query results column width not wide enough in certain situations when the last row displayed is the widest value
  • MS Access: Generate DDL should not display a length for GUID columns
  • Switching editor tabs while queries are executing can cause the query results to be displayed in the wrong tab

New in RazorSQL 7.4.4 (Jan 15, 2018)

  • Enhancements:
  • Added Close Tab context menu option to query results tabs
  • Changes:
  • SQLite: RazorSQL SQLite Driver changed to legacy status. Recommended to use SQLite JDBC Driver
  • SQL Server procedure editor - if file contains carriage return / line feed line break format, or if editor preference for line breaks is set to carriage return / line feed, the carriage returns are kept in the procedure text when sent to the database
  • FrontBase: Drop table syntax now includes restrict keyword at the end
  • Bug Fixes:
  • FrontBase: With certain drivers, dropping an object will cause database navigator to not reload correctly
  • SQLite: Generate DDL does not generate View DDL for views with spaces or special characters in the name
  • SQLite: Alter option for Views in context menu of database browser not generating drop and create view statements
  • Auto-commit setting not retained when opening a new tab that shares the existing connection
  • High Resolution Monitors: Close icon on tabs right-edge not completely straight
  • Mac: High Resolution Monitors: Close icons not working on tabs

New in RazorSQL 7.4.3 (Dec 28, 2017)

  • Enhancements:
  • Added Redshift to database conversion tools
  • Changes:
  • Direct3d graphics now enabled by default on Windows
  • Bug Fixes:
  • Multiple monitors with vertical orientation or 3 plus monitors with mix of vertical and horizontal orientation, windows not always displaying on the correct monitor

New in RazorSQL 7.4.2 (Dec 18, 2017)

  • Enhancements:
  • Salesforce and DynamoDB Connection Setup: If there is a proxy server configured on the machine, RazorSQL will prompt for automatically connecting through the proxy server
  • Changes:
  • Upgraded to version 1.11.248 of Amazon AWS JDK for DynamoDB connections
  • Added a work-around to enable connecting to Salesforce, SimpleDB, or DynamoDB over https thru a non-https proxy server
  • UI changes to make sure default buttons were set on windows that did not have a default button
  • Cleaned up local help documentation. Fixed missing / broken links for certain database specific help pages.
  • Bug Fixes:
  • Downloading a driver file through a proxy server may cause subsequent connection attempts to time out
  • SQL Server: Explain plan does not work when using server side cursors (selectMethod=cursor) with MS SQL JDBC driver
  • SimpleDB and DynamoDB: Configure Proxy button does not show Proxy configuration window on the add connection window

New in RazorSQL 7.4.1 (Dec 12, 2017)

  • Changes:
  • RazorSQL now uses system proxy server settings for the driver auto-install / auto-download process to prevent download timeouts for users behind proxy servers
  • MonetDB: changed the way the set current schema call works to support old and new MonetDB drivers
  • MonetDB: changed the way the call to get columns for a table works to support old and new MonetDB drivers
  • Uncomment Tool: If multiple lines in the editor are selected, will remove comments from individual lines if they start and end with multi-line comment indicators

New in RazorSQL 7.4.0 (Dec 7, 2017)

  • Enhancements:
  • Added support for VoltDB
  • Added support for Druid
  • Added additional supported features for Apache Hive
  • Added support for Oracle XMLType to backup, conversion, data editing, and SQL and DDL generation
  • Salesforce: Added support for min, max, sum, and avg aggregate functions
  • Added a database selection drop-down to the toolbar for Apache Hive
  • Changes:
  • Upgraded MonetDB JDBC driver that gets downloaded via the auto install process
  • Hive: Table names no longer returned as part of the column name in query results
  • Mac: Multiple files can now be selected when manually adding JDBC driver jar files

New in RazorSQL 7.3.15 (Nov 29, 2017)

  • Enhancements:
  • Added some preliminary support for Apache Hive
  • Changes:
  • File System Browser path field font gets aligned with the File System Browser tree font if the tree font is changed
  • Bug Fixes:
  • Quote and Double-Quote keys not usuable on US International Keyboard layout

New in RazorSQL 7.3.14 (Nov 16, 2017)

  • Changes:
  • Query Results filter rows and find all rows options no longer include empty rows in the results table
  • MonetDB: Unnecessary SQL warnings no longer displayed
  • High Resolution Display Changes: Added higher resolution desktop and taskbar icons, additional window sizing adjustments for better display
  • Bug Fixes:
  • Salesforce queries with escaped single quotes throw an error when the query ends with a semi-colon

New in RazorSQL 7.3.13 (Nov 1, 2017)

  • Enhancements:
  • Added a drop schema tool for the following databases: Oracle, PostgreSQL, Redshift, DB2, MS SQL Server, SQL Azure, Derby, HSQLDB, and H2
  • Bug Fixes:
  • Add/Remove column buttons not working correctly on the Create Table Tool
  • Linux: Systems running Wayland may crash when displaying context menus
  • DynamoDB: When running a local and remote DynamoDB connection, table information cache is getting shared across the local and remote connection
  • Commit and Rollback toolbar icons not getting enabled or disabled correctly when auto-commit status is changed on the toolbar and multiple connections tabs are navigated to and from

New in RazorSQL 7.3.12 (Oct 23, 2017)

  • Enhancements:
  • MonetDB: Added schema drop-down on toolbar for changing the current schema
  • Increased the maximum number of files displayed in the recent files, recent directories, and file system browser goto directory menus
  • Added a Document End Line Break option to the Edit menu for taking the cursor to the end of the editor and inserting a line break to put the cursor at the front of the newly created last line
  • Changes:
  • DB2: Large double numbers no longer show in scientific notation
  • Bug Fixes:
  • MonetDB: Database name getting concatenated in front of schema name in generated queries
  • MonetDB: Mixed case / all upper-case tables not getting wrapped in quotes in generated queries

New in RazorSQL 7.3.11 (Oct 21, 2017)

  • Bug Fixes:
  • Mac: Copy Table Tool: Window freezing after executing the generated SQL script from within the copy table window

New in RazorSQL 7.3.10 (Oct 17, 2017)

  • Changes:
  • Added a default max rows value for Netezza and Greenplum
  • Upgraded Firebird JDBC driver to Jaybird version 3.0.2
  • Icons are no longer scaled to a larger size for high-resolution screens that do not have a operating system scaling value set
  • When connecting to a *.database.windows.net host for SQL Server or Azure, a database name is required
  • Database Conversion, Copy to Local Database: Alter statements are not generated / executed after insert statements

New in RazorSQL 7.3.9 (Oct 11, 2017)

  • Enhancements:
  • Windows: Added Dark Mode look and feel theme to the View -> Change Look and Feel menu
  • Added Pipe as an option for import delimiter in the command line import process and as a selectable character in import and export tool drop-downs
  • Find in Files: For finds occuring over a network drive, added logic to retry file access if network drive access is temporarily unavailable during find operation
  • Copy Table Tool: Added qualify table names option
  • Alter Table Tool: Added options to add NOT NULL constraints to change column type options for Oracle, MySQL, and MS SQL Server
  • Changes:
  • Changed commit, rollback, and view table icons
  • Database Navigator: Generate DDL: fully qualify table name in references call when generating alter table statement
  • Database Navigator: Copy Table: fully qualify table name in references call when generating alter table statement
  • Bug Fixes:
  • Database Navigator: Oracle, MySQL, MS SQL Server, and Sybase ASE: Duplicate indexes displaying for indexes with more than one column in the index definition
  • Database Navigator: Generate DDL: Oracle, MySQL, MS SQL Server, and Sybase ASE: Generate DDL option generates duplicate create index statements for indexes with multiple columns in the index definition

New in RazorSQL 7.3.8 (Oct 11, 2017)

  • Enhancements:
  • Windows: Added Windows Default Look and Feel option to the View -> Change Look and Feel menu. This option sets the look and feel to match the Windows default look and feel for the version of Windows being used
  • Added preference for whether to halt processing of result sets when an error occurs retrieving results. Default is set to true
  • Linux: The OpenGL graphics pipeline can be enabled using the View -> Enabled Advanced Graphics menu option. This is not recommended for most systems.
  • Changes:
  • Windows: Direct3d graphics pipeline is now disabled by default. To enable, select the View -> Enable Advanced Graphics menu option
  • Range comment option adds a space at the after the beginning comment characters and before the ending comment characters. Using the Uncomment option does not remove the extra spaces
  • Bug Fixes:
  • When manual text size scaling was set via the View menu, Menu font was not correct system font on Windows and Linux
  • Multiple Monitors: FTP Browser window always showing on main monitor

New in RazorSQL 7.3.7 (Sep 21, 2017)

  • Changes:
  • Oracle Package Body function navigator sorts functions and procedures in alphabetical order by the name
  • Windows: Upgraded to latest version of editor font to support additional unicode characters
  • Bug Fixes:
  • PostgreSQL: Generate DDL with Functions option selected is not returning the function definitions
  • PostgreSQL: Backup Schema option not generating function contents
  • Font changes not staying in effect on high-resolution monitors

New in RazorSQL 7.3.6 (Sep 12, 2017)

  • Changes:
  • Mac: Changed default key hold behavior to repeating keys
  • Bug Fixes:
  • Mac: Command keys and sometimes keyboard input stops working in certain situations

New in RazorSQL 7.3.5 (Sep 6, 2017)

  • Changes:
  • Amazon Athena: Improved performance of query builder load
  • Add Connection Screen: Added option to set max rows to display to all database and connection types
  • Add Connection Screen: Set a default, overridable max rows to display of 25000 for certain database types
  • Connection Screen: If max rows to display is not set, default to 25000 for MySQL, MariaDB, Aurora MySQL, and Redshift
  • The connection level max rows to display limit is not applied to export, backup, or other file based processes
  • In the Preferences, If the Query Results -> Max Rows to Retrieve Per Query value is set, this applies to all select queries including exports and backups. If the connection level max rows to display is set, that value takes precedence over the preference level value, but does not apply to exports or backups
  • Updated MariaDB driver to latest version to prevent Aurora MySQL connection timeouts in certain situations

New in RazorSQL 7.3.4 (Aug 30, 2017)

  • Enhancements:
  • DynamoDB: Added support for inserting / updating map data in json format
  • Enhancements for 4k resolution
  • Bugs:
  • Mac FTP / SFTP: Delete dialog can be hidden behind another dialog

New in RazorSQL 7.3.3 (Aug 16, 2017)

  • Enhancements:
  • Added support for SQL Azure Active Directory user / password authentication
  • Added support for SQL Azure Active Directory single sign-on for Windows users
  • Added support for HSQLDB / HyperSQL version 2.4
  • Changes:
  • Reduce amount of logging for Salesforce and DynamoDB to prevent large log files
  • Bugs:
  • RazorSQL SQLite driver not recognizing primary keys correctly when columns are defined with tick marks surrounding the name

New in RazorSQL 7.3.2 (Aug 2, 2017)

  • Enhancements:
  • Added ability to enter a custom Salesforce.com URL via the environment drop-down when creating a connection
  • Added a mysqli_bridge.php page to the bridges folder under the installation directory that supports MySQL Bridge connections for PHP 7
  • Added a preference to the Query Results preference tab for replacing editor contents with the query used to generate the query results tab when switching query results tabs

New in RazorSQL 7.3.1 (Jul 18, 2017)

  • Enhancements:
  • Added support for filtering schemas in the database navigator for PostgreSQL
  • Upgraded to latest ucanaccess driver
  • Changes:
  • DynamoDB: ListTables permission is no longer required for a successful connection
  • Vertica: Escape tables that have underscores for table meta data calls to improve performance
  • Bug Fixes:
  • Multiple tabs sharing same connection - database is changed in the dropdown in one needs to also be changed in all the other tabs
  • PostgreSQL: update returning statement does not work
  • FTP Browser: Overwrite prompt hidden behind other dialog on certain systems

New in RazorSQL 7.3.0 (Jun 15, 2017)

  • Enhancements:
  • Added JSON as an option to the Export tool
  • Added JSON option to the command line export tool
  • Added table conversion to the command line tool
  • Added a delete all rows option to the Edit Table tool
  • Added tooltip text to the file names in the FTP browser
  • Changes:
  • Database name is now required for SQL Azure connections
  • Edits in new window font on Edit Table Tool now matches the edit table tool / query results font
  • Trying to enter column selection mode in a file with potentially misaligned tabs gives warning with an option to create a new editor tab with tabs converted to spaces
  • Upgraded MariaDB driver to version 2.0.1
  • Bug Fixes:
  • Dragging from 4k display to non-4k display causes window to turn black.
  • FTP Browser: File name width not getting calculated correctly leading to long file names getting cut off
  • Describe tool not working for tables with certain column types
  • MySQL keep alive query not getting set correctly when creating new connections
  • DynamoDB tables with more than one dot in the name throwing sql parsing error from database navigator operations
  • Connections -> View Print Output menu option not enabled for PostgreSQL
  • PostgreSQL raise / print information displaying duplicate messages in certain situations

New in RazorSQL 7.2.6 (May 8, 2017)

  • Enhancements:
  • Automatic application of Windows scaling percentage for text and icons when text and icon size are set to the defaults of Auto-Detect
  • Enhancements to make fonts, icons, etc. look better on 4k displays
  • Bug Fixes:
  • If default syntax type is set in preferences to something other than SQL, not always getting applied properly when opening new tabs

New in RazorSQL 7.2.5 (Apr 10, 2017)

  • Changes:
  • Improved memory efficiency of the compare process
  • Bug Fixes:
  • XLSX files with empty lines at the end causing errors with the import tool
  • XLSX import - varchar column values getting .0 appended when values are numeric
  • View menu user-defined keyboard shortcuts getting lost when opening new tabs

New in RazorSQL 7.2.4 (Mar 22, 2017)

  • Enhancements:
  • Added support for the XLSX format for the command line export process
  • Added Azure Data Warehouse connection option for SQL Azure
  • Added support for mouse-based horizontal scrolling on Mac
  • Better support for SQL keywords in Salesforce queries
  • Changes:
  • Upgraded HSQLDB driver to 2.3.4
  • Upgraded SQLite driver to 3.16
  • Upgraded sqlite3 command line program to 3.16
  • Bug Fixes:
  • Icons and Text not getting scaled enough for Windows scaling above 150%
  • SQL Formatter window OK button requires mouse to execute - can't be executed with keyboard
  • Add Connection Wizard: When no existing database connection profile exist, the database type list is not getting the window focus
  • Fonts on preferences window not correct for scaling or when text size expanded
  • Query results search all option is not setting the view of the results table back to the first row

New in RazorSQL 7.2.3 (Feb 7, 2017)

  • Enhancements:
  • Added a View -> Font -> Reset Fonts to Default menu option and adding a reset fonts to default option in the preferences
  • Mac 64-bit: Included executable program within RazorSQL.app so command line programs can be run without any additional installs required
  • Changes:
  • Changed default editor font size from 11 to 12
  • Xactly ODBC Driver: If query returns no rows, don't show error
  • Xactly: Drop-downs: Configure for schema support only - remove catalog/database options
  • Xactly: Don't perform operations on stale results or connections to prevent crashing
  • Bug Fixes:
  • FTP client. Right-clicking on Mac with control plus click deselects the currently highlighted item
  • Mac 64-bit: Next tab and Previous tab shortcuts moving over two tabs instead of one
  • If screen resolution is made larger while RazorSQL is running, unable to resize window past original screen size
  • FTP Client: The progress bar on windows is not wide enough
  • MS SQL Server: Generate DDL is putting sizes on hierarchy_id columns
  • Query Results: Copy Results to Clipboard (No Column Names) option is including the column names in the copied text

New in RazorSQL 7.2.2 (Jan 19, 2017)

  • Enhancements:
  • Better support for windows display scaling
  • Added support for literal and binary strings over the maximum supported length by the database to be inserted via the Import tool - Import from a File of SQL Statements option if RazorSQL was used to generated the SQL file.
  • Changes:
  • For newer versions of Cassandra, all defined keyspaces are displayed in the database navigator even if they do not have tables
  • Changed default icon and text size to auto detect
  • Mac 64-bit: Allow to run on less battery intensive graphics card for machines with two cards
  • Bug Fixes:
  • Command Line Call Generator: Execute Option: Not generating command correctly when password override is left blank
  • Some code builders not working (HTML, C, etc.)

New in RazorSQL 7.2.1 (Jan 4, 2017)

  • Enhancements:
  • Added a quick connect box to the toolbar
  • Changes:
  • Changed Xactly keep alive settings to prevent a crashing issue
  • Changed the way decimal values are retrieved for Xactly
  • Bug Fixes:
  • HSQLDB / HyperSQL: Generate DDL and Alter view not working with newer versions of HSQLDB

New in RazorSQL 7.2.0 (Dec 15, 2016)

  • Enhancements:
  • Added support for Amazon Athena
  • Added support for Amazon Aurora MySQL compatible version
  • Added support for Amazon Aurora PostgreSQL compatible version
  • Added support for Derby 10.13 to the auto-install driver process
  • Added several default, configurable connection properties for the MariaDB driver
  • For databases that RazorSQL has auto-download configured for drivers, added option for re-installing drivers after they were already downloaded / installed
  • Added a Tools -> International Editor option for more easily typing languages such as Chinese, Japanese, and Korean
  • Changes:
  • Changed default driver for MySQL to the MariaDB driver
  • Upgraded to version 1.5.5 of the MariaDB driver
  • SQL Server jtds driver: default to useNTMLV2 when not otherwise set and using domain security
  • Bug Fixes:
  • Cassandra: Selecting against smallint and tinyint columns is not working
  • Create function syntax for Amazon Redshift is not correct
  • Mac: Find/Replace command window not allowing editing when keyboard input is set to certain languages other than English.
  • Mac: Certain keyboard shortcuts executing twice when keyboard input is set to certain languages other than English

New in RazorSQL 7.1.4 (Dec 3, 2016)

  • Changes:
  • Changed threading behavior for SQL Server ODBC connections
  • Changed threading behavior for CacheDB ODBC connections
  • Bug Fixes:
  • Configure connection properties option does not support values with ~ or | characters in them
  • Sybase: Executing queries that load temp tables using the Execute SQL Fetch All Rows option throws an error

New in RazorSQL 7.1.3 (Nov 24, 2016)

  • Changes:
  • MongoDB: Changed default settings for timeouts and socket keep alive
  • Bug Fixes:
  • SSH Tunnel and SFTP client not working with SSH servers whose preferred authentication is kerberos

New in RazorSQL 7.1.2 (Nov 21, 2016)

  • Enhancements:
  • Edit Table Tool: Apache Derby: Added support for identity / auto increment columns
  • Added preference for whether to warn on disconnect
  • Added an Extra Large option to the View -> Text Size menu
  • Added an Extra Large option to the View -> Icon Size menu
  • Changes:
  • Changed default memory settings on 64-bit versions
  • SFTP Client - set max authentication tries to 1 to prevent account locking
  • Changed default max memory for razorsql_himem.exe to 6 GB
  • Bug Fixes:
  • SQL Server to PostgreSQL conversions for smallint and tinyint not working correctly
  • File System Browser and FTP client icons not displaying correctly when View - Icon Size menu option set to larger than normal

New in RazorSQL 7.1.1 (Nov 1, 2016)

  • Enhancements:
  • Added support for configuring connection properties for the MS SQL Server driver when connecting to SQL Azure
  • Changes:
  • Connection Wizard: Changed display of database type list
  • Bug Fixes:
  • Informix Edit Table Tool: Generated insert/update/delete statements for columns with data type smallint generating incorrect SQL
  • Mac: Zip Utility: Extract All option selecting the parent directory instead of the current directory of the zip file
  • Mac: Zip Utility: Zip file not getting closed correctly after zip utility is closed
  • Editor font not changing if user changes text size option in the View menu to Medium or Large

New in RazorSQL 7.1.0 (Oct 25, 2016)

  • Enhancements:
  • Export Tool: Added the Excel XLSX format as a supported option
  • Import Tool: Added the Excel XLSX format as a supported option
  • Linux x86 and x64: Upgraded graphics libraries and runtime
  • Window x86 and x64: Upgraded graphics libraries and runtime
  • Mac x64: Upgraded graphics libraries and runtime
  • Changes:
  • H2 database connection wizard auto download process - updated to get latest stable version of H2
  • Bug Fixes:
  • Database Conversion: Salesforce address column types getting a length of 0 when converting to other database types

New in RazorSQL 7.0.9 (Oct 10, 2016)

  • Enhancements:
  • Command Line File Execution: Added a halt on error parameter
  • Command Line File Execution: Added a show output parameter
  • Command Line File Execution: When executing as batch, if batch fails, try to execute statements in batch after the failure statement
  • Import Tool: For delimited, SQL, and Excel files, if batch fails, try to execute statements in batch after the failure statement
  • Changes:
  • For SQL Server Express / local connections, if JDBC connection fails, try ODBC connection via shared memory
  • Bug Fixes:
  • SQL Server TSQL blocks that start with a use statement not returning results from selects inside the block

New in RazorSQL 7.0.8 (Oct 6, 2016)

  • Enhancements:
  • Added a file encoding parameter option to command line delimited file import
  • Added a halt on error option to the command line delimited file import
  • Command line import - if there is an error, batch size is greater than 1, and halt on error is false, try to re-execute any statements in the failed batch that were not executed due to an error in a previous statement
  • Bug Fixes:
  • Teradata Version 15 driver throws an ExceptionInitializationError
  • Import tool: create new table and import from sql file erroring

New in RazorSQL 7.0.7 (Sep 30, 2016)

  • Enhancements:
  • Added a Find All Rows icon to the query results pane that displays all rows that have any column that contains the text entered by the user
  • Added clear entries option to recent files menu
  • Added clear entries option to recent directories menu
  • Minor performance improvements to Export
  • Changes:
  • Upgraded MariaDB driver
  • Upgraded Informix driver
  • Ignore case when sorting the recent files menu items
  • Ignore case when sorting the recent files menu items
  • Increased the time allowed between keystrokes before the buffer resets for database navigator key ahead searching
  • Bug Fixes:
  • Oracle prepared statement import does not work when importing a subset of the columns in the table
  • Salesforce: if you order on an aggregate, the grouped field in the linked table disappears

New in RazorSQL 7.0.6 (Sep 21, 2016)

  • Enhancements:
  • Added support for Salesforce functions in select and group by, and having clauses
  • Oracle: Added a use preparedstatement option to delimited file import tool for better performance
  • General performance improvements to the delimited file import process
  • Added an option to command line import that determines whether to print the executed statements
  • Added an option to command line import that determines whether to use prepared statements to increase performance if supported by the database type and data types of the table
  • Changes:
  • Command line import for Oracle now generates date inserts using the to_date syntax for certain date formats
  • Bug fixes:
  • Salesforce query values not displaying for certain join types
  • Filter navigator option not working for MS Access
  • Auto commit setting getting turned off mid-session for some ODBC drivers
  • Unable to fetch more rows when row count is above fetch size using SQL Server ODBC

New in RazorSQL 7.0.5 (Sep 2, 2016)

  • Changes:
  • Explicit commit now called when auto commit is on for SQL Server ODBC connections running with Read Uncommitted transaction isolation
  • Bug Fixes:
  • Edit Table Tool: If close window without saving, and click No on warning message, window closes anyway
  • No data found error for SQL Server Numeric columns using ODBC
  • Mac file selection dialog returning an actual file as a directory path in certain situations

New in RazorSQL 7.0.4 (Aug 24, 2016)

  • Enhancements:
  • Added support for macOS Sierra
  • Enhanced single-threaded mode for legacy ODBC drivers
  • Added a preference to force RazorSQL to run in single-threaded mode (for legacy drivers that don't support multi-threading)
  • Added support for more Salesforce count query types
  • Changes:
  • Xactly and CacheDB ODBC connections are now set in single-threaded by default
  • Changed the way RazorSQL communicates with the Xactly driver for non-select statements
  • Bug Fixes:
  • Queries against tables with uniqueidentifier columns throw errors when using the SQL Server ODBC driver

New in RazorSQL 7.0.3 (Aug 2, 2016)

  • Enhancements:
  • Added a preference for showing empty Oracle schemas in the database navigator
  • Bug Fixes:
  • Salesforce: connections to sandbox not working since version 7.0.2
  • SQL Server xml type should not get a size automatically in create table tool

New in RazorSQL 7.0.2 (Jul 27, 2016)

  • Enhancements:
  • Oracle connection wizard: Added the ability to set up LDAP connections
  • Oracle connection wizard: Added the ability to set up connections based on TNS files
  • Changes:
  • Excel import: Numbers in scientific notation are converted to whole numbers
  • HSQLDB database conversion: Primary key clause no longer included in create table statement for identity columns
  • Increased max frame size in Cassandra driver from 16 MB to 64 MB
  • Added support for Access GUID
  • Upgraded Salesforce API to version 37
  • Bug Fixes:
  • Unable to query Salesforce Order table
  • Proxy settings not getting saved when configuring proxy via Add connection profile
  • Cassandra: Timeuuid column type not supported
  • Certain data types not showing up in create table tool for SQL Server
  • Keep alive executing during exports causes problems in certain databases / drivers

New in RazorSQL 7.0.1 (Jun 16, 2016)

  • Enhancements:
  • Salesforce table conversion: Added the ability to convert Salesforce tables to the following databases: DB2,MS SQL Server,MS Access,MySQL,Oracle,PostgreSQL,SQLite, HSQLDB, and H2
  • DynamoDB local connections now allow the region to be specified in the local URL
  • Changes:
  • DB2 Conversion - when converting to DB2 tables, force a NOT NULL constraint on primary key columns
  • Minor display layout changes
  • Bug Fixes:
  • Export Tool: Invalid file paths sometimes received from the save file dialog

New in RazorSQL 7.0 (Jun 8, 2016)

  • Enhancements:
  • Added support for DB2 table conversion to and from the following databases: MySQL, PostgreSQL, SQL Server, Oracle, MS Access, SQLite, and HSQLDB.
  • Added support for HPE Vertica databases
  • Salesforce: Added column sizes to Salesforce describe table tool
  • Added create index statements to the generate DDL option for tables
  • DynamoDB: Added the option to connect to a DynamoDB local server when creating a connection to DynamoDB
  • Added ability to edit connection profile names on the connection window
  • Added support for Redshift Interleaved sort keys in create table DDL
  • Added support for Redshift compound sort keys in create table DDL
  • Added support for Salesforce date functions like LAST_N_DAYS
  • Added ability to turn on ssl encryption when connecting to Redshift using the Redshift driver
  • Changes:
  • Change in how RazorSQL determines what query to execute when the cursor is after the statement separator but on the same line. Now, the previous query is executed. In the past, the next query was executed
  • Salesforce: Copy to local database uses actual Salesforce column sizes for character-based columns instead of default sizes
  • DynamoDB update statement: If a value is set to null in the update statement, the value is removed from the attribute in the DynamoDB item in the DynamoDB table
  • Cassandra: comments are automatically stripped from queries
  • Mac OS X 64-bit: Upgraded graphics libraries to the latest version
  • Bug Fixes:
  • Derby: columns not displaying in database browser for mixed case table names
  • Export command line interface. If specifying "insert" as the output type, the ending chars field is ignored
  • DynamoDB Database Browser: Trying to view a table that's name is an SQL keyword throws an error
  • Redshift sort and dist keys not always returned in generated DDL when when $user is present on the search_path
  • Redshift sort keys not always determined correctly when generating Table DDL
  • Refresh navigator preference value getting erased in certain Execute All situations

New in RazorSQL 6.4.8 (Apr 6, 2016)

  • Enhancements:
  • Added preference for specifying the maximum column width in query results cells
  • Changes:
  • Previous Vertica result sets are closed upon execution of new queries
  • Bug Fixes:
  • Vertica error messages not displaying properly
  • Database navigator not loading correctly when disconnecting and reconnecting a Vertica database
  • MySQL JDBC drivers versions 5.1.35 and newer not able to connect

New in RazorSQL 6.4.7 (Mar 11, 2016)

  • Enhancements:
  • Added ability to change text and background color of query results
  • Added ability to change text and background color of database navigator
  • Added more options to the "View Query" window
  • Changes:
  • Added support for connecting to Salesforce via TLSv1.1 and TLSv1.2 protocols

New in RazorSQL 6.4.6 (Mar 1, 2016)

  • Changes:
  • Increased default memory settings on Mac and Windows 64-bit versions
  • Bug Fixes:
  • Database navigator does not work with Cassandra version 3
  • Mac 64-bit: Value in Help menu Adjust Memory Settings box may not match what the actual max memory is set to

New in RazorSQL 6.4.5 (Feb 21, 2016)

  • Changes:
  • JSP, PHP and ASP Bridges: Added support for connecting to web sites with self-signed certificates
  • No row count related warning messages suppressed
  • Bug Fixes:
  • New plugins unable to be imported
  • Wrong ora18n.jar version getting set when connecting to older versions of Oracle
  • Import tool: Decimal values in Excel spreadsheets getting rounded in certain situations

New in RazorSQL 6.4.4 (Feb 4, 2016)

  • Enhancements:
  • Added ability to specify an approximate maximum number of rows to return from Salesforce queries
  • Added option to export tool for adding the schema name to the generated file name when exporting single or mutliple tables
  • Changes:
  • Removed the restriction of limiting Salesforce queries to 200000 rows if the Salesforce max rows setting is set above 200000
  • Bug Fixes:
  • Export Tool: Window is sometimes not centered on the screen when selecting certain options

New in RazorSQL 6.4.3 (Jan 26, 2016)

  • Changes:
  • Sybase Call Procedure Tool: Added support for timestamps as input
  • Command Line Connect Option: Added support for specifying the connection tab name as an additional parameter after the connection string
  • Maximum window size is no longer set when multiple monitors are present
  • Bug Fixes:
  • Create table on local database from query results not handling Oracle date values correctly

New in RazorSQL 6.4.2 (Jan 14, 2016)

  • Enhancements:
  • Added ability to launch RazorSQL with connection information specified on the command line in the following format: -connect "jdbcUrl|driverClassName|driverLocation|user|password"
  • Changes:
  • Redshift: Better recognition of when a column is a dist key
  • Salesforce: Better support for case-insensitive spelling of column names in join statements
  • Bug Fixes:
  • Paired foreign keys getting generated as two separate alter statements in the database conversion process

New in RazorSQL 6.4.1 (Dec 15, 2015)

  • Enhancements:
  • Added support for Redshift sorkey and distkey when generating Redshift table DDL
  • Added support for Redshift JDBC driver
  • Added auto-download support for the Redshift driver
  • Salesforce: Added support for additional timestamp formatting for Salesforce queries
  • Changes:
  • Better support for select into statements when using Redshift
  • Bug Fixes:
  • Oracle binary data editor - if table name is not in all upper-case - throws a table/view does not exist error
  • Objective-C compiler settings not correct for OS X Yosemite and El Capitan
  • Sorting query results and then trying to fetch all remaining rows after sort causes crash

New in RazorSQL 6.4.0 (Nov 23, 2015)

  • Enhancements:
  • Edit query window from query results tab is now a bigger window and has syntax highlighting
  • Added support for Derby version 10.12
  • Upgraded graphics libraries on Windows and Mac
  • Salesforce: Added support for querying using ALL ROWS
  • Changes:
  • Teradata: Updated driver class name on connection wizard to reflect recommended name instead of deprecated name
  • Better support establishing Cassandra connection
  • For users who upgrade, better handling of replacing old Oracle drivers with new Oracle drivers from connection profiles created with old versions of RazorSQL
  • Bug Fixes:
  • DB2 Copy to Local Database: Decimal column length not getting set correctly
  • Add connection profile - HSQLDB driver version listed incorrectly

New in RazorSQL 6.3.29 (Oct 23, 2015)

  • Enhancements:
  • PostgreSQL: Added a dropdown on the toolbar so users can switch between databases in the same RazorSQL tab
  • Changes:
  • MongoDB: ListDatabases role no longer needed to connect

New in RazorSQL 6.3.28 (Sep 30, 2015)

  • Enhancements:
  • MySQL Table Conversion: Auto increment columns now convert to PostgreSQL serial column
  • Oracle - added ability to get line number for SQL errors on select statements
  • Added a preference for whether to try to display Oracle error line numbers for select statements
  • Added ability to sort query results columns via turning on the sort query results columns preference

New in RazorSQL 6.3.27 (Sep 15, 2015)

  • Enhancements:
  • SQL Azure: Added support for generating / backing up procedures, functions, and triggers
  • SQL Azure: Added support for displaying indexes, constraints, and roles
  • Bug Fixes:
  • Copy to Local Database option for Salesforce and DynamoDB tables throwing errors for varchar columns
  • Mac OS X freezing issues

New in RazorSQL 6.3.26 (Jul 30, 2015)

  • Enhancements:
  • Added support for select count() queries for Salesforce
  • Bug Fixes:
  • Import Tool: Import create new table option not recognizing column headers in certain situations
  • Import Tool: Create new table creating table as default case object but insert statement generation using exact case
  • FTP client throwing error when no files / directories contained in initial directory

New in RazorSQL 6.3.25 (Jul 21, 2015)

  • Enhancements:
  • Added option for specifying encoding on Firebird connections
  • Added support for additional ciphers for SSH tunnels and SFTP connections
  • Bug Fixes:
  • Cassandra date formatting issues
  • Querying for boolean field in where clause does not work in DynamoDB.
  • When entering a value for a query parameter and saving the value in the session, the wrap in single quotes option not getting remembered when applying the value to future queries

New in RazorSQL 6.3.24 (May 28, 2015)

  • Bug Fixes:
  • Sybase Generate DDL for views not generating entire view statement
  • Sybase Generate DDL tool displays nchar and nvarchar columns as char and varchar
  • If "Executing . . ." window preference is turned off, focus does not stay in editor after executing query

New in RazorSQL 6.3.23 (May 11, 2015)

  • Enhancements:
  • Added support for displaying DynamoDB map type
  • Added support for displaying DynamoDB list type
  • Added support for DynamoDB boolean type
  • Changes:
  • MySQL - if get the no database selected error, display a more meaningful message to the user
  • Upgraded DynamoDB AWS library to the latest version
  • Text and Icon size auto-detection only scales text and images for resolutions larger than 1080p and now sets icon and text sizes to medium instead of large
  • Bug Fixes:
  • Statements starting with a SET command are always updated as an updated even if there are select statements in the statement block
  • PostgreSQL to MS SQL Server database conversion setting decimal / numeric length incorrectly in certain cases

New in RazorSQL 6.3.22 (Apr 28, 2015)

  • Changes:
  • Upgraded Mongodb driver to version 3
  • Upgraded Oracle JDBC drivers to the latest 12c version
  • Bug Fixes:
  • Mongodb version 3 authentication not supported
  • If user sets an icon or text size preference, and then sets it back to auto detect auto detect logic is not correct
  • DynamoDB: generated delete and update statements for tables with dots in the name throw errors

New in RazorSQL 6.3.21 (Apr 14, 2015)

  • Enhancements:
  • Added Icon Size menu to the view menu to allow users to change the size of icons
  • Added Text Size menu to the view menu to allow users to change the default text size
  • Changes:
  • For high-resolution displays, RazorSQL will automatically scale text and icons to a larger size depending on the resolution of the display
  • Bug Fixes:
  • Firebird database browser not showing columns for case sensitive tables
  • Set identity insert on not working on import tool if table being imported into is different than the current database

New in RazorSQL 6.3.20 (Apr 2, 2015)

  • Enhancements:
  • Added 2015 Amazon RDS SSL certificates to RazorSQL installation
  • Added support for more encyrption algorithms for SSH tool and SSL encrypted connections
  • Changes:
  • Changed default connection timeout to 35 seconds from 120 seconds
  • Bug Fixes:
  • MySQL connection properties: verifyServerCertificate property spelled incorrectly
  • Configure connection properties function on the add connection profile window not setting connection properties for the MS SQL Server driver

New in RazorSQL 6.3.19 (Mar 19, 2015)

  • Enhancements:
  • Added encoding option to command line export process
  • Changes:
  • Plus sign should be a special char that requires objects to be wrapped in quotes
  • Bug Fixes:
  • Browse buttons on command line call generator do not allow users to type in names of output files

New in RazorSQL 6.3.18 (Mar 5, 2015)

  • Enhancements:
  • MS SQL Server: On Windows, added the ability to connect using Windows authentication for the MS SQL Server JDBC driver
  • Added a Help -> Set System Property menu option to allow users to set system properties
  • Changes:
  • Start using newer version of MySQL driver for auto download version 5.1.34
  • SQL history now includes the current statement delimiter when storing the queries to history
  • If batch call size is 1, command line execute sql file process no longer uses the execute batch option on the driver
  • Bug Fixes:
  • Query Results Sort: PostgreSQL timestamptz values not sorting
  • Right-click menu on FTP Client sites list does not work on Linux
  • Right-click menu on file system browser path field does not work on Linux
  • DynamoDB - columns with the name of key should not be required to be quoted when written in queries

New in RazorSQL 6.3.17 (Feb 11, 2015)

  • Enhancements:
  • Add option to the Window menu for closing the current query results tab
  • Upgraded DB2 driver to the latest version (3.69)
  • Changes:
  • When exporting multiple delimited files and delimiter is a comma, name all files with a .csv extension
  • Oracle timestamps: Changed default format for Oracle timestamp columns to YYYY-MM-DD HH24:MI:SS.FFF
  • Added User Input Font option to the font dialog of the preferences window for changing the combo box fonts for tools in the Search menu
  • Bug Fixes:
  • Query referenced table option in query results not working for queries with quoted table names
  • Closing the font selection window sometimes changes the font without the OK button being pressed
  • Edit table tool. Edit query with a lot of results, the last row does not display in the edit table tool

New in RazorSQL 6.3.16 (Dec 16, 2014)

  • 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.15 (Dec 3, 2014)

  • Changes:
  • Upgraded SSH library - supports more ciphers and fixed bugs with connecting to SSH over non-standard ports
  • Changed settings for how RazorSQL sets statement fetch size for DB2 ODBC drivers
  • Bug Fixes:
  • Salesforce: includes query syntax throwing a parsing error

New in RazorSQL 6.3.14 (Nov 3, 2014)

  • Enhancements:
  • Add Reload option to right-click menu on sql editor tab for reloading the current file
  • Changes:
  • FTP Window needs to remember its size
  • Bug Fixes:
  • DynamoDB query bug introduced with previous version
  • Command Line Interface does not work with DynamoDB

New in RazorSQL 6.3.13 (Oct 20, 2014)

  • Enhancements:
  • Added Amazon Redshift support
  • Enable viewing of raise output in Netezza
  • Added support for Apache Derby 10.11
  • Bug Fixes:
  • Export Tool: If halt on export is unchecked, all export files / data not getting written
  • Save to FTP menu option not working
  • Cassandra: Can't always handle concurrent requests.
  • Changing the decimal separator in query results preference ignored for SQL Server and Sybase

New in RazorSQL 6.3.12 (Sep 23, 2014)

  • Enhancements:
  • Export Tool: Added an option to not halt on errors when exporting multiple tables
  • Added UCanAccess JDBC driver support
  • Allow user to change the location of the built in database
  • Command Line Interface all to pass all information to connect to the database on the command line Example: 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"
  • Changes:
  • Upgraded internal database from HSQLDB 1.8 to HSQLDB 2.3
  • Database conversion: When converting from a database with default upper case to a database with default lower case or vice versa, no longer wrap generated column names in quotes if they are not in the default case
  • Bug Fixes:
  • PostgreSQL function names not displaying in the database browser for certain PostgreSQL databases
  • DynamoDB: Errors occur if attributes are not present near the beginning of the table, but do have values later in the table
  • Query scheduler does not work with Salesforce
  • Generate SQL from query results with table name with a space not generating correct SQL
  • Salesforce - unable to query Case table due to SQL syntax error
  • Database Conversion: Boolean types getting converted to Oracle failing on insert

New in RazorSQL 6.3.11 (Aug 27, 2014)

  • Changes:
  • Mac 64-bit: Made changes to try to prevent RazorSQL from crashing and Window display issues caused by Karabiner keyboard customization software
  • Bug Fixes:
  • Export tool throws an error when exporting HSQLDB blob columns
  • Query results does not show HSQLDB blob columns in hex format

New in RazorSQL 6.3.10 (Aug 20, 2014)

  • Bug Fixes:
  • SQLite: Copy to Another Database. Table name not getting set to the new table name if a new table name is entered
  • Mac 64-bit Version: Crashing issues on some machines

New in RazorSQL 6.3.9 (Jul 29, 2014)

  • Enhancements:
  • Added ability to load binary data from a file via an insert statement with the razorsql_load_binary syntax insert into test_table values (1, razorsql_load_binary('C:\test.png'));
  • File System Browser search now prints out files results were found in
  • File System Browser search should search sub-directories
  • Added ability to delete inserts
  • Added ability to delete macros
  • Changes:
  • Describe Table Window should be resizable
  • Bug Fixes:
  • Home / End keys do not work in dialog text areas
  • SQLite: binary data editor sometimes throws errors
  • Drop database window has incorrect title
  • FTP Transfer window not showing file sizes correctly for very large files
  • Sybase: exec statements not always displaying results for all result sets returned by procedure
  • DynamoDB: querying binary columns throws error
  • Unable to create a connection using the RazorSQL JDBC Bridge with the "Other" database type
  • SimpleDB: when itemName is a column in the column list, the itemName column is not being populated
  • Sizing issues on Command Line Call Generator window

New in RazorSQL 6.3.8 (Jul 2, 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.7 (Jun 11, 2014)

  • Enhancements:
  • Salesforce: Added copy to local database option for Salesforce tables
  • Added Copy File Path option to File System Browser
  • Changes:
  • Import Tool: Create table from import - table names converted to default case for the database
  • Limit size of table references window in query builder to prevent window from going off screen
  • If there is an @ sign in table - wrap in quotes
  • Bug Fixes:
  • Database Conversion: Oracle to H2 and H2 to Oracle conversion files missing
  • Import Tool: Create table from SQL inserts - generated column names sometimes have spaces

New in RazorSQL 6.3.6 (May 23, 2014)

  • Enhancements:
  • DynamoDB: Added ability to force a query or scan operation using the select_query or select_scan syntax instead of just select select_query * from employee where id = 1
  • DynamoDB: Added ability to specify an index to use for a query operation using a query hint select_query /*index_name*/ * from table_name where . . .
  • DynamoDB: Enhanced logic to determine when to execute a query request and when to execute a scan request when query or scan is not indicated in select query
  • DynamoDB: added support for in clauses in SQL statements
  • DynamoDB: Import Tool: Added a checkbox for skipping columns / attributes in generated inserts when the value is null / empty
  • Added ability to set connection properties when using the MS SQL Server JDBC driver from Microsoft
  • Changes:
  • DynamoDB: support beginning comments in queries
  • DynamoDB: A non-descriptive error is thrown when referencing an attribute in an SQL statement that does not exist in the table
  • If SQL Server jtds connection fails for SSL reasons, and MS SQL Server driver is installed, try connecting with the SQL Server driver
  • Changed the formatting of the query error text to handle line wrapping better
  • Faster scroll speed on Explain Plan window
  • Bug Fixes:
  • If result columns are moved and put back in the same place - results editor throws error preventing changes due to columns being re-arranged
  • PostgreSQL: editing views taking a long time in certain situations
  • Query Builder: add table button window appearing behind the query builder on Mac
  • Query results edit table button not always appearing for supported queries when the queries have comments in them

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 11, 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 6, 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 16, 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 10, 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 21, 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 23, 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 25, 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 12, 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 12, 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 5, 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 23, 2013)

  • Changes:
  • Enhanced parametrized 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.5 (Jul 18, 2013)

  • Changes:
  • SimpleDB - More detailed error messages when incorrect select SQL syntax is used
  • Mac 64-bit version: Change configuration for graphics hardware acceleration
  • Bug Fixes:
  • Execute Procedure Tool: Does not support datetime types for SQL Server and Sybase
  • DDL Generator - Alter Table syntax - foreign keys that reference multi-column primary keys are not getting combined into one alter table statement
  • Clicking on certain menus causing currently selected tab to change 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.3 (Jul 4, 2013)

  • Bug Fixes:
  • Fix for MongoDB SQL parsing but introduced in version 6.1.1
  • Fix for MongoDB database data search bug introduced in version 6.1.1

New in RazorSQL 6.1.2 (Jul 2, 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.1 (Jul 1, 2013)

  • Enhancements:
  • Added SQL Create Table statement support for DynamoDB
  • Added support to generate Create Table statement DDL to DynamoDB database browser and DynamoDB backup and export tools
  • Added support for Derby 10.10
  • Changes:
  • For SQL Server and Sybase schemas node automatically expands when database is expanded in database browser
  • Allow using time formatting options on Oracle dates in the query results
  • Bug Fixes:
  • With dual monitors, Executing window and Find dialog window sometimes not showing on the correct monitor
  • View Menu custom keyboard shortcuts not always working in certain situations
  • When executing a long running query, and switch to another tab, and the first query finishes, the currently selected tab gets updated with the query results
  • Windows 7 and newer taskbar pinning of RazorSQL not using Windows standard behavior
  • In certain situations, the entire view definition is not being returned when generating SQL Server View DDL
  • Keyboard focus actions do not work on the add connection / connect window when the window is launched from an already connected tab
  • DynamoDB - SQL statements not handling columns with spaces correctly
  • DB2 for Mainframes database data search throwing error on SQL generated by the data search tool
  • Fixed certain crashing scenarios on Mac 64-bit only version for Lion and Mt. Lion

New in RazorSQL 6.1.0 (Jun 4, 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.5 (Mar 2, 2013)

  • Enhancements:
  • Added Copy Table to Another Database option in the DB Tools menu and on the database browser context menu
  • Added a Run on Local Server option in the Tools -> HTML menu
  • Bugs:
  • PostgreSQL Binary Data Editor not launching for tables in the public schema

New in RazorSQL 6.0.5 (Mar 2, 2013)

  • Enhancements:
  • Added Copy Table to Another Database option in the DB Tools menu and on the database browser context menu
  • Added a Run on Local Server option in the Tools -> HTML menu
  • Bugs:
  • PostgreSQL Binary Data Editor not launching for tables in the public schema

New in RazorSQL 6.0.4 (Feb 25, 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 30, 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 17, 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 5, 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 16, 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 3, 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 28, 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.5 (Sep 9, 2011)

  • Enhancements:
  • Added Derby 10.8 Driver download option
  • Added HSQLDB 2.2 download option
  • Changes:
  • For MS Access queries starting with line comments (--), RazorSQL now strips the line comments before executing the query
  • Bug Fixes:
  • SimpleDB import from file of SQL statements is throwing an error
  • Slashes in column name needs quoted
  • Only first 4000 chars are being displayed from SQL Azure procedures
  • Execute All statements option not working correctly

New in RazorSQL 5.5.4 (Aug 22, 2011)

  • Enhancements:
  • Compare Tool: Added option to write compare results to file
  • Command Line Interface: Added option for comparing the results of two queries
  • Added support for DB2 VSE
  • Compare Tool: maximum compare lines is now configurable via the preferences
  • Changes:
  • Command Line Interface: For SQL Server and Sybase connection profiles that do not have a database set, the command line tool now executes a use command based on the database specified as a command line option
  • Bug Fixes:
  • Informix select into temp table queries throwing errors
  • SimpleDB command line - create domain statement throwing error
  • Import from Excel - fill with empty data checkbox not displaying
  • Procedure Editor compile error window - if error message is too long, text gets cut off
  • Query Results - when user resizes columns, column width getting reset after scrolling

New in RazorSQL 5.5.3 (Jul 13, 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.2 (Jun 17, 2011)

  • Enhancements:
  • Import Tool: Added insert or ignore and replace syntax options for statements generated by the import tool for MySQL and SQLite
  • Export and Backup Tools: Added insert or ignore and replace syntax options for statements generated by the export and backup table and database tools for MySQL and SQLite
  • Export and Backup Tools: Added option to generate multi-value / multi-row insert statement syntax instead of one insert statement for each row being inserted for Derby, DB2, MySQL, PostgreSQL, and SQL Server
  • Improvements to load time performance
  • Added Window - Focus in database navigator option to the Window menu
  • Added Tools - PHP - Execute Program option
  • Added Tools - PHP - Check Program Syntax option
  • Added Tools - Perl - Check Program Syntax option
  • Added Tools - Ruby - Check Program Syntax option
  • Changes:
  • Added validation to the import and export tool to require a database and / or schema to be entered if required by the database
  • Bug Fixes:
  • Oracle database navigator loads slowly on some systems
  • Control-click does not bring up context menu on Mac for the database browser
  • Windows context menu keyboard key does not bring up the context menu
  • Comments in front of a query can cause edit table tool to remove the where clause when launching

New in RazorSQL 5.5.1 (Jun 3, 2011)

  • Enhancements:
  • Added drag and drop support for dragging items from the database navigator to the SQL editor and query results section
  • Added a View as Image option to the right-click menu of the query results cells for cells containing binary data
  • Edit Table Tool: Added support for inserting and updating binary data in hex format
  • MySQL: binary data editor now also supports longblob, mediumblob, tinyblob, and long varbinary columns
  • PostgreSQL - binary data editor now supports the bytea data type
  • Added copy column name to editor option on the right-click menu of the query results column heading
  • Added a decimal separator preference
  • Added comma, tab, and spaced delimited file output options to the query scheduler
  • Added a View as Image option on the binary data editor
  • Results SQL Generators - added ability to display binary data in hex format in generated SQL
  • The backup tool can now store binary data in hex format
  • The export tool now stores data in hex format for the SQL Insert export type
  • Added an option to import tool for SimpleDB about whether to tie null/empty values to the attribute.
  • Added support for the SQLiteJDBC driver
  • Added Greenplum to the list of supported connection types
  • Added preference so that the SimpleDB multi-value separator can be customized
  • Added the ability to escape the SimpleDB multi-value separator to be able to insert text in one value that contains the separator
  • Added preference for whether or not to enabled database navigator drag and drop
  • Added a preference for whether or not to display binary data in query results
  • Added a preference for whether or not to convert binary data to hex in query results
  • Added support for sorting Oracle timestamp columns in the query results
  • Changes:
  • Database Browser: Changed the method for getting schemas, tables, views, system tables, columns, and keys for Sybase IQ and SQL Anywhere
  • Database Browser: Changed the query to get Sybase IQ 12 procedures
  • Database Browser: Changed query to get databases for SQL Server 2005 and 2008
  • Database Browser: Changed query to get schemas for SQL Server 2005 and 2008
  • Removed Mckoi from database list in the add connection profile tool
  • Bug Fixes:
  • PostgreSQL Drop Function tool, column parameter list incorrect for Functions with multiple parameters
  • select into statements displaying error on certain databases
  • When a SimpleDB domain does not yet have any attributes, and the Edit Domain tool is launched, the process to add initial attributes to the domain is not working
  • Sybase IQ and Sybase SQL Anywhere alter table drop column syntax not correct
  • View menu shortcuts not working until view menu is displayed for the first time
  • Sybase binary data editor only works for image columns, not varbinary and binary columns

New in RazorSQL 5.5.1 (Jun 3, 2011)

  • Enhancements:
  • Added drag and drop support for dragging items from the database navigator to the SQL editor and query results section
  • Added a View as Image option to the right-click menu of the query results cells for cells containing binary data
  • Edit Table Tool: Added support for inserting and updating binary data in hex format
  • MySQL: binary data editor now also supports longblob, mediumblob, tinyblob, and long varbinary columns
  • PostgreSQL - binary data editor now supports the bytea data type
  • Added copy column name to editor option on the right-click menu of the query results column heading
  • Added a decimal separator preference
  • Added comma, tab, and spaced delimited file output options to the query scheduler
  • Added a View as Image option on the binary data editor
  • Results SQL Generators - added ability to display binary data in hex format in generated SQL
  • The backup tool can now store binary data in hex format
  • The export tool now stores data in hex format for the SQL Insert export type
  • Added an option to import tool for SimpleDB about whether to tie null/empty values to the attribute.
  • Added support for the SQLiteJDBC driver
  • Added Greenplum to the list of supported connection types
  • Added preference so that the SimpleDB multi-value separator can be customized
  • Added the ability to escape the SimpleDB multi-value separator to be able to insert text in one value that contains the separator
  • Added preference for whether or not to enabled database navigator drag and drop
  • Added a preference for whether or not to display binary data in query results
  • Added a preference for whether or not to convert binary data to hex in query results
  • Added support for sorting Oracle timestamp columns in the query results
  • Changes:
  • Database Browser: Changed the method for getting schemas, tables, views, system tables, columns, and keys for Sybase IQ and SQL Anywhere
  • Database Browser: Changed the query to get Sybase IQ 12 procedures
  • Database Browser: Changed query to get databases for SQL Server 2005 and 2008
  • Database Browser: Changed query to get schemas for SQL Server 2005 and 2008
  • Removed Mckoi from database list in the add connection profile tool
  • Bug Fixes:
  • PostgreSQL Drop Function tool, column parameter list incorrect for Functions with multiple parameters
  • select into statements displaying error on certain databases
  • When a SimpleDB domain does not yet have any attributes, and the Edit Domain tool is launched, the process to add initial attributes to the domain is not working
  • Sybase IQ and Sybase SQL Anywhere alter table drop column syntax not correct
  • View menu shortcuts not working until view menu is displayed for the first time
  • Sybase binary data editor only works for image columns, not varbinary and binary columns

New in RazorSQL 5.5.0 (Apr 15, 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 26, 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 12, 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.3 (Oct 1, 2010)

  • Enhancements:
  • Increased performance when viewing contents on SQLite tables
  • Increased performance when SQLite queries produce a large number of results
  • Added a CLOB data editor for Oracle
  • Added DB2 explain plan support for DB2 on z/os
  • When using the execute all option for SQL Server and Sybase, the View Print Output option displays output from all of the statements executed, not just the last statement
  • Added .htaccess / Basic Authentication support for the MySQL PHP Bridge, the PostgreSQL PHP Bridge, the MS SQL Server PHP Bridge, and the MS SQL Server ASP Bridge
  • Added option for whether to include MS SQL Server identity columns in generated SQL insert statements for the Export, Backup Table, and Backup Schema tools
  • Included sqlite program for 64-bit linux
  • Changes:
  • Changes in DDL Generator tool for MS Access using third-party drivers to clean up errors in generated DDL caused by driver problems
  • Bug Fixes:
  • SQL History not being saved in more recent versions
  • Cancelling a statement via certain ODBC drivers sometimes crashes RazorSQL
  • Execute All not parsing statements correctly when there is a single quote inside of a single line comment in query text
  • Generate DDL - primary key column with spaces not being wrapped in quotes
  • Running delimiter statement on SQLite connection causes executing query window to display and not go away

New in RazorSQL 5.2.2 (Sep 16, 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 24, 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 8, 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 22, 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 14, 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 14, 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 25, 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 17, 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:
  • 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 5.0.5 (Jan 18, 2010)

  • Enhancements:
  • Edit Table Tool: Added wrap lines button for the Edit in New Window option.
  • Edit Table Tool: Resizing "Edit in New Window" window resizes the edit area.
  • Changes:
  • Query Results: View row in column mode was parsing HTML text.
  • Bug Fixes:
  • Create Index Tool throwing an error about not being able to get column names.
  • Informix Alter Table - incorrect syntax on add constraint clause.

New in RazorSQL 5.0.4 (Jan 13, 2010)

  • Enhancements:
  • Query Builder: Added search table option for building database search queries
  • Query Builder: Automatically formats values entered when in or not in is used
  • Query Results: Clicking on a row number in the query results now selects the entire row
  • Query Results: Added Select Column option to right-click menu of query results column heading
  • Query Results: Added Edit Cells to Results menu
  • Query Results: Added Re-execute query item to the Results menu
  • Query Results: Added Save / View Cell Edits to Results Menu
  • SQL Favorites: Added mnemonics to SQL favorites menu
  • Export: Added options for generate fully qualified table name to export data, export schema, etc. tools
  • Editor: Added Search API reference option for PHP, Perl, and Python
  • Editor: Added API reference links for CSS, HTML, Java, Objective-C, PHP, Perl, Python, Ruby
  • Editor: Find in Files allows finding of text with line breaks
  • Editor: Replace in Files allows replacing of text with line breaks
  • Editor: Find / Replace in Open Editors now allows find / replacing text with line breaks
  • Editor: Added an Objective-C compile option for Mac
  • Editor: Added an Objective-C execute program option for Mac
  • Editor: Added Objective-C syntax highlighting support
  • Editor: Added an Objective-C Function / Method navigator
  • Editor: Added an Objective-C Sidekick
  • Editor: Added Objective-C code inserts
  • Editor: Added Objective-C templates
  • Editor: Added C and C++ code inserts
  • Editor: Added Scala syntax highlighting support
  • Editor: Added a Scala Function / Method navigator
  • Editor: Added a Scala Sidekick
  • Editor: Added Scala code inserts
  • Editor: Added Scala templates
  • Editor: Added COBOL code inserts and hello world template
  • Editor: Added code inserts for Ada, ASP, Batch, and Groovy
  • Editor: Added a compress files option to the file system browser for compressing files and directories in zip format
  • Editor: Added Emacs keyboard shortcuts on the Mac for down, up, right, left, end of line and beginning of line
  • Editor: Added a split file tool to the File System Browser and File - Tools menu to for splitting files into smaller files
  • Editor: Escape key can now be pressed to close most windows opened by RazorSQL
  • Editor: .plist files are now recognized as xml types
  • Editor: Execute Program enhancements
  • Changes:
  • Set default button on filter query results
  • Allow function keys to be used in keyboard shortcuts
  • Added notes to Sort and Filter tools that only retrieved / displayed results are filtered or sorted
  • Query Builder: If no operator is selected, default is set to AND
  • Execute SQL: Parsing Change: if text starts with a function or procedure creation call, and there are multiple semi-colons, execute SQL will not parse editor by semi-colons when deciding what statement to execute, will send the entire contents of the editor
  • Linux Launch Script: if can't launch with internal JRE, search the system for one
  • Query Builder and Data Search Tool - Relaxed requirements on forcing table reference selections when adding tables
  • Hitting the delete key on the file system browser now deletes the file
  • If selected text has line breaks, when bring up either find in editors or find / replace, pre-select the tabs / line breaks button
  • Re-organize the search menu so all of the Find / Replace options are together
  • Add mnemoics for Start Recording and Stop Recording in the macro menu
  • Put the insert selector items in alphabetical order
  • Add Custom to the insert file type selector for the insert select tool
  • Editor: If word wrap is on, copying text to a text file does not get wrapped, only when typing it
  • Editor: If word wrap is on, opening a new text file does not wrap the text
  • File System Browser: can now copy a file to the same directory as long as a different name is provided
  • Editor: Double-click on a word in PHP file now also selects the dollar sign
  • Editor: Double-click on a word in a Perl file now also selects the dollar sign, at sign, or mod sign
  • Editor: Double-click on a word in a Ruby file now also selects the dollar sign and at sign
  • Editor: Edit - Delete - Delete Line now deletes line plus ending line break
  • Editor: Edit - Select - Select Line now selects line plus ending line break
  • Editor: Triple click now select line plus ending line break
  • Bug Fixes:
  • SQL Server - tinyint field in generated DDL in Copy table tool and generate ddl tool should not display a size
  • SQLite: Doing a join on two tables with same column names returning column values from first table only
  • SQL Server Generate / View DDL - Identity option not being shown in the DDL
  • MS Access - in generated SQL updates, selects, and deletes, datetime columns should be wrapped in # sign instead of single quotes
  • Getting result set is closed error when exporing MS Access query results
  • Import connection profiles, if no profiles exist on the machine, throws an error
  • Query results tab name not handling beginning comments in queries when determining table name to display
  • Oracle - if the beginning of the select statement is a comment, RazorSQL is not stripping the ending semi-colon.
  • If no rows or columns selected in query results, edit table tool will not launch
  • Query Check Permissions functionality not factoring in commented lines
  • Editor: HTML validator returning one too many for warning count
  • Editor: Text - Insert text at column - error for please enter a column greater than zero when entering 1 as the column number
  • Editor: Copy Lines Containing window displays Cut in the text instead of Copy
  • Editor: Make sure control / command click deselects an already selected item on the file system browser
  • Editor: Home and End keys not working correctly on Mac
  • Editor: Copying from windows formatted file on a Mac system causing double-spaced lines

New in RazorSQL 5.0.3 (Dec 3, 2009)

  • Changes:
  • Create Table Tool, on first screen, added Initial Columns (optional) option.
  • Better support for machines with locked down user directories.
  • SQL Editor: PL/SQL - better recognition of code blocks.
  • SQL Editor: When the syntax highlighting type is SQL, not always executing Oracle blocks correctly.
  • SQL Editor: Oracle - If / is on a line by itself and nothing is highlighted, execute until the /
  • Bug Fixes
  • Oracle compile not showing errors if procedure name has quotes around it.
  • If the reserved word from is used as a column name, it is not getting wrapped in quotes in the create table tool, alter table tool change column type, or query builder.
  • Multiple scroll bars displaying on the rename table and add sequence trigger options of the alter table tool.
  • Execute all not parsing queries correctly when a semi-colon is inside of a string.
  • Query parsing problems when the statement delimiter is semi-colon and semi-colon is quoted.
  • Query results not displaying correctly if results are in HTML format.
  • View row in column mode width should resize automatically based on column size.

New in RazorSQL 5.0.2 (Nov 19, 2009)

  • Changes:
  • SQL Editor: .plist files now recognized as an XML type
  • Double-clicking query results cells now prompts for whether to launch edit table tool or edit cells locally on first double-click
  • Auto table lookup values are now cached
  • Left-click followed by a right-click in the query results on Macs is no longer handled as a double-click
  • When editing query cells, if no rows are updated by the edit, a message is shown to the user
  • Auto table and auto column lookup now check if there was any typing done since the lookup was initiated. If there was, the displayed values list is filtered baesd on the typed values
  • Bug Fixes:
  • Query results toolbar on Windows XP and earlier - buttons getting cut off.
  • Fixed load errors on machines with unwritable user home directories
  • Clicking cancel when launching the edit table tool not keeping the edit table window from displaying
  • Info.plist change on Mac to prevent warning about CFBundleTypeRole entry in the console
  • Generate SQL from query results tools not escaping apostrophes in generated SQL
  • Slow help menu display performance on OS X 10.6 Snow Leopard

New in RazorSQL 5.0.1 (Nov 13, 2009)

  • Enhancements:
  • Added column mode for query results for viewing results row data vertically.
  • Added Select Row option to right-click menu of query results cells.
  • Use the sorted query results when launching the edit table tool from query results.
  • Use the filtered query results when launching the edit table tool from query results.
  • Added preference for whether or not to sort auto column lookup values.
  • Added the ability to rename the query tab.
  • Changes:
  • If there is an order by on the query, keep the order when launching the edit table tool.
  • Bug Fixes:
  • Switching tabs causing query results edit mode on/off box to expand.
  • Edit Table Tool - When hitting save and the table doesn't have any keys should prompt the user to select keys.
  • OTHER option in database Add Connection wizard not working.
  • Edit Table tool and Export tools not always getting correct table name from query for queries with certain formattings.

New in RazorSQL 5.0 (Nov 11, 2009)

  • Enhancements:
  • Added Database Object Search tool in Search -> Database Object Search menu option
  • Database Search Tool: Users can now add multiple tables and additional criteria to the search tool
  • Added ability to directly edit query results for qualifying queries (select * from a single table variants)
  • Added Oracle PL/SQL Auto completion for built-in packages and procedures
  • Added Transact-SQL auto completion for system procedures
  • Added SQL Generation options via the Results Menu for generating SQL select, update, insert and delete statements for the selected query results
  • Added Import and Export connection profiles option
  • Added a Copy Table tool via the DB Tools -> Copy / Backup menu option
  • Added Code menu with programming tools for various programming languages such as SQL, PL/SQL, Transact-SQL, Java, XML, PHP, HTML, JavaScript and many more. Options include coding sidekicks, code builders, code inserts, etc.
  • Added uncomment option to Code menu
  • Added soft tab (emulate with spaces) option in the editor preferences
  • Escape button can now be used to close almost all windows / dialogs opened by RazorSQL
  • Export Tool: Now automatically sets file name and extension based on export type and export table
  • Added How to Guides in the help menu
  • Generate DDL Tool: Added procedures, functions, triggers, packages, and package bodies
  • Alter Table Tool: Added change column data type / size for most databases
  • Create Table Tool: Added enhancements for ease of use
  • Database Browser: Added View Contents (Limit Results) 100, 1000, and 10000 for MySQL, PostgreSQL, Oracle, DB2, Derby, SQL Server, and Sybase
  • Database Browser: Added a Get Info option for the MySQL users section
  • Query Results: Added Copy As Date option to right-click option of query results for Oracle
  • Query Results: For Oracle, added support for many NLS_DATE_FORMAT options, and better default display
  • Query Results: Enhancements to Oracle timestamp formatting - support for default timestamp formatting conversion
  • Added Oracle date and timestamp formatting preferences
  • Informix: Added support for displaying Set, MultiSet, and List data types
  • Stored Procedure Editor: Editing stored procedures / functions now brings up a new tab specific to procedure editing
  • Stored Procedure Editor for SQL Server stored procedures and functions now generates alter statements instead of drop and create statements
  • Upgraded HSQLDB drivers to 1.8.10
  • SQL Editor: When the statement delimiter is semi-colon, semi-colons can now be entered inside strings
  • H2 ease of use enhancements to the add connection profile tool
  • Added auto-download option for the H2 database in the add connection profile tool
  • Ease of use enhancements to the add connection profile wizard
  • Add Connection Profile: Can now connect to MS SQL Server instances by either appending instance_name onto either the host or the database name
  • Added a preference for specifying whether to continue execute statements when an error occurs using the Execute All option
  • Export Data Tool: Enhanced default selections based on the export type
  • Export Data Tool: Added extra screen to the process for better readability
  • Export Data Tool: Added a re-execute query before exporting option when exporting query results
  • Added SQL Execute All Statements enhancements
  • Added recordable macros available in the Tools menu
  • Added various HTML programming tools such as HTML color chooser, HTML validator, HTML tidy tool, and HTML entities selector
  • Added CSS style builder, tag navigator, and validator
  • Added Perl programming language tools
  • Added PHP programming language tools
  • Added Python programming language tools
  • Added Ruby programming language tools
  • Added XML tools such as an XML validator and XML tree view option
  • HSQLDB: Can now use other drivers other than the default HSQLDB driver included with RazorSQL
  • Apache Derby: Can now use other drivers other than the default Derby driver included with RazorSQL
  • Changes:
  • Menu Changes: added new menus and renamed and re-organized other menus
  • Query Results: If using right-click button on mouse and no cells are selected, select the results cell when right-click is pressed
  • Edit procedures, functions, triggers - now displays drop option in commented text
  • In edit procedure tab - if no highlighted text, execute entire window If highlighted text, execute highlighted text only
  • The create procedure / function tool now opens its own tab defaulted to the procedure editor settings
  • DB2 schemas in display and generated SQL no longer contain spaces
  • Remove the batch mode and single statement mode from the edit table tool It is always one statement at a time now
  • Changed Execute All to never run in batch mode and to show a progress bar of queries executed
  • For MySQL, change Call SHOW CREATE to Generate DDL (SHOW CREATE) followed by Generate DDL (Manual)
  • Better date handling on query results sorting
  • Better date handling on query results filtering
  • Force users to select a join column in the query builder and database search objects when adding multiple tables with no foreign key references
  • Updated link to Teradata driver download page
  • Execute SQL - Now looks for GO if there are no semi-colons for SQL Server and Sybase when using default statement separators
  • For SQL Server and Sybase - if the query getting executed ends with "GO", and the statement separator is not GO, remove the GO from the end
  • Bug Fixes:
  • SQLite: occasional errors getting SQLite version leading to invalid warning messages about driver compatibility
  • Export Util: Deselecting the include column names checkbox now also works with the SQL Insert Statement export option
  • PostgreSQL Drop Function tool generating incorrect syntax for functions with parameters
  • Edit procedure, function, trigger etc. on Mac causing menu disappearing problem on latest versions of OS X
  • select * into statements throwing error messages on certain databases
  • Query builder not generating where clause in select tab for IS NULL and IS NOT NULL column operator selections
  • Import Tool - Do not require table name if importing from a file of SQL statements
  • Cancel button on save changes dialog closing the tab on certain jdk versions
  • Drop column syntax incorrect for Sybase - should not say column
  • DB2 - Generate DDL - decimal not generating size correctly. Generating 0
  • Informix - Generate DDL - Do not include sizes for ints
  • Create Index Tool: When typing in a table name that does not exist, no error is thrown
  • SQLite: Alter table options that are not supported by SQLite are displayed in the alter table tool
  • SQLite: Generate DDL .schema on an object - when trying to just get table ddl, returning additional information
  • Export query results as insert statements throwing result set closed error
  • Oracle / DB2 - If statement separator preference is not semi-colon, not always recognizing the statement separator for PL/SQL or SQL PL blocks
  • MySQL and Oracle - Procedures / Functions sometimes show in schemas / databases that do not own the procedures / functions
  • MS Access - drop view is not implemented - should be drop table
  • Firebird Generate DDL not generating column name in foreign key references clause

New in RazorSQL 4.5.15 (Aug 25, 2009)

  • Bug Fixes - MySQL views not showing in database navigator.

New in RazorSQL 4.5.14 (Jul 30, 2009)

  • Enhancements:
  • Updated DB2 driver.
  • Updated PostgreSQL driver.
  • Changes:
  • Removed shipped drivers for certain databases due to lack of users.
  • Allow changing menu display preferences in Info.plist.
  • Bug Fixes:
  • Fixed problems with Java update 4 causing various display issues with menus.

New in RazorSQL 4.5.13 (Jul 13, 2009)

  • Enhancements:
  • Added Triggers to the list of objects that RazorSQL will show compilation errors for in Oracle.
  • Added copy, cut, and delete all bookmark lines option.
  • Changes:
  • If the max rows preference is set, close any statement and result set when the max rows preference is retrieved.
  • If using the fetch all results option, close the statement and result set after execution.
  • Check for maxed out result sets and close accordingly.
  • Bug Fixes:
  • Oracle Compile Errors not always displaying when creating / altering Oracle procedures, functions, packages, or package bodies.

New in RazorSQL 4.5.12 (Jul 8, 2009)

  • Enhancements:
  • Added SQL Favorites tools and a Favorites Selector to the SQL menu.
  • View SQL History and View Query Log now open a new tab with a shared connection to the currently active connection tab.
  • Added a View Contents (Fetch All Rows) option to database navigator for tables and views.
  • Allow direct access to Access 2007 .accdb files via the ODBC direct method.
  • Changes:
  • DB2 - Append For Read Only onto applicable select queries to reduce locking.
  • Error message windows are now non-modal.
  • Escape key now closes error message windows.
  • Edit tool for procedures, functions, and triggers now inserts semi-colons after drop and create statements.
  • Changes to application launcher such as allowing multiple versions of RazorSQL.

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 19, 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 12, 2009)

  • Enhancements:
  • 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 23, 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.5 (Apr 15, 2009)

  • Enhancements:
  • SQL Editor - Added Auto Completion (Tools - Auto Complete menu option, Auto Complete toolbar button, and keyboard shortcut) for autocompletion of tables and columns.
  • Query Results - Added Search - Find in Query Results to Search Menu and added a corresponding button to the query results toolbar for doing advanced query result searches.
  • Connection Manager - Included JTOpen DB2 driver for AS/400 and iSeries JDBC connections.
  • Added SQLite create database tools.
  • Enhanced PostgreSQL create user tool to include valid until, createdb, createuser, group, and encrypt password options.
  • Added copy query to clipboard option on the query result set tab menu.
  • Added replace editor contents with query to the query result set tab menu.
  • Added ability to filter MS SQL Server and Sybase Schemas / Owners to the Database Navigator.
  • Added a confirmation dialog when closing RazorSQL and an associated preference to turn this on / off.
  • Changes:
  • DB2 Database Browser - All tablespaces are returned in browser regardless of schema / owner.
  • Windows: Upgraded JRE to 1.6.0_13.
  • Ability to override RazorSQL home directory by setting the razorsql.home System property.
  • Change File - Make Backup to File - Backup Editor File to avoid confusion.
  • Changed search menu text to prevent confusion between query result search and editor search.
  • Bug Fixes:
  • MS SQL Server View definitions over 4000 chars getting truncated in the Alter View and Generate DDL tools.
  • Function List tool does not display PHP functions located inside of a class.
  • Match word in the Find / Replace tool does not apply the whole word criteria when there is only one word in the text.
  • Select Previous word on Mac has incorrect keyboard shortcut.

New in RazorSQL 4.5.4 (Apr 7, 2009)

  • Edit Table Tool: Edit Cell in New Window button not always applying changes to the screen.
  • Edit Table Tool: Edits in New Window checkbox value not always being remembered correctly.

New in RazorSQL 4.5.3 (Apr 1, 2009)

  • Enhancements:
  • Added Netezza to the list of supported databases.
  • Added .war and .ear files to the list of files supported by the Zip utility.
  • Added Edit - Text - Insert Text at Column option.
  • Find / Replace in Files tool - results can now be copied to the text editor.
  • Changes:
  • Upgraded built in Derby driver to 10.4.2.
  • Next word and Previous word options now skip white space.
  • Bug Fixes:
  • Derby embedded connections sometimes fail when Derby is not the first database connected to after launching RazorSQL.
  • Java method lookup - performing slowly for certain classpath configurations.

New in RazorSQL 4.5.2 (Mar 5, 2009)

  • Enhancements:
  • Database Navigator: Load time performance improvements for Oracle and MS SQL ServerDatabase Navigator: Added preference for whether or not to cache top level navigator objects on re-launch.Database Navigator: Added preference for whether or not to cache top level navigator objects on re-launch only if load time is more than a certain threshold.Import Tool: Added an option to insert empty data if there are not enough delimited values in a delimited file for a given row, or not enough cells in an Excel file for a given row.Connection Wizard: Added 11G OCI option to Oracle connection screen.
  • Changes:
  • Oracle: Better handling on Oracle Long and Long RAW data
  • Bug Fixes:
  • SQL Server Database Navigator: Information schema views display under the views section for owners with no defined viewsFrontBase Connection Wizard: A database password should not be required to connect to FrontBase.

New in RazorSQL 4.5.1 (Feb 19, 2009)

  • Enhancements:
  • Edit Table Tool: Added a copy row option.
  • Edit Table Tool: Added auto-scroll functionality when editing a cell from the query results.
  • Edit Table Tool: Added the ability to move left and right from cell to cell with the arrow keys.
  • Export Tool: Added functionality to export tool CSV option to ensure proper wrapping and escaping of double-quotes for the following situations Line Breaks in data, quotes in data, data begins or ends with spaces.
  • DB2 Database Browser: Added Buffer Pools.
  • DB2 Database Browser: Added Tablespaces.
  • Oracle Database Browser: Performance enhancements.
  • Added QuickBooks QODBC support.
  • SQL Editor: Added ability to change editor background and default text colors.
  • SQL Editor: Added Edit - Cut Lines Containing option.
  • SQL Editor: Added Edit - Copy Lines Containing option.
  • SQL Editor: Added Search - Replace Until option.
  • SQL Editor: Added Search - Replace After option.
  • SQL Editor: Added ASP syntax highlighting support.
  • SQL Editor: Added ASP function browser.
  • SQL Editor: Added home and end keys to the edit menu and allow keyboard shortcut customization for them.
  • File System Browser: Added ability to change background and default text colors.
  • SQL Formatter: Added SQL Formatter keywords to text files in the data directory. Users can modify these files to change the behavior of the formatter.
  • Query Builder: Added select all columns button to insert option of query builder.
  • Changes:
  • Database Search: Column names are now sorted in selection window.
  • Mac: word skipping option now option right and option left key combination.
  • Mac: Command left and command right now go to begin and end of line.
  • Import Tool: Added message that displays when the import has finished.
  • Import Tool: If the number of import rows is less than 1000, default to the one row at a time option.
  • SQLite: On Macs, RazorSQL now uses UTF-8 to communicate with SQLite.
  • Upgraded Deju Vu fonts to the latest version.
  • MS SQL Server Database Browser: Changed the way RazorSQL retrieves owners / schemas.
  • SQL Editor: Warn if modified preference now turned off by default.
  • SQL Editor: Added code to help ensure editor grabs focus when applicable.
  • SQL Editor: Changed default font settings for non-English locales.
  • Edit Table Tool: Now defaults to query results font.
  • Edit Table Tool: When adding a row, first column in the row now grabs focus.
  • Added more informative error message when getting errors querying Sybase tables with no primary keys using a custom fetch size.
  • Bug Fixes:
  • If attempting to connect to a MySQL database that is not running, an invalid error message is being displayed.
  • Import as batch option not always displaying error message if batch process had an error.
  • Query builder add table button not displaying views.
  • Export - When exporting query results from a query with a where clause, the where clause is not factored in when doing the export.
  • Edit Table Tool - double-clicking on a value in the query results not always setting the corresponding cell as editable in the edit table tool.
  • Edit Table Tool - inserting rows beyond the max row count causing errors.
  • Occasional graphics painting problems on Windows Vista in query results headers and in values when scrolling.

New in RazorSQL 4.5.0 (Dec 17, 2008)

  • Enhancements:
  • Tools: Added Tools - Generate DDL option for generating DDL for tables, views, and indexes contained in schemas or databases.
  • Import Tool: Added ability to create an output file of the generated SQL insert statements
  • Import Tool: Added ability to import from a file of SQL statements
  • Import Tool: Execute as batch now takes a parameter for the number of statements to make per batch network call
  • Import Tool: Added progress bar that displays percent complete while importing
  • Import Tool: Added option for saving to file only
  • Import Tool: New method for handling delimited files with line breaks or delimiters in between delimiters.
  • Import Tool: Added halt on error option.
  • Describe Tool: Added DDL tab for displayed table DDL
  • Database Browser: Added Generate SQL menu for generating select, select *, insert, update, and delete statements for the selected table or view.
  • Database Browser: Added Search menu option for searching tables.
  • Database Browser: Added Generate DDL option for generating DDL for tables, views, and indexes.
  • Database Browser: H2: Added indexes and sequences to the database browser.
  • Database Browser: Teradata: Added indexes and triggers to the database browser.
  • Database Browser: Pervasive: Added triggers to the database browser.
  • Database Browser: InterBase: Added indexes and sequences to the database browser.
  • Database Browser: InterBase: Added triggers, functions, and users to the database browser.
  • Database Browser: Sybase: Enhanced query for getting procedures.
  • Database Browser: Added show infor queries for Teradata, InterBase, and H2.
  • Export Tool: Improved memory usage when exporting multiple tables to a single file
  • Export Tool: Command line export - added convert nulls to blanks option
  • Export Tool: Added progress bar and exported row status.
  • SQL Editor: Added database selection drop down for Teradata
  • SQL Editor: Added schema selection dropdown for DB2
  • SQL Editor: Added schema selection drop down for Oracle
  • SQL Editor: Added combine files tool.
  • SQL Editor: Syntax highlighting enhancements.
  • H2: Add ability to create indexes and sequences
  • H2: Add ability to alter view
  • H2: Add ability to drop indexes and sequences
  • Teradata: Added create index tool and drop index tool
  • Teradata: Added create, edit, and drop tools for procedures and triggers
  • Pervasive: Dropdowns for selecting a database are now pre-populated with the current database.
  • Pervasive: Added ability to edit procedures and view procedure contents.
  • Pervasive: Added ability to edit triggers and view trigger contents.
  • InterBase: Added ability to create indexes and sequences.
  • InterBase: Added ability to alter views.
  • InterBase: Added ability to drop indexes and sequences.
  • InterBase: Added ability to create procedures and triggers.
  • InterBase: Added ability to drop procedures and triggers.
  • InterBase: Added ability to edit procedures and triggers.
  • File System Browser: Added performance and other enhancements.
  • Edit Table Tool: Added copy to editor button for generated SQL.
  • Edit Table Tool: Generated SQL now has syntax highlighting.
  • Create Table Tool: Common data types are now pre-selected for column data types.
  • Plugin API: Added new methods to the Plugin API.
  • Added support for the Oracle XMLType data type.
  • Connection Wizard: Added additonal help documentation links to the connection wizard.
  • Changes:
  • SQL Editor: Anti-aliasing now defaults to on for the SQL Editor.
  • SQL Editor: Auto complete now accepts the "tab" key to select and close the auto complete window.
  • SQL Editor: Auto Complete: SQL Server and Sybase auto complete makes sure to pass in current schema or database to improve performance.
  • Import Tool: Added messages about not supporting .xlsx files.
  • Import Tool: File size checks are run on Excel files before importing.
  • Import Tool: The command line option now executes statements in batches of 100. The specific number can be changed via the last argument passed to the import tool.
  • Import Tool: Default parse option is now "Advanced Mode".
  • Connection Wizard: Added SQL Server 2008 to the list of supported dbs for the built-in JDBC driver option.
  • Database Browser: Removed the download link to the Solid JDBC driver (download is no longer available after IBM purchase)
  • Database Browser: Right-clicking on the database browser now selects the object that was right-clicked.
  • Edit Table Tool: Default max rows displayed is now 2500.
  • Edit Table Tool: Shift + Space no longer selects the entire text.
  • Edit Table Tool: If there are no primary keys on a table, only prompt to enter keys if existing data is changed.
  • Execute Procedure Tool: SQL Server: Added support for ntext and text data types.
  • Bug Fixes:
  • Import Tool: Wrap column not getting selected by default for date and time data types.
  • Import Tool: Number data type defaulting to getting wrapped for Oracle.
  • Export Tool: Export as insert statements option: when the select * query has a where clause, the where clause is getting included in the generated insert statement.
  • Export Tool: Hitting cancel does not stop network traffic.
  • Query Builder: For update statements, the where clause is not getting generated unless a value or operator is selected in the first column.
  • Create Table Tool: If a primary key is selected, and multiple unique constraints are selected, commas are missing from the unique constraint.
  • Create Table Tool: SQL Server unique identifier column should not allow a length.
  • Database Browser: SQL Server 2005: In certain circumstances, schemas not displaying correctly.
  • Database Browser: Sybase: not always getting all schemas in a database.
  • Execute Procedure Tool: Not working for InterBase
  • Execute Procedure Tool: Not working for Pervasive
  • Connection Wizard: Teradata connection screen is not clear on what to enter for the database.
  • New Session - Share Connection menu option not populating the database / schema drop down box.

New in RazorSQL 4.2.10 (Sep 3, 2008)

  • MySQL, MS SQL Server, and Sybase - Auto correction of connection errors when connecting locally.
  • Double clicking of query results column sorts column results in ascending order. Double clicking again sorts in descending order.
  • Edit Table Tool - When max row count is reached for edit table tool, unable to edit rows inserted after the max count.
  • PostgreSQL - double clicking or menu based launch of edit table tool not working for query results.
  • Sort Ascending menu option on query results column brings up sort dialog instead of simply sorting the results.

New in RazorSQL 4.2.9 (Aug 12, 2008)

  • Query Results: Added preference for specifying which character set to use when displaying query results.
  • Connection Wizard: Added support for Frontbase database passwords.
  • SQL Explain Plan: MS SQL Server explain plan throwing error when using default connection settings (server side cursors).
  • Edit Table Tool: Replace all not replacing values.
  • Connection Wizard: Browse button for Firebird databases sometimes showing save dialog instead of open dialog.
  • SQL Editor: Redo keyboard shortcut not working.
  • Create Table Tool: Numeric value columns not enabling the scale field.
  • Create Table Tool: Postgresql char column not defaulting a size value.
  • Database Navigator: Postgresql showing char columns as bpchar.
  • Drop Index Tool: SQL Server 2000 syntax incorrect.

New in RazorSQL 4.2.8 (Jun 26, 2008)

  • Export Tool: Added ability to wrap exported values in double-quotes if there are delimiters found in the value.
  • Import Tool: Added option to handle values containing delimiters that are wrapped in double quotes
  • Auto Lookup: Added option for setting auto lookup timeout
  • SQL Editor: Added option for specifying whether to turn font anti-aliasing on or off
  • Database Navigator: SQL Server Owners / Schemas query changed for better performance.
  • SQL Editor: Added ability to cancel executing tasks one by one instead of all at once
  • SQL Editor: Auto reconnect changed so that auto reconnect is only attempted one time per query
  • Keep Alive: Added a 10 second timeout to keep alive calls
  • Edit Table Tool: On Windows, down and up arrow were moving two cells instead of one
  • SQL Editor: SQL Server - poor performance when executing queries after a query that returns a large result set
  • SQL Editor: Fixed occasional performance problems when closing large query results tabs
  • SQL Editor: Comma in order by doing an auto table lookup instead of an auto column lookup
  • SQL Editor: Auto table lookup not firing after from in a delete statement
  • SQL Editor: Linux: Slow keyboard response on using JRE 1.6.x
  • JDBC Bridge: Cannot handle queries with in them

New in RazorSQL 4.2.7 (Jun 12, 2008)

  • General: By default, if a connection is dropped, RazorSQL will automatically try to re-establish the connection.
  • Preferences: Added option to keep alive preferences for automatically reconnecting dropped connections.
  • Command Line: Added import command as a command line option
  • Editor: Added regular expression find and replace
  • Auto Table Lookup: Now recognizes join clauses and will do auto table lookup on comma space in a select from clause
  • Auto Table Lookup: By default, auto table lookup no longer prepends schema or database for tables in current schema or current database
  • Auto Table Lookup: Added preference for whether or not to show schemas and databases in auto table lookup results
  • Auto Table Lookup: Added preference for whether or not to prepend current schema or database for tables in current schema or database.
  • Auto Column Lookup: Column names now displayed after "and" or "or" text.
  • Export Tool: By default, non insert statement exports convert nulls to blank. Can be overriden by deselecting the convert nulls . . .box
  • Column Lookup, Describe, and View Table Contents: Now will automatically execute without a prompt for an object name if there is selected text in the editor that matches the selected object in the current dropdown options for the tools
  • Column Lookup: Now remembers last schema and does a better job of remembering last table
  • Table Lookup: Now remembers tables, views, and system tables selection, and does a better job of remembering last schema and catalog
  • Table Lookup: Adde an option for whether or not to prepend schemas or databases
  • General: Add an "Open Copy" option to the right-click menu of the Tab
  • General: Add a "Make Backup" option to the right-click menu of the Tab
  • Check for warn if modified on focus instead of just when switching tabs
  • Space character now select lookup dialogs value in addition to the ENTER key
  • Should only be able to have one lookup dialog open at a time
  • System Database Navigator: Fetch size settings from the preferences are now used when retrieving database objects using the System navigator
  • Auto lookup and lookup dialogs no longer modal and now can be moved
  • Delete and Backspace characters now close lookup dialogs in addition to ESCAPE
  • Windows: Only one instance of RazorSQL can be opened at a time
  • File -> Tools and File -> Conversions not working
  • Commit and Match Tag share the same default keyboard shortcut
  • If using SPACE as an option for a keyboard shortcut inserting an extra space when typing the shortcut
  • Execute Procedure Tool: Parameters not being retrieved correctly for schemas or databases with spaces in the name

New in RazorSQL 4.2.6 (May 14, 2008)

  • Fix: SQLite: Large queries hanging in certain circumstances

New in RazorSQL 4.2.5 (May 5, 2008)

  • SQL Editor: Added Search Bookmarks option, including Add Bookmark, Remove All Bookmarks, Next Bookmark and Previous Bookmark for quickly jumping to different sections of a file.
  • SQL Editor: Added Edit - Code - Line Comment for quickly commenting a line or group of lines
  • SQL Editor: Added Edit - Code - Range Comment for quickly commenting a line or group of lines
  • SQL Editor: Added Edit - Text - Tabs to Spaces
  • SQL Editor: Added Edit - Text - Spaces to Tabs
  • SQL Editor: Auto indent now supports spaces and tabs
  • SQL Editor: Enhanced Match tag and Match bracket tools
  • Navigator Filter Tool: Enhanced navigator filter tool giving options to filter on all database objects, such as tables, views, procedures, etc. using syntax such as contains, not contains, in, not in, equals, and not equals
  • Export Tool: Insert statement option now enabled when a query is a select * from a table.
  • Java Tools: Enhanced compiler and set classpath tools
  • SQL Server: Enhanced connection process to smart detect common errors
  • MySQL: Enhanced connection process to detect incompatabilities between MySQL and the driver used.
  • Application name property now set to RazorSQL when connecting for Sybase and SQL Server
  • Added default keyboard shortcut of Command / Control M for match tag
  • RazorSQL now wraps database objects that include periods in their names
  • Sybase and SQL Anywhere - Create table tool now explicitly inserts the NULL keyword for columns specified as nullable
  • Null not showing as a keyword for Transact-SQL
  • Oracle Show Info on Functions and Procedures in System Navigator returning info on all functions and procedures
  • SQL Server - Database Navigator not always working when the user does not have a current schema, such as for active directory single sign-on

New in RazorSQL 4.2.3 (Apr 7, 2008)

  • Query Results: Query results tab now attempts to show the first database object in the query as the title of the tab
  • Query Results: Tooltip on the query results tab is set to the query
  • Query Results and Edit Table Tool: By default, the background color of the result rows now alternate colors
  • Query Results: By default, null values cells in the query results show as a different color
  • Query Results: Added preference for whether or not to show database object name as tab title
  • Query Results and Edit Table Tool: Added preference for whether or not to alternate background color on results rows
  • Query Results: Added preference for whether to show null cells as a different color
  • SQL Editor: Added preference for close result sets on execute to help eliminate any table locking, especially for DB2.
  • SQL Editor: DB2 - SQL state error code descriptions are now included in error messages
  • SQL Editor: Execute SQL (One Statement) now checks any highlighted text and makes a determination if there are multiple normal queries (select, insert, update, delete) contained in the text. If there are, all queries are executed.
  • SQL Editor: Added preference for the Execute SQL (One Statement) multi-query parsing
  • SQL Editor: By default, semi-colons are stripped off of queries wnen using Execute SQL (One Statement) for databases that do not support ending semi-colons. (DB2, Derby, Ingres, Oracle (for select,insert,update, and delete only), and Sybase
  • SQL Editor: Added a preference for whether or not to strip semi-colons for applicable databases (DB2, Derby, Ingres, Oracle, Sybase)
  • SQL Editor: Search - Replace All speed enhancements
  • Edit Table Tool: Down and Up arrow keys now move up and down rows instead of to the beginning and ending of row text
  • SQL Editor: Added menu option for Execute (All Statements Close Current Tabs) to close existing query results tabs and then add the new tabs for the executed query results
  • Database Navigator, Describe Tool: Enhanced column information now available for SQLite views
  • Database Navigator, Edit Table Tool: SQLite views are now editable.
  • Query Results: Queries with no results no longer have their query results tab replaced when the next query is run
  • SQL Editor: Removed query length check
  • SQL Editor: Removed preference for Run Each Query in a New Tab, since setting the statement / query count to 1 accomplishes the same thing.
  • Bug: Explain Plan Tool: Not working correctly for DB2
  • Bug: Edit Table Tool: SQLite - If table already has a rowid column, do not display another rowid column

New in RazorSQL 4.2.2 (Apr 2, 2008)

  • Connection Wizard: Added Microsoft SQL Server ASP bridge
  • Connection Wizard: Added Microsoft SQL Server PHP bridge
  • Connection Wizard: Added PostgreSQL PHP Bridge
  • Tools: Added copy to editor button to query builder, create tools, alter tools, drop tools, and import tool
  • Query Results: Added save query button to query results toolbar
  • Query Results: Added save query option to query results popup menu
  • Preferences: Added a preference for whether or not to auto-parse editor contents for queries by searching for the closest semi-colon after the cursor when executing queries
  • Tools: For SQL Server, Sybase, and SQL Anywhere, tools that generate SQL now check the value of the QUOTED_IDENTIFIER session setting to determine whether to generate SQL with qoutes or brackets when necessary
  • Editor: Tabs now scroll instead of stacking
  • Editor: Added semi-colon auto-parsing for determining the query to execute for PL/SQL, Transaction SQL, and SQL PL syntax highlighting types
  • Preferences: Added a Default option to the file encoding preference menu to make it easier to tell RazorSQL to use the default operating system file encoding
  • Database Navigator: Can now handle navigation for DBASE
  • General: Implemented a custom scale for painting icons to prevent black icon backgrounds when using RazorSQL with Parallels
  • Fix: MySQL PHP Bride: use database command ignored when trying to switch databases
  • Fix: MySQL PHP Bridge: errors on multi-line selects
  • Fix: FrontBase: displaying nulls as 0 for numeric columns
  • Fix: Editor: OS X Leopard: Sometimes error thrown when adding or removing tabs
  • Fix: Customize toolbar: Not letting default icons be removed
  • Fix: Alter Table Tool: Table list for MySQL showing all tables when no database is selected
  • Fix: Print Output: SQL Server / Sybase - Not all print output being captured for statements with multiple result sets
  • Fix: SQL Formatter: Not factoring in underscores when upper casing or inserting line breaks for keywords
  • Fix: SQL Server ODBC Driver throwing multiple open result set errors

New in RazorSQL 4.2.1 (Mar 3, 2008)

  • Actions: View Print / DBMS Output Window automatically refreshes
  • General: Added option to customize exactly which icons appear on the toolbar
  • General: Added preference for whether or not to show hidden files in File System Browser
  • General: Added preference for whether or not to save caret position when exiting
  • Windows: Buttons on query results pane not always clickable after focus is set in the SQL editor
  • Windows: Editor line numbers not always painting properly
  • General: Focus is not always in the editor on launch of RazorSQL
  • View Print Output: Only returning 25 messages
  • Connection Wizard: Oracle connect as property not getting saved after the initial connection
  • Function List Tool: PHP - global if / else statements are being listed as functions
  • Status Component: sometimes showing invalid length for Windows files that end in a blank line

New in RazorSQL 4.2.0 (Feb 25, 2008)

  • Tools: Added a Create Database tool for MySQL, PostgreSQL, MS SQL Server and Sybase
  • Tools: Added a Drop Database tool for MySQL, PostgreSQL, MS SQL Server, and Sybase
  • Tools: Added a Create User tool for MySQL and PostgreSQL
  • Tools: Added a Drop User tool for MySQL and PostgreSQL
  • Actions: Added View Print Output for MS SQL Server and Sybase for viewing output of PRINT statements in executed statements.
  • Actions: Added View DBMS Output for Oracle for viewing DBMS output in executed statements
  • SQL Editor: Added parameter processing to queries, i.e. select * from employee where id = &id -- launches an input dialog for the user to specify the value for &id
  • SQL Editor: Enhanced auto column lookup
  • Programming Editor: Added File -> Open With Encoding option to specify a file encoding for reading and opening a file
  • Programming Editor: Added File -> Reload With Encoding option for reloading a file with an encoding chosen by the user
  • Programming Editor: Added File -> Save with Encoding option for saving a file with an encoding chosen by the user
  • Programming Editor: Added preference for the default file encoding for opening and saving files to allow users to specify a file encoding other than the default file encoding used by the operating system
  • Programming Editor: Added the current file's file encoding to the editor status panel
  • Programming Editor: Increased maximum size of a file that RazorSQL can open with default memory settings to approximately 75 MB
  • Programming Editor: Find/Replace - Show Found Lines option now has clickable links to take the user directly to the found line
  • Programming Editor: Replace All now shows the number of replaced items
  • Programming Editor: CSS Tag List tool now sorts the CSS tags
  • Programming Editor: PHP, JavaScript, HTML, BAT, Perl, Ruby, Python, and Shell Script Function List tool now sorts the functions and displays the function names first
  • Database Navigator: Added a rename option to the Database Navigator as a shortcut to rename tables via the Alter Table tool
  • Database Navigator: Added a rename option to the Database Navigator as a shortcut to rename columns via the Alter Table tool
  • Database Navigator: Added users to MySQL, PostgreSQL, and Sybase system database navigator
  • Database Navigator: Added roles to PostgreSQL and Sybase system database navigator
  • Connection Wizard: Added transaction isolation level as a selectable option to the connection profile screen. Selectable values are Default, Read Uncommitted, Read Committed, Repeatable Read, and Serializable
  • SQL Formatter: Added enhancements for formatting quoted and commented text
  • Programming Editor: Find / Replace in Files dialog no longer modal
  • Programming Editor: Java Function List - method name is now first with public, etc. after the method name for better readability
  • Programming Editor: Tag List - added more information about tags
  • Auto Column Lookup: Not working for tables with spaces in the name and in certain situations when tables have special characters in the name
  • Export Tool: Throwing a Result Set is closed error in certain situations when exporting query results, especially when using the fetch all results option
  • SQL Formatter: Not factoring in quoted text when inserting line breaks
  • Tools: Not working for tables with large column counts, such as 500 plus columns - (Query Builder, Navigator Filter, Edit Table Tool, Create Table Tool, Create Proceure Tool, Alter Table Tool, Import Tool)
  • Find / Replace in Files, Find in Open Editors: If more than 512 results found, an error was thrown
  • Tag List, Function List, Query List: If more than 512 results found, an error was thrown
  • Programming Editor: Saving a new file does not honor the line separator preference if the file does not yet exist and the line separator preference is not the default for the operating system

New in RazorSQL 4.1.7 (Jan 27, 2008)

  • Command Line Interface: Added the ability to export data by interacting with RazorSQL via the command line
  • SQL Editor: Find / Replace in Files - Found or replaced lines now have clickable icons to take the user to the line in the file that was found or replaced
  • SQL Editor: Find in Open Editors - Found or replaced lines now have clickable icons to take the user to the line in the file that was found or replaced
  • Database Navigator: Added Show Info for Sybase views to show Sybase view definitions
  • SQL Editor: Added File -> Show in Web Browser option
  • General: OS X - added Open Files server to the Finder for RazorSQL
  • General: OS X - added RazorSQL to the Finder open with menu
  • General: Moved Ascii Table option under Tools menu
  • General: Changed default keyboard shortcuts for Previous Tab and Next Tab due to conflicts with special characters keyboard mapping
  • SQL Editor: Typed special characters such as those on non US keyboard layouts not being recognized by SQL Editor
  • SQL Editor: Oracle - Compile errors not being shown for procedures/packages when a procedure is built using a fully qualified schema.procedure name
  • SQL Editor: Match Tag option - If there are nested child tags of the same name as the parent tag, the Match Tag tool is not factoring them in when determining where the end tag is
  • Database Navigator: Alter View option not returning view definition for Sybase
  • Database Navigator: Informix - Procedure, Function, and Trigger contents not being returned for certain configurations
  • Query Results: Executing an exec command that returns results does not enable the buttons on the query results toolbar

New in RazorSQL 4.1.6 (Jan 23, 2008)

  • Enhancements:
  • Preferences: Added customizable keyboard shortcuts to the Preferencees window for each command available in RazorSQL
  • Programming Editor: Added Edit -> Next Paragraph option
  • Programming Editor: Added Edit -> Previous Paragraph option
  • Programming Editor: Added Edit -> Select -> Select Next Paragraph option
  • Programming Editor: Added Edit -> Select -> Select Previous Paragraph option
  • Programming Editor: Added Edit -> Select None (Escape) option for cancelling selected text
  • Programming Editor: Added Edit -> Command / Control T option for bringing up the Font window
  • Programming Editor: Reload File option now remembers cursor position
  • Query Results: Added Show Cell Text in New Window icon and menu option
  • Query Results: Added Copy Cell Text to Editor icon and menu option
  • Changes:
  • Programming Editor: OS X - Changed Select Next Word default keyboard shortcut to Shift - Option - Right
  • Programming Editor: OS X - Changed Select Previous Word default keyboard shortcut to Shift - Option - Left
  • Programming Editor: OS X - Changed Select to End of Line default keyboard shortcut to Shift Command Right
  • Programming Editor: OS X - Changed Select to Beginning of Line default keyboard shortcut to Shift Command Left
  • Programming Editor: OS X - Changed Select to Beginning of Document default keyboard shortcut to Shift Command Up
  • Programming Editor: OS X - Changed Select to End of Document default keyboard shortcut to Shift Command Down
  • Programming Editor: Added target version of 1.6 to target dropdown for Tools -> Java -> Compile
  • General: Moved Toolbars menu under the View menu
  • Bug Fixes:
  • MySQL PHP Bridge and JDBC Bridge: In RazorSQL versions 4.1.4 and 4.1.5, date columns are throwing a not supported exception on select
  • Keep Alive: Keep Alive query not getting set correctly for some databases
  • Programming Editor: Next Tab keyboard shortcut not working on OS X

New in RazorSQL 4.1.5 (Jan 9, 2008)

  • Enhancements:
  • Edit Table Tool - Improved table cell editing - cells are now editable without clicking
  • Connection Wizard - Updated auto-download MySQL driver to 5.0.8
  • File Tools / File System Browser - Added regular expression file search tool.
  • General - Tools selected via the tools menu now check for selected tables/views in the database navigator in addition to selected text in the SQL Editor to populate the selected table/view in the tool dropdown
  • General - Added View Memory Usage item to the Help menu
  • File System Browser - Added ability to change font
  • SQL Editor - Added Increase Editor Font item to the View menu
  • SQL Editor - Added Decrease Editor Font item to the View menu
  • SQL Editor - Added View -> Display Line Numbers option
  • SQL Editor - Added View -> Display Editor Status option
  • Programming Editor - Added File -> Conversions menu for converting to Windows, OS X / Unix, and Mac Classic line breaks
  • Programming Editor - Added syntax highlighting and function lookup support for COBOL.
  • Changes:
  • Edit Table Tool - Automatically handle and display the SQLite implicit rowid column
  • Edit Table Tool - Display an error message if a user tries to edit an SQLite view since views in SQLite are read-only
  • Create Table Tool - SQLite - removed support for AUTOINCREMENT
  • Programming Editor - now auto-detects the line separator of an opened file and formats accordingly (Windows =
  • , Unix / OS X =
  • , and Mac Classic = )
  • Bug Fixes:
  • Import Tool - Bug introduced in version 4.1.4 with Delmited file validator
  • SQL Editor - MySQL - Do not show a selected database in the database drop down on the toolbar if not database has been specified on connect
  • SQL Editor - If a new database is created or dropped, the change is not reflected in the database dropdown on the toolbar
  • Create Table Tool - MySQL - AUTO_INCREMENT syntax incorrect
  • General - SQLite - Not handling null values correctly. Displaying them as .
  • General - Find / Replace and Find / Replace in Files tools - First time launch not populating with selected text if there is text selected in the editor
  • Programming Editor - .h files now default to C syntax highlighting

New in RazorSQL 4.1.3 (Dec 19, 2007)

  • [Enhancement]Alter Table Tool: Added rename table for HSQLDB, MySQL, Oracle, PostgreSQL, SQLite, SQL Server, Sybase, SQL Anywhere
  • [Enhancement]Alter Table Tool: Added rename column for HSQLDB, Firebird, MySQL, OpenBase, Oracle, PostgreSQL, SQL Server, Sybase, and SQL Anywhere
  • [Enhancement]Alter Table Tool: Added drop primary key option for DB2, MySQL, Oracle, PostgreSQL, SQL Server, and SQL Anywhere
  • [Enhancement]Alter Table Tool: Added drop foreign key option for DB2, MySQL, Oracle, PostgreSQL, and SQL Server
  • [Enhancement]Alter Table Tool: Added add sequence trigger option for Oracle - generates a before insert trigger to handle auto-incrementing
  • [Enhancement]Database Navigator: Added Truncate option to the database navigator for tables for Informix, MySQL, Oracle, PostgreSQL, SQL Anywhere, Sybase, and SQL Server
  • [Enhancement]Database Navigator: Added option to truncate multiple tables to database navigator for Informix, MySQL, Oracle, PostgreSQL, SQL Anywhere, Sybase, and SQL Server
  • [Enhancement]Database Navigator: Added option to drop multiple tables to database navigator
  • [Enhancement]Import Tool: Added Import from Excel spreadsheet option
  • [Enhancement]Import Tool: Performance improvements for generating inserts from imported file
  • [Enhancement]Import Tool: Added do not show column names in generated inserts option
  • [Enhancement]Connection Wizard: Added support for Interbase database
  • [Enhancement]Connection Wizard: Added support for Solid database
  • [Enhancement]Connection Wizard: Added support for the H2 database
  • [Enhancement]Connection Wizard: Added support for SQL Server instances using the default jTDS driver via the host field by separating the host or ip and the instance with a
  • [Enhancement]Connection Wizard: Added configurable ssl and sslfactory options to built-in PostgreSQL driver
  • [Enhancement]Connection Wizard: Added configurable autoReconnect, useCompression, and noDatetimeStringSync options to the built-in MySQL option
  • [Enhancement]Connection Wizard: Added configurable bindAddress, instance, and ssl options to the built-in jTDS driver for SQL Server
  • [Enhancement]Connection Wizard: Added configurable jdbc url properties for SQL Server, PostgreSQL, and MySQL built-in options
  • [Enhancement]Connection Wizard: Oracle - Added connect as SYSDBA and SYSOPER option
  • [Enhancement]General: Added Next Tab (Alt-N) and Previous Tab (Alt-P) to the window menu
  • [Enhancement]General: Added Close All Except Current Window option to the Window and File menus
  • [Enhancement]General: Added Close All Query Results Except Current option to the Window menu
  • [Enhancement]File System Browser: Added ability to move files and directories
  • [Enhancement]File System Browser: OS X: Delete files now moves files to trash
  • [Enhancement]File System Browser: OS X: Non-empty directories can now be deleted (moved to trash)
  • [Change]Connection Wizard: Switched default to JConnect from jTDS for Sysbase JDBC driver
  • [Change]Connection Wizard: Auto-correct driver location on the profiles if RazorSQL is moved
  • [Change]Connection Wizard: HSQLDB and Derby Embedded driver now allows users to select a directory instead of a file for existing databases
  • [Change]Launcher: Do a check for gcj GNU java since it is not supported
  • [Change]General: Upgraded to latest version of JGoodies look and feel libraries for Windows and Linux
  • [Change]General: SQL Restrictions: Restrictions now applied at time of execution instead of preventing certain tools from being active
  • [Change]General: Default query timeout changed to 5 minutes
  • [Change]General: Default connect timeout changed to 2 minutes
  • [Bug Fix]Sybase: Data types not populating with auto-commit off for jTDS driver
  • [Bug Fix]Sybase: nvarchar and nchar not getting wrapped in Edit Table Tool for jTDS driver
  • [Bug Fix]Edit Table from Query Results: Queries with no where clause but order by clause throwing error when trying to edit
  • [Bug Fix]Edit Table Tool: For tables with no primary keys, clicking on the SQL tab without selecting keys throws error messages
  • [Bug Fix]General: If trying to open a file that is already open that has been modified, incorrect file may get reloaded
  • [Bug Fix]Drop Table, Drop View: Generate SQL option on the drop table and drop view option from the database navigator not changing table when the table changes in the dropdown

New in RazorSQL 4.1.2 (Nov 30, 2007)

  • Enhancements
  • Query Results Tab: Added Copy Results to Clipboard option
  • Query Results Toolbar: Added select all and copy selected icons
  • Query Results Table: Added select all option to context menu
  • Export Tool: Allow to export multiple tables as SQL insert statements
  • Compare Files: Now auto-populates with the last two opened files
  • Database Navigator: SQLite, Derby Embedded, and HSQLDB Embedded - Added option to create new database
  • SQLite: OS X - Added ability to attach databases
  • Edit Table Tool: Table now expands as window expands
  • Added release unused memory option to the help menu
  • Changes
  • Query Builder: Default operator for select now set to =
  • Filter Navigator: Added option to remember filtered objects per connection profile
  • Edit Table Tool: Minimum size of edits in new window window now bigger
  • Database Navigator: Sybase databases are now sorted
  • Bug Fixes
  • Edit Table Tool: MySQL tables with unique keys throwing validation error when launching the edit table tool
  • Edit Table Tool: If editing query results, and table name was not queried using the database recommended case, potential problems determining keys can occur
  • Query Builder: * is getting wrapped in quotes
  • Table Lookup: Tables with spaces not always getting displayed correctly
  • File Tree Navigator - Windows - On re-opening, size is very small
  • Auto column lookup - Lookup not working for all join types
  • Database Navigator: Sybase, when auto-commit is off, tables, views, system tables, procedures, and primary keys not displaying correctly
  • SQLite: Cannnot connect to an empty database file
  • SQLite: Connecting to a database file that does not exist does not create the database file
  • SQLite: Not always handling tables with spaces correctly
  • SQLite: Not handling columns that have spaces correctly

New in RazorSQL 4.1.1 (Nov 13, 2007)

  • Changes
  • Edit Table Tool: Throw a warning message if the user exits the edit table tool without committing changes
  • Edit Table Tool: Change the commit/execute icon from a blue checkmark to a save icon
  • Create Table Tool: Convert column and table names to database vendors default case if not wrapped in delimiters by user
  • Alter Table Tool: convert column name in Add column option to database vendors default case if not wrapped in delimiters by user
  • Database Navigator: Changed text for Schema to Owner for Sybase, SQL Anywhere, and SQL Server pre 2005
  • Connection Wizard: Profiles are now listed in alphabetical order
  • Connection Wizard: For Oracle, service name and sid are now consolidated into one option with a radio button for the Thin Driver selected
  • General Tools: Added a preference for whether or not to wrap database objects when generating SQL from the tools. For example, CREATE TABLE "TABLE_NAME" or CREATE TABLE TABLE_NAME, etc.
  • Bug Fixes
  • General Tools: Database objects with hyphens not being represented correctly in queries
  • General Tools: For databases that have strict case sensitivity, database objects that are explicitly created using a non-default case are not being wrapped correctly for the database navigator, create, alter, and drop tools, query builder, export tool and import tool
  • Database Navigator: Firebird - Not getting columns correctly for mixed and lower case tables
  • Query Builder: SQL Anywhere: Unable to get columns when launched from the tools menu

New in RazorSQL 4.1.0 (Nov 7, 2007)

  • Enhancements
  • General: Added built-in navigator and connection support for Sybase SQL Anywhere
  • General: Added built-in navigator and connection support for Firebird
  • General: Added built-in navigator and connection support for Informix
  • General: Added built-in navigator and connection support for FrontBase
  • General: Added built-in navigator and connection support for OpenBase
  • General: Added built-in navigator support for Ingres
  • General: Added support for allowing spaces in databases, schemas, tables, columns, etc. for databases that support this type of naming
  • General: Added support for querying, modifying, etc. objects that have spaces in the name
  • Edit Table Tool: Enhanced look and feel, added toolbar, and increased editable space
  • Edit Table Tool: Added search functionality
  • Edit Table Tool: Added button to allow cell editing in new window
  • Edit Table Tool: Added replace and replace all functionality
  • SQL Editor: Make it so double-clicking a table cell brings up edit tool with the correct cell in editable mode
  • SQL Editor: Add edit menu item to query table context menu
  • SQL Editor: Add edit menu item to query results cell context menu
  • SQL Editor: Added toolbar to query results section with sort, filter, search, edit, re-execute, export, compare, view query options
  • SQL Editor: Added Row Count value to the status bar for queries executed with the "Fetch All Rows" action
  • SQL Editor: Enhance auto column lookup for pre from clause aliases for multi-table joins
  • Create Table Tool: Added engine type option (InnoDB, MyISAM) for MySQL
  • Create Table Tool: Added enumeration option for MySQL
  • Create Table Tool: Added ability to add Check constraints
  • Create Table Tool: Added identity / auto-increment for the major databases that support it.
  • Create Table Tool: Added default value
  • Create Table Tool: Added ability to add scale to decimal values
  • Create View Tool: Added schema dropdown to the create view tool
  • Alter Table Tool: Added scale and Not Null options to the Add Column section
  • Alter Table Tool: Added ability to add check constraints
  • Alter Table Tool: Added ability to select multiple columns for adding foreign keys
  • Alter Table Tool: Added ability to drop columns
  • Alter Table Tool: Added ability to drop constraints
  • Alter View: Added Alter View Tool
  • Added Query Scheduler tool to schedule queries for various intervals and number of executions and write the output to a file
  • Added Create Trigger Tool*
  • Added Edit Trigger Tool*
  • Added Drop Trigger Tool*
  • Added Drop View Tool*
  • Added Drop Table Tool
  • Added Drop Index Tool*
  • Added Create Index Tool*
  • Added Create Sequence Tool*
  • Added Drop Sequence Tool*
  • Added Drop Procedure, Function, Package, and Package Body Tool*
  • Informix: Added support for viewing, creating, and editing procedures, functions, and triggers
  • Ingres: Added support for creating, editing, and dropping procedures
  • SQL Anywhere: Added support for creating, editing, and dropping triggers and procedures
  • Firebird: Added support for creating, editing, and dropping triggers and procedures
  • Derby: Added support for creating and dropping triggers
  • Connection Wizard: Auto JDBC URL configuration added for Firebird, FrontBase, Ingres, Daffodil DB, Mckoi, MimerSQL, Pointbase, Teradata, and Informix
  • Connection Wizard: Added create=true onto derby and daffodil connection urls
  • Connection Wizard: Added Embedded option for Daffodil DB / One$DB
  • Connection Wizard: MySQL: Automatically add the ?noDatetimeStringSync=true for MySQL Connector/J 3.1.7 or later.
  • Connection Wizard: Added download button for JDBC drivers for Ingres, MimerSQL, Pervasive, and Teradata.
  • Tools: More databases now prepopulate the current database and/or schema on dropdowns
  • Database Navigator: Added additional Create, Alter, and Drop options
  • Database Navigator: MySQL - Added View DDL option for tables and views
  • Database Navigator: SQLite - Added View DDL option for tables, views, indexes, and triggers
  • Database Navigator: Oracle - Added View DDL option for tables, views, indexes, constraints, sequences, materialized views, procedures, function, packages, package bodies, and triggers
  • Database Navigator: OpenBase - Added triggers and users
  • Database Navigator: FrontBase - Added functions
  • Database Navigator: HSQLDB - Added indexes for table and users
  • Database Navigator: Ingres - Added indexes and sequences
  • Database Navigator: SQL Anywhere - Added indexes and triggers
  • Database Navigator: Firebird: Added functions, triggers, indexes, sequences, and users
  • Database Navigator: Derby - Added indexes and triggers
  • Database Navigator: Informix - Added functions, triggers, indexes, and users
  • Database Navigator: Enhanced Database Navigator filter for databases with built in support
  • SQL Explain Plan: Added support for SQLite
  • Query Builder: auto-wraps columns with single quotes, etc. that need wrapping
  • Query Builder: Supports multiple tables in select and auto-generates join clauses
  • Changes
  • Edit Table Tool: If the keys are found, don't prompt the user for them, just go straight to the edit table page.
  • General: FrontBase - remove databases dropdown from tool and navigator
  • Execute Procedure Tool: Added support for Ingres NCHAR and NVARCHAR
  • Export Tool - Deselect export column names by default, pre-select delimited file with comma preselected
  • Export Tool - Changes in handling on null/empty values If a date, time, or timestamp column is empty, represent as null. If a non-character column is empty, represent as null If a character column is empty, check whether it is null or empty string in the table. Represent accordingly.
  • Import Tool - Changes in handling of null/empty values. If a date, time, or timestamp column is empty, represent as null. If a non-character column is empty, represent as null. If a character column is empty, represent as '' (empty string) If a character column is the null string, represent as null
  • Edit Table Tool - Changes in handling of null/empty values If a date, time, or timestamp column is empty, represent as null. If a non-character column is empty, represent as null. If a character column is empty, check whether it is null or empty string in the table. Represent accordingly
  • Bug Fixes
  • General: Several bug fixes regarding Informix functionality in the Database Navigator, SQL Editor, and general tools.
  • General: Table lists not populating correctly for SQL Anywhere
  • Connection Wizard: Firebird jaybird files no longer required to be in the system java extensions folder
  • Connection Wizard: When the driver has already been loaded, the error message is flickering and then not displaying again
  • Connection Wizard: Derby Network Server - built-in driver derbyclient.jar file had incorrect name.
  • Edit Procedure Tool: SQL Server Edit procedures and functions. Not generating Alter statement correctly if first line is a comment or nonstandard create procedure or function statement used.
  • SQL Editor: If the focus is in the sql editor, and a query is executed, should keep the focus in the sql editor
  • Database Navigator: MySQL Show Info on indexes throws query error
  • Database Navigator: Not all context menu options avaiable for System Tables
  • Preferences: Auto column and Auto Table lookup prefs. Need to turn both off to prevent each type of lookup
  • Help: SQL Server Authentication file not showing up
  • Setting connect timeout to 0 in the preferences does not disable the connect timeout
  • RazorSQL JDBC Bridge, describe table not always showing column information.
  • Query Builder Tool: Not showing system tables in the tables dropdown for certain databases
  • Edit Table Tool: When deleting rows after a newly inserted row, data is not showing correctly
  • Edit Table Tool: Date, Time, and Timestamp columns not wrapped in single quotes for Oracle, Firebird, PostrgreSQL and potentially other databases
  • Edit Table Tool: Money column not wrapped in single quotes for PostgreSQL
  • Edit Table Tool: Derby - not representing date, time, and timestamp columns correctly
  • Tools: System tables not always showing in dropdowns
  • RazorSQL SQLite Driver - Updated Rows always is showing -1
  • Derby - Auto table lookup, tables are showing up twice
  • Auto Table Lookup - FrontBase - Table names are not always sorted
  • Create Package and Create Package Body Tools: Schema value ignored
  • Columns with sizes greater than Integer.MAX_VALUE not displaying properly on the database navigator
  • RazorSQL JDBC Bridge - Get procedure columns not implemented correctly
  • Alter Table Tool - Syntax for Informix not correct
  • Query Builder - Update builder not always generating all columns in where clause