Released: Jan 30, 2023

Atualizações na V3.0.472

Recursos

• Added support for Linux and Apple macOS using CrossOver.
• Added new Professional Edition, which includes:
  • Data Compare.
  • Schema Compare.
  • Data Generator.
  • Export of Query History to the CSV format.
  • Command-line support for the following functionality: Data Compare, Schema Compare, Data Generator, Execute Large Scripts, as well as Data Export and Import.
• Text Editor enhancements:
  • Added support for SELECT INTO statement.
  • Added suggestions for the names of non-aggregated columns in the GROUP BY clause.
  • Added quick navigation between brackets.
  • Added support for Ctrl+C/X/V hotkeys for coping/cutting entire line in SQL documents.
  • Introduced a triple-click to select the entire line in SQL documents.
  • Added support for RAISE [ NOTICE | WARNING | INFO ] to trace userscript messages in the Error List & Output windows.
  • Added pop-up execution notifications.
  • Added transaction reminders.
  • Added capability to set quotes for identifiers when generating scripts.
  • Added support for Amazon Redshift database query profiling.
  • Added the auto-refresh of local cache with an option to ignore selected databases.
• Added connectivity support for PostgreSQL 15.
• Extended support for high-DPI devices.
• Improved the behavior of the Retrieve Data feature.
• Added connectivity support for AWS Babelfish, YugabyteDB, Neon.tech, Digitalocean Managed Databases, CitusData, ApsaraDB, PolarDB, AnalyticDB and Bit.io.
• Added support for query profiling on older versions of PostgreSQL.
• Added shortcuts to switch between SQL Document tabs.
• Added the Owner Use field for procedures and functions in the Properties window.
• Improved data comparison performance in Data Compare.
• Improved Data Editor functionality.
• Extended the query execution error message with more detailed information.
• Added the possibility to make changes to a document connection after deleting a database.

Correções

• Fixed an error with an incorrect sequence of disabling restrictions that occurred during data synchronization.
• Resolved an issue that occurred when importing data from a OneDrive spreadsheet.
• Fixed an issue that took place while working with the trial version.
• Fixed an error that occurred when connecting to a PostgreSQL database hosted on DigitalOcean.
• Fixed an error that occurred when exporting data that contain accent marks.
• Fixed the retrieval of high-precision floating-point numbers.
• Fixed application freezing that occurred when getting data from a table with a TEXT column.
• Fixed application freezing.
• Fixed an error that occurred when opening the Start Page window.
• Fixed an error that occurred on application launch.
• Fixed an error that occurred when retrieving data for a 'scale' table.
• Resolved the Drag & Drop issue in Database Explorer.
• Fixed a bug with the activation of the JSON tab for the JSON and JSONB data types when viewing data in Data Viewer.
• Fixed an error that occurred when retrieving data from array columns.
• Fixed an error that occurred when establishing a server connection.
• Fixed comparison and synchronization of the RESTRICT, CASCADE, and NO ACTION values for foreign keys in Schema Compare.
• Fixed Data Editor context menu.
• Fixed metadata retrieval for Code Completion.
• Substituted the error that occurred when trying to access the pg_shadow schema in Schema Compare without proper rights with a warning.
• Fixed an error that occurred when removing a connection from Database Explorer using the keyboard shortcuts.
• Fixed an error that occurred when comparing the data types of procedure parameters.
• Fixed the retrieval of database objects on older versions of PostgreSQL.
• Removed extra brackets in the generated view script.
• Fixed an error that occurred when exporting data.
• Fixed an error that occurred when importing data from Excel.
• Fixed an error that occurred when using the DESCRIBE command in Schema Compare.
• Fixed the Ignore Case option in Data Compare.
• Resolved an issue with table columns comparison.
• Fixed an error that occurred when getting DDL of an inherited table.
• Fixed an error that occurred when opening a SQL document with query profiling results.
• Fixed the display of query execution time.