RazorSQL Portable

Software Screenshot:
RazorSQL Portable
Software Details:
Version: 9.1 updated
Upload Date: 3 May 20
Distribution Type: Shareware
Price: 99.95 $
Downloads: 132
Size: 97684 Kb

Rating: nan/5 (Total Votes: 0)

RazorSQL Portable is a database query tool, SQL editor, database browser, and administration tool with built-in connection capabilities for Access, Cassandra, DB2, Derby, DynamoDB, Firebird, FrontBase, Hive, HSQLDB, H2, Informix, Microsoft SQL Server, MongoDB, MySQL, OpenBase, Oracle, PostgreSQL, Redshift, Salesforce, SQL Anywhere, SQL Azure, SQLite, Sybase, and Teradata.

Any other JDBC or ODBC compliant database is also supported. RazorSQL Portable ships with a built in relational database engine that is up and running out of the box and requires no end user administration.

What is new in this release:

Version 9.1:

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

What is new in version 8.2:

  • 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.
  • Linux: Added a new shell script launcher to Linux for nonreparenting window managers
  • 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
  • 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

What is new in version 8.0.9:

Version 8.0.9:

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

What is new in version 8.0.3:

  • 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
  • Salesforce: Updated Salesforce API calls to version 43.0
  • SQL Editor: Added None as a syntax highlighting type

What is new in version 7.4.8:

  • 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
  • Upgraded Firebird JDBC driver
  • 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

What is new in version 7.4.2:

Version 7.4.2:

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

What is new in version 7.3.5:

  • 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

What is new in version 7.3.3:

  • 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
  • Reduce amount of logging for Salesforce and DynamoDB to prevent large log files
  • RazorSQL SQLite driver not recognizing primary keys correctly when columns are defined with tick marks surrounding the name

What is new in version 7.3.0:

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

What is new in version 7.2.5:

  • Improved memory efficiency of the compare process
  • 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

What is new in version 7.2.4:

  • 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
  • Upgraded HSQLDB driver to 2.3.4
  • Upgraded SQLite driver to 3.16
  • Upgraded sqlite3 command line program to 3.16
  • 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

What is new in version 7.2.3:

Version 7.2.3:

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

What is new in version 7.2.1:

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

What is new in version 6.1.5:

Version 6.1.5 has fixed Execute Procedure Tool bug which does not support datetime types for SQL Server and Sybase.

Limitations:

30-day trial

Supported Operation Systems

Similar Software

Other Software of Developer Richardson Software

Comments to RazorSQL Portable

Comments not found
Add Comment
Turn on images!