dbForge Edge Versionen

• Resolved clipboard data corruption when copying HTML data with duplicate column names.
• Fixed an issue that caused a parsing error in stored procedures.
• Fixed the Object Filter functionality in schema comparison console mode.

• Improved metadata processing for specific cultures.

• Fixed an issue that caused a cyclic dependency error.
• Resolved clipboard data corruption when copying HTML data with duplicate column names.
• Fixed the Object Filter functionality in schema comparison console mode.

• Resolved a cyclic dependency issue for functions and triggers in Schema Comparison.
• Resolved clipboard data corruption when copying HTML data with duplicate column names.
• Fixed the Object Filter functionality in schema comparison console mode.

• Added the MFA Application ID to the settings export.
• Added a separate Constraints group in Documenter.
• Changed variable priority in the completion list.

• Fixed a false-positive syntax error triggered by Transact-SQL expressions referencing objects named window.
• Fixed an issue with filtering in the command-line interface.
• Fixed the "Could not discover a user realm" error.
• Fixed an issue with the execution plan diagram.
• Resolved clipboard data corruption when copying HTML data with duplicate column names.
• Fixed the "Unknown type 'json'" error that could occur during data comparison.
• Fixed CRUD script generation for tables with NVARCHAR(MAX) and VARCHAR(MAX) columns.
• Fixed clipboard data corruption when copying data from Text Comparer.
• Fixed the Object Filter functionality in schema comparison console mode.
• Fixed an issue with errors in Source Control.

• Several minor bugs have been fixed.

• Several minor bugs have been fixed.

• Fixed incorrect alphabetical sorting of foreign key columns during schema comparison and synchronization.

• Added support for SSMS 22.6.

dbForge Studio for SQL Server

• AI Assistant
  • Improved AI Assistant by adding support for database index metadata.
• Schema Compare
  • Added the 'Discard Changes' option to the Objects Filter toolbar.
• Text Editor
  • Added the 'Enclose identifiers in quotes' feature to the SQL Editor.
  • Added indexed column icons in Quick Info.
• Improvements
  • Added the ability to pin document tabs.
  • Added the ability to restore document tab order.
  • Enabled data generation for columns with unsupported data types.
  • Updated the installation wizard to not display the "Successful Install" page during dbForge product updates.
  • Improved saving of window layouts and restoration of window positions after restarting the Studio.

dbForge Studio for MySQL

• AI Assistant
  • Improved AI Assistant by adding support for database index metadata.
• Schema Compare
  • Added the 'Discard Changes' option to the Objects Filter toolbar.
• Text Editor
  • Added the 'Enclose identifiers in quotes' feature to the SQL Editor.
  • Added index name suggestions in code completion.
  • Added indexed column icons in Quick Info.
  • Added the ability to pin document tabs.
• Improvements
  • Added the ability to restore document tab order.
  • Enabled data generation for columns with unsupported data types.
  • Added parsing support for the sys_refcursor pseudo-type.
  • Improved saving of window layouts and restoration of window positions after restarting the Studio.
  • Updated the installation wizard to not display the "Successful Install" page during dbForge product updates.

dbForge Studio for Oracle

• AI Assistant
  • Improved AI Assistant by adding support for database index metadata.
• Schema Compare
  • Added the 'Discard Changes' option to the Objects Filter toolbar.
• Text Editor
  • Added the 'Enclose identifiers in quotes' feature to the SQL Editor.
  • Added index name suggestions in code completion.
  • Added indexed column icons in Quick Info.
• Improvements
  • Added the ability to pin document tabs.
  • Added the ability to restore document tab order.
  • Enabled data generation for columns with unsupported data types.
  • Improved saving of window layouts and restoration of window positions after restarting the Studio.
  • Updated the installation wizard to not display the "Successful Install" page during dbForge product updates.

dbForge Studio for PostgreSQL

• New functionality
  • Introduced Query Builder for visual SQL query design.
  • Introduced Database Editor for visual database management.
  • Introduced Schema Editor for visual schema design and management.
  • Introduced Table Editor for visual table design and SQL preview.
• Schema Compare
  • Added Schema Mapping and Table Mapping pages to the New Schema Comparison wizard.
  • Added Options pages to the schema comparison and synchronization wizards.
  • Added the 'Discard Changes' option to the Objects Filter toolbar.
  • Added support for index comparison and synchronization on tables and materialized views.
  • Added broader server support for comparison tasks.
  • Improved support for GENERATED { BY DEFAULT | ALWAYS } AS IDENTITY columns.
• AI Assistant
  • Improved AI Assistant by adding support for database index metadata.
• Text Editor
  • Added the 'Enclose identifiers in quotes' feature to the SQL Editor.
  • Added syntax highlighting for PostgreSQL dollar-quoted blocks.
  • Added index name suggestions in code completion.
  • Added indexed column icons in Quick Info.
• Improvements
  • Added the ability to pin document tabs.
  • Added the ability to restore document tab order.
  • Enabled data generation for columns with unsupported data types.
  • Added support for the dec (n, m) type in the PostgreSQL parser.
  • Added support for multiple SELECT result sets and RAISE NOTICE output within a single session.
  • Improved saving of window layouts and restoration of window positions after restarting the Studio.
  • Removed the automatic execution of ROLLBACK when closing a connection.
  • Added support for the ANALYSE keyword in the EXPLAIN clause grammar.
  • Extended parsing support for the CREATE INDEX expression syntax to include NULLS NOT DISTINCT.
  • Updated the installation wizard to not display the "Successful Install" page during dbForge product updates.

dbForge Studio for SQL Server

• Fixed an issue where the document database was lost for recovered documents.
• Fixed an error that occurred when the Document Database differed from the actual connection database.
• Fixed the behavior of the "SQL Look In" option in the Find and Replace control.
• Fixed MFA authentication when connecting under different user accounts.
• Fixed an error in the data editor that occurred when executing a modified query before the previous query had finished fetching data.
• Fixed an issue with the "Recent files" list.
• Fixed the auto-hint behavior for server selection on the Connection form.

dbForge Studio for MySQL

• Fixed the behavior of the "SQL Look In" option in the Find and Replace control.
• Fixed an error in the data editor that occurred when executing a modified query before the previous query had finished fetching data.
• Fixed data comparison for BINARY data types.
• Fixed an issue in the Procedure Editor when editing procedures with invalid syntax.
• Fixed an error report that appeared when clicking Send to Query from the Where Condition field.
• Fixed an error that occurred when working with projects that contain unnamed indexes.

dbForge Studio for Oracle

• Fixed the behavior of the "SQL Look In" option in the Find and Replace control.
• Fixed navigation to objects inside a Package Body.
• Fixed an issue with the "Recent files" list.
• Fixed an exception that occurred in the Data Export wizard when navigating directly to the Data Formats page.
• Fixed an error in the data editor that occurred when executing a modified query before the previous query had finished fetching data.

dbForge Studio for PostgreSQL

• Fixed an error in the data editor that occurred when executing a modified query before the previous query had finished fetching data.
• Fixed the Find and Replace control to restore its settings after restart.
• Fixed the behavior of the "Ignore whitespace" option in the Schema Comparison Wizard.
• Fixed the behavior of the "SQL Look In" option in the Find and Replace control.

dbForge Studio for PostgreSQL

• Added support for the VARIADIC syntax for SQL Document.

dbForge Studio for SQL Server

• Fixed the Look In drop-down list in the Find and Replace window.
• Fixed an issue where forcing a debug stop terminated the entire debugger session.
• Fixed an issue with query execution in Query Builder that occurred after values were edited.
• Fixed duplicate INSERT privileges in Security Manager.
• Fixed an error occurring when working with Source Control.

dbForge Studio for MySQL

• Fixed an issue that caused long response times from MySQL and MariaDB servers when executing certain queries that referenced non-existent objects.
• Fixed script generation for MySQL PARTITION BY LIST COLUMNS.

dbForge Studio for Oracle

• Fixed the display of row-level differences in schema comparison results.

dbForge Studio for SQL Server

• Fixed an issue that occurred when comparing columns with the TIMESTAMP and ROWVERSION types; their equivalence in SQL Server is now taken into account.

dbForge Studio for MySQL

• Several minor bugs have been fixed.

dbForge Studio for Oracle

• Several minor bugs have been fixed.

dbForge Studio for PostgreSQL

• Fixed an issue that occurred when comparing string-type columns in PostgreSQL; COLLATE attribute comparison is temporarily disabled until full support is implemented.

dbForge Studio for SQL Server

• Added support for the FORCESEEK table hint in FROM clauses for the Text Editor.

dbForge Studio for MySQL

• Improved support for SET TRANSACTION syntax on MySQL and MariaDB servers.
• Simplified the behavior of database object editors when saving changes fails. The editor now stays in its pre-save state, with options to refresh it with the current object from the server, reapply the same changes, or generate them as a script for troubleshooting.

dbForge Studio for SQL Server

• Fixed queries for retrieving foreign keys for the schema comparison.
• Resolved issues related to auto-formatting of built-in functions.

dbForge Studio for Oracle

• Fixed an Error Report issue that occurred when running Compile from the Debug menu.
• Fixed an Error Report issue that occurred when working with the Schema Export wizard.

dbForge Studio for PostgreSQL

• Resolved an issue that caused identical Amazon Redshift tables to be treated as different during the schema comparison.