In this article, we will review some of the new features and enhancements that RazorSQL 8.4.0 offers for its users.
Database Specific Features
RazorSQL 8.4.0 has added support for several new databases and improved the existing features for some of the supported databases. Some of the highlights are:
Built-in support for Athena, Aurora (MySQL and PostgreSQL), BigQuery, Cassandra, Couchbase, DynamoDB, Keyspaces, Snowflake, and VoltDB.
Added support for additional authentication options for Teradata.
Added support for creating and dropping triggers for SQLite.
Added support for creating and dropping packages for Oracle.
Added support for creating and dropping functions for PostgreSQL.
Added support for creating and dropping sequences for MySQL.
Added support for generating DDL for views, indexes, sequences, triggers, functions, procedures, and packages for various databases.
Database Tools
RazorSQL 8.4.0 has also enhanced the database tools that allow users to perform various tasks on database objects and data. Some of the improvements are:
A multi-table database data search tool that allows users to search for data across multiple tables or views in a database.
A data compare tool that allows users to compare table data across databases or compare the results of queries.
An edit table tool that allows users to insert, update, and delete table data in a spreadsheet-like format.
A copy/backup table tool that allows users to copy or backup tables from one database to another.
A database conversion tool that allows users to convert database tables from one type to another.
SQL Editor
RazorSQL 8.4.0 has also improved the SQL editor that allows users to create and execute SQL queries and scripts. Some of the new features are:
An SQL query builder that allows users to create select, insert, update, and delete SQL statements using a visual interface.
An auto column and auto table lookup feature that provides suggestions for column names and table names as users type in the SQL editor.
A find and replace feature that allows users to find and replace data in the query results or the edit table tool.
A preview generated SQL feature that allows users to preview the SQL statements generated by the edit table tool or the data import/export tools.
RazorSQL 8.4.0 is a comprehensive and reliable SQL query tool that provides users with a wide range of features and options to work with various databases. It is available as a portable version that can run from a USB drive or as an installer version that can be installed on a computer. Users can download RazorSQL 8.4.0 from the official website or from the updates page.
a7a7d27f09