dbForge Query Builder for SQL Server History

7.0.249 14-Nov-24

User-reported bug fixes

Modified snippet sorting in the code completion list (D164982)

7.0.210 18-Oct-24

User-reported bug fixes

Several minor bugs are fixed

7.0.158 05-Sep-24

Connectivity

Renamed the Azure Active Directory authentication type to Microsoft Entra ID
Added support for ApsaraDB

SQL Query History

Redesigned the SQL Query history toolbar with an updated date range selection and a new Clear button
Added the ability to save user-defined column layouts in Query History

Documents

Added options to rearrange tab opening order
Added new options in Tabs and Windows: Tab layout, Show tabs in multiple rows, and Close tabs with middle-click
Added a new shortcut CTRL+SHIFT+/ that comments selected pieces of code

Data Editor

Added an option to set a cell value to a unique identifier from the shortcut menu

User-reported bug fixes

Restored the Active format profile menu group of options in the context menu of the SQL document (D152917)
Fixed the tooltip in the Query Builder by removing objects from other databases (D134219)
Fixed an error that occurred when copying and pasting subqueries in Query Builder (D144556)
Fixed the display of operators in the column selection window of the Query Builder (D97682)

4.2.35 12-Apr-24

User-reported bug fixes

Several user reported minor bugs are fixed

4.2.33 28-Dec-23

User reported bug fixes

Several user reported minor bugs are fixed

4.2.29 12-Jul-23

User reported bug fixes

Fixed an error that occurred when the SQL document was closed while processing the parameter list for functions
Expanded the list of conditions in the Filter Editor for columns of type int in the Data Editor
Resolved a freezing issue that occurred when editing values in large tables in Data Editor

4.2.25 12-May-23

User reported bug fixes

Several user reported minor bugs are fixed

4.2.22 30-Dec-22

New features and improvements

Support for macOS & Linux via CrossOver
Improved the metadata reading behavior - the VIEW DATABASE STATE privilege is no longer required (p135909, T308355, D71423, D98539, D103313)

User reported bug fixes

Fixed a bug that occurred when importing data (D99244, D99762)
Fixed the disappearance of the DESC keyword (D94579, D102637)

4.2.16 12-Sep-22

New features and improvements

Connectivity support for SQL Server 2022 CTP 2.1

4.2.10 20-Jul-22

User reported bug fixes

Fixed the behavior of shortcuts in SQL Editor

4.2.5 17-Jun-22

New features and improvements

Added support for new functions in the Completion List, Quick Info, and Parameter Information: GREATEST, LEAST, CURRENT_TIMEZONE, CURRENT_TIMEZONE_ID
Added support for the FORMATFILE_DATA_SOURCE parameter for bulk_options in the OPENROWSET function

User-reported bug fixes

Fixed an issue with the search and replacement of values in Data Editor (D76642)

4.1.5 21-Dec-21

New features and improvements

Improved the behavior of data sorting in Data Editor
Added the ability to resize the search text field
Added a warning when trying to save read-only files with the applied changes
Improved the display of table relationships on the Query Builder diagram

User-reported bug fixes

Incorrect change of a query when updating it in Query Builder
Fixed the behavior of pasting from clipboard when working with Query Builder

4.0.16 20-Oct-21

User reported bug fixes

The application fails with a critical error when trying to create diagram objects after installing the KB5006670, KB5006672 or KB5006674 Windows update

4.0.14 10-Sep-21

New features and improvements

Ability to simultaneously connect with different ApplicationIDs to Azure SQL Server

User-reported bug fixes

Incorrect change of a query when updating it in Query Builder
Error with canceling the operation in Data Editor
Improved behavior with the active Paste As New Records command in Data Editor
Improved behavior of active control of changing the current database when executing the query in SQL Document
Coloring of cells with the NULL values in Data Editor
Error when completing the procedure with parameters in Data Editor
Error when executing a query with parameters of the Date type in Paginal Mode in Data Editor
Error with specifying an incorrect value in the Filter window in Data Editor
Processing of the Ctrl+A, Ctrl+C shortcuts in Data Viewer

4.0.12 26-Aug-21

New features and improvements

Data Reports
Master-Detail Browser
Pivot Tables

3.16.45 16-Jun-21

New features and improvements

New formatting profiles
Options search
Data export to CSV

3.15.78 08-Oct-19

User reported bug fixes

Several user reported bugs are fixed

3.15.55 27-Jun-19

User reported bug fixes

Several user reported bugs are fixed

3.15.42 10-May-19

User reported bug fixes

Problem with query opening is fixed (T277169)
Minor user reported bugs are fixed

3.15.30 20-Feb-19

New features and improvements

Support for the Active Directory - Universal with MFA authentication

User reported bug fixes

Several user reported bugs are fixed

3.14.29 21-Dec-18

New features and improvements

Connectivity support for SQL Server 2019
Product now integrates into SSMS v18

User reported bug fixes

Problem with activation is fixed (T240520)

3.12.56 19-Jul-18

User reported bug fixes

Text parsing is fixed (T256623)
Null Reference Exception is fixed (T253164)
User reported bug is fixed (T260608)

3.12.39 30-Aug-17

SQL Server 2016 Service Pack 1 (SP1) new syntax support
SQL Server 2017 new syntax support
Azure SQL Data Warehouse support
New query execution history feature saves information about SQL statement you run
Each document uses its own connection now

3.11.34 20-Apr-17

General improvements

Compliance with the Federal Information Processing Standard (FIPS)
Trial product activation implemented
Greatly improved visual style of the application with high DPI support
Connection to Microsoft Azure SQL Database by using identities in Azure Active Directory

Query Profiler

Live query statistics
Wait Stats tab
Saving/Opening execution plan files
Table I/O
Highlighting potentially resource-intensive statements
Displaying clustered columnstore indexes in execution plan

Data Export/Import

Dramatically improved data import performance
Export/import of JSON data
Redesigned export/import of XML data
Preview of the generated UPDATE script in the wizard
Detection of column types when importing data from the Excel format
Execution of SET IDENTITY_INSERT ON when the Repopulate option is enabled during data import

3.10.14 17-Aug-16

SQL Server 2016 support
Greatly improved suggestion performance
Objects suggestions in CROSS/OUTER APPLY statement
Several new formatter options and profiles
Data type information to the column header in Data Grid added
Data Grid now supports Generate Script As feature
Generate Script As now available for multiple objects in Database Explorer
Installation wizard redesigned
User reported bugs are fixed (T158724, T161047, T161500)

3.9.165 3-Jun-15

User reported bugs fixed
Performance and stability improvements

3.9.163 13-Nov-14

SQL Editing and Execution

Query execution pane
Easy way to hide results
Updated Find&Replace feature in documents and files

Data Editor

Data Viewer, LOB Editor, and Redirect Data to Output are combined in a single control
Zooming font size in Data Viewer and Editor Window

Database Explorer

Displaying the objects number

Query Profiler

Diagram printing options for a Query Profiler Plan Diagram

Data Export

Updated Export wizard

User Interface

Support of multiple monitors
New skins
Updated Start Page

Other Features and Improvements

Improved application performance
Windows 10 support

3.8.147 26-Jun-14

A problem related to opening existing queries is fixed (T107349)

3.8.140 20-Jun-14

The list of the new features includes

Microsoft SQL Server 2014 is supported
The ability to save and restore tabs is added
The ability to view columns and indexes in Object Explorer is added
Index Rebuild, Index Reorganize and Index Disable commands are added
Query plans can be saved visually
Results comparison is executed when the required elements are selected
Various queries plans can be shown vertically in one view when comparing
Buffer and plans cache refresh options are added
Zoom menu in the Profiler diagram is available

3.5.130 21-Nov-13

NullReferenceException on editing data in the Data Editor is fixed (T89961)
OutOfMemoryException on searching data in Data Editor is fixed (T88817)
Problem with the installation of the product is fixed (R28557)
The navigation from the Error List to the specific error in a script is fixed (T88471)

3.5.125 15-Oct-13

InvalidOperationException while executing queries on SQL Azure is fixed (T84559)
A problem related to the focus, while executing several statements is fixed (T84632)
A problem with highlighting of the IIF function is fixed (T84653)
NullReferenceException while working with a query that contains PIVOT (in Query Builder) is fixed (T84919)
Data export functionality to a CSV file is added. Now you can use column separator: tab, space, custom (T86071)
A problem related to the searching and replacing tabs and whitespaces is fixed (R28253)

3.5.120 19-Sep-13

NullReferenceException on adding rows in Data Editor is fixed (T84511)
NullReferenceException on retrieving data from the tables containing a BIGINT field is fixed (T74907, T75124, T75355, T75356, T75357, T75440, T83022)
Problem with saving a file's encoding is fixed (T83954)
NullReferenceException on executing a query is fixed (T83825, T84358, T84425, T84827)
Problem with removing a record in Data Editor is fixed (R26432)
Computed columns are now excluded from synchronization by default (T83409)
Error report when Estimated Rows exceeds the limits of integer in the Profiler document view is fixed (T83219)
Problem with generating a schema name when exporting data using the MERGE mode is fixed (T77218)

3.5.115 23-Aug-13

Problem in data editor with not assigning default values is fixed (T70859, R10060)
Problem with clearing memory on selecting data from table is fixed (T71228)
Problem with running the application on .NET Framework 4.5 is fixed (T75603)

3.5.105 12-Jul-13

NullReferenceException on editing a table in the editor is fixed (T72638)
NullReferenceException on invoking Help in the Command Line is fixed (R23315)
Error on changing connection in SQL document is fixed (R23354)
Work with memory is improved while redirecting data to the Output window (R22051)
InvalidCastException on editing a subquery in Query Builder is fixed (R20279)
The problem with applying a filter in Data Editor is fixed (T70060)
Incorrect behaviour with identity columns on adding data in Data Editor is fixed (T69095)

3.5.88 09-Apr-13

The problem with saving the Splitting options is fixed (T60064)
InvalidOperationException on executing a script is fixed (R17828)
The problem with changing options for code editor is fixed (T65707)
NullReferenceException on trying to find a search pattern in a document is fixed (R19287)
InvalidOperationException on editing data in Data Editor is fixed (T67547)
The problem with connection to TFS 11 is fixed (T61250)
The problem with punctuation's visibility in code editor with black background being set is fixed (T65696)
NullReferenceException on executing a script is fixed (T65230)
Syntax error on executing the current statement using the Execute Current Statement command is fixed (T68993)
Syntax error on executing a script with @@ variables is fixed (T62139)

3.5.68 15-Jan-13

NullReferenceException on opening the SMTP options page is fixed (T64010, T64950, T59614)
Problem with displaying 'Code Completion' options is fixed (T63344)
FileNotFoundException on opening the New File window is fixed (R15121)
SqlTypeException on executing stored procedure with data entered out of the permissible range (T64333)
InvalidCastException on double-clicking a table in Database Explorer is fixed (T64179)
Error on setting alias name in upper case is fixed (T15105)
NullReferenceException in Query Builder is fixed (T62199, T63974)
InvalidOperationException on refreshing data in Database Explorer is fixed (T60588)
NullReferenceException on creating a SELECT query in Query Builder is fixed (T63549)

3.5.46 08-Nov-12

SQL Server 2012 LocalDB is now supported (R14621)
ArgumentException on opening a file through the command line is fixed (T45824)
Incorrect trial on Windows 8 is fixed (T59119, T59496, T59563, T59698, T59827, T59847)
ArgumentNullException on finding the next occurrence in text is fixed (R13847)
NullReferenceException on profiling a query is fixed (T59489)
NullReferenceException on searching a text in SQL document is fixed (T59700)
InvalidOperationException on closing a connection with invalid transaction is fixed (R14818)

3.5.33 18-Sep-12

Query Profiler for locating bottlenecks and optimizing query execution time with advanced options unavailable in a standard tool added
Generate Script As in Database Explorer feature added
InvalidOperationException on executing a query is fixed (T42960, T41492)

3.0.20 18-Jul-12

Error "Object cannot be cast from DBNull to other types" on SQL server 2012 is fixed (T42098)
Start page scrolling bug is fixed

3.0.18 27-Apr-12

Query builder can now work with INSERT, UPDATE, and DELETE statements
Quick conversion of SELECT query into UPDATE or DELETE with preservation of WHERE expressions is added
Wrapping SELECT queries into INSERT ones is added
Execution of subqueries to check their validity inside a diagram is added
Transformation of selected data into SQL queries (for example, into INSERT queries) is added
Usability of the visual expression editor is improved
Label stating the type of statement is added to diagram
Editing of multiple execution results of one script on separate tabs is added
New start page is added

2.0.12 19-Oct-11

User reported bug fixes

Problems with trial checking are fixed

2.0.11 21-Jun-11

Customizable Data Export

Now, you can export data from one or even multiple tables at once to the following formats: CSV, DBF, HTML, MS Access, MS Excel, ODBC, PDF, RTF, Text, and XML. Before exporting you can customize export style attributes, such as text, background and border color, font, set output format of exported columns and preview the result.

Enhanced Data Editor

Sorting and grouping tables now works on a sever side
Ability to edit tables in JOIN statements is added
Ability to view tables united with a foreign key in a popup window is added
Many other minor improvements and extensions to existing functionality were made

User reported bug fixes

Behavior of the popup expression editor when working with functions was enhanced
Rows in the popup expression editor are automatically quoted now
NullReferenceException on editing a subquery in Query Builder was fixed (T25205)

1.00.40 20-May-10

Fixed bug with editing complex conditions

Fixed bug with updating text view on query design change

1.00.39 18-May-10

First release of dbForge Query Builder for SQL Server