Softpedia >Windows >Internet >Servers >Database Utils >dbForge Query Builder for SQL Server >  Changelog

dbForge Query Builder for SQL Server Changelog

What's new in dbForge Query Builder for SQL Server 4.2.35

Apr 12, 2024
  • Several user reported minor bugs are fixed

New in dbForge Query Builder for SQL Server 4.2.33 (Dec 28, 2023)

  • Several user reported minor bugs are fixed.

New in dbForge Query Builder for SQL Server 4.2.29 (Jul 12, 2023)

  • 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

New in dbForge Query Builder for SQL Server 4.2.25 (May 12, 2023)

  • Several user reported minor bugs are fixed.

New in dbForge Query Builder for SQL Server 4.2.22 (Dec 30, 2022)

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

New in dbForge Query Builder for SQL Server 4.2.16 (Sep 12, 2022)

  • New features and improvements:
  • Connectivity support for SQL Server 2022 CTP 2.1

New in dbForge Query Builder for SQL Server 4.2.10 (Jul 20, 2022)

  • Fixed the behavior of shortcuts in SQL Editor

New in dbForge Query Builder for SQL Server 4.2.5 (Jun 20, 2022)

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

New in dbForge Query Builder for SQL Server 4.1.5 (Dec 21, 2021)

  • New features and improvements:
  • Improved the behavior of data sorting in Data Editor
  • Added the ability to resize the search text field
  • 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

New in dbForge Query Builder for SQL Server 4.0.16 (Oct 20, 2021)

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

New in dbForge Query Builder for SQL Server 4.0.12 (Aug 29, 2021)

  • New features and improvements:
  • Data Reports
  • Master-Detail Browser
  • Pivot Tables

New in dbForge Query Builder for SQL Server 3.16.45 (Jun 19, 2021)

  • New features and improvements:
  • New formatting profiles
  • Options search
  • Data export to CSV

New in dbForge Query Builder for SQL Server 3.15.78 (Oct 10, 2019)

  • Several user reported bugs are fixed

New in dbForge Query Builder for SQL Server 3.15.55 (Jul 1, 2019)

  • Several user reported bugs are fixed

New in dbForge Query Builder for SQL Server 3.15.42 (May 10, 2019)

  • User reported bug fixes:
  • Problem with query opening is fixed (T277169)
  • Minor user reported bugs are fixed

New in dbForge Query Builder for SQL Server 3.15.30 (Feb 20, 2019)

  • New features and improvements:
  • Support for the Active Directory - Universal with MFA authentication
  • User reported bug fixes:
  • Several user reported bugs are fixed

New in dbForge Query Builder for SQL Server 3.14.29 (Dec 23, 2018)

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

New in dbForge Query Builder for SQL Server 3.12.56 (Jul 20, 2018)

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

New in dbForge Query Builder for SQL Server 3.12.39 (Aug 31, 2017)

  • 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

New in dbForge Query Builder for SQL Server 3.11.34 (Apr 21, 2017)

  • 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

New in dbForge Query Builder for SQL Server 3.10.14 (Aug 19, 2016)

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

New in dbForge Query Builder for SQL Server 3.9.165 (Aug 19, 2016)

  • User reported bugs fixed.
  • Performance and stability improvements.

New in dbForge Query Builder for SQL Server 3.9.163 (Nov 14, 2014)

  • 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

New in dbForge Query Builder for SQL Server 3.8.147 (Jun 30, 2014)

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

New in dbForge Query Builder for SQL Server 3.8.144 (Jun 23, 2014)

  • 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

New in dbForge Query Builder for SQL Server 3.5.130 (Dec 6, 2013)

  • NullReferenceException on editing data in the Data Editor is fixed
  • OutOfMemoryException on searching data in Data Editor is fixed
  • Problem with the installation of the product is fixed
  • The navigation from the Error List to the specific error in a script is fixed

New in dbForge Query Builder for SQL Server 3.5.125 (Dec 6, 2013)

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

New in dbForge Query Builder for SQL Server 3.5.120 (Sep 26, 2013)

  • NullReferenceException on adding rows in Data Editor is fixed
  • NullReferenceException on retrieving data from the tables containing a BIGINT field is fixed
  • Problem with saving a file's encoding is fixed
  • NullReferenceException on executing a query is fixed
  • Problem with removing a record in Data Editor is fixed
  • Computed columns are now excluded from synchronization by default
  • Error report when Estimated Rows exceeds the limits of integer in the Profiler document view is fixed
  • Problem with generating a schema name when exporting data using the MERGE mode is fixed

New in dbForge Query Builder for SQL Server 3.5.115 (Aug 23, 2013)

  • Problem in data editor with not assigning default values is fixed
  • Problem with clearing memory on selecting data from table is fixed
  • Problem with running the application on .NET Framework 4.5 is fixed

New in dbForge Query Builder for SQL Server 3.5.105 (Jul 12, 2013)

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

New in dbForge Query Builder for SQL Server 3.5.88 (Jun 13, 2013)

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

New in dbForge Query Builder for SQL Server 3.5.68 (Jan 15, 2013)

  • NullReferenceException on opening the SMTP options page is fixed
  • Problem with displaying 'Code Completion' options is fixed
  • FileNotFoundException on opening the New File window is fixed
  • SqlTypeException on executing stored procedure with data entered out of the permissible range
  • InvalidCastException on double-clicking a table in Database Explorer is fixed
  • Error on setting alias name in upper case is fixed
  • NullReferenceException in Query Builder is fixed
  • InvalidOperationException on refreshing data in Database Explorer is fixed
  • NullReferenceException on creating a SELECT query in Query Builder is fixed

New in dbForge Query Builder for SQL Server 3.5.46 (Nov 12, 2012)

  • SQL Server 2012 LocalDB is now supported
  • ArgumentException on opening a file through the command line is fixed Incorrect trial on Windows 8 is fixed
  • ArgumentNullException on finding the next occurence in text is fixed NullReferenceException on profiling a query is fixed
  • NullReferenceException on searching a text in SQL document is fixed InvalidOperationException on closing a connection with invalid transaction is fixed

New in dbForge Query Builder for SQL Server 3.5.33 (Sep 18, 2012)

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

New in dbForge Query Builder for SQL Server 3.0.21 (Jul 24, 2012)

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

New in dbForge Query Builder for SQL Server 3.0.18 (Jun 28, 2012)

  • 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

New in dbForge Query Builder for SQL Server 2.0.12 (Nov 2, 2011)

  • Problems with trial checking are fixed

New in dbForge Query Builder for SQL Server 2.0.11 (Jun 28, 2011)

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

New in dbForge Query Builder for SQL Server 1.0.43 (Sep 3, 2010)

  • Fixed bug on openning Selection Editor
  • Fixed default layout
  • Paginal mode is enabled by default