What’s New in dbForge Query Builder for SQL Server, v3.5

SQL Server 2012 LocalDB is now supported

Query Profiler

Query bottlenecks will be easy to find with this tool, as it allows viewing query execution statistics. After you apply improvements, you can compare the current statistics with the previous results to consider if your changes were effective.

Generate Script As

Generate template SQL SELECT, UPDATE, INSERT, DELETE scripts for tables to simplify working with database objects. You can access this option from the context menu of Database Explorer.

Data export functionality to a CSV file is added

Now you can use column separator: tab, space, custom.

Bug Fixes

  • Incorrect trial on Windows 8 is fixed
  • Incorrect behaviour with identity columns on adding data in Data Editor is fixed
  • The navigation from the Error List to the specific error in a script 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
  • Error on changing connection in SQL document is fixed
  • Error on setting alias name in upper case is fixed
  • Work with memory is improved while redirecting data to the Output window
  • Syntax error on executing the current statement using the Execute Current Statement command is fixed
  • Syntax error on executing a script with @@ variables is fixed
  • A problem with saving a file’s encoding is fixed
  • A problem with the installation of the product is fixed
  • A problem related to the focus, while executing several statements is fixed
  • A problem with highlighting of the IIF function is fixed
  • A problem in data editor with not assigning default values is fixed
  • A problem with clearing memory on selecting data from table is fixed
  • A problem with running the application on .NET Framework 4.5 is fixed
  • A problem with removing a record in Data Editor is fixed
  • A problem with generating a schema name when exporting data using the MERGE mode is fixed
  • A problem with applying a filter in Data Editor is fixed
  • A problem with saving the Splitting options is fixed
  • A problem with changing options for code editor is fixed
  • A problem with connection to TFS 11 is fixed
  • A problem with displaying ‘Code Completion’ options is fixed
  • A problem with punctuation’s visibility in code editor with black background being set is fixed
  • OutOfMemoryException on searching data in Data Editor is fixed
  • ArgumentNullException on finding the next occurrence in text is fixed
  • ArgumentException on opening a file through the command line is fixed
  • SqlTypeException on executing stored procedure with data entered out of the permissible range
  • FileNotFoundException on opening the New File window is fixed
  • NullReferenceException on editing data in the Data Editor is fixed
  • NullReferenceException while working with a query that contains PIVOT (in Query Builder) is fixed
  • NullReferenceException on executing a query is fixed
  • NullReferenceException on editing a table in the editor is fixed
  • NullReferenceException on invoking Help in the Command Line is fixed
  • NullReferenceException on adding rows in Data Editor is fixed
  • NullReferenceException on retrieving data from the tables containing a BIGINT field is fixed
  • NullReferenceException on trying to find a search pattern in a document is fixed
  • NullReferenceException on executing a script is fixed
  • NullReferenceException on opening the SMTP options page is fixed
  • NullReferenceException on profiling a query is fixed
  • NullReferenceException on searching a text in SQL document is fixed
  • NullReferenceException in Query Builder is fixed
  • NullReferenceException on creating a SELECT query in Query Builder is fixed
  • InvalidCastException on editing a subquery in Query Builder is fixed
  • InvalidCastException on double-clicking a table in Database Explorer is fixed
  • InvalidOperationException on executing a script is fixed
  • InvalidOperationException while executing queries on SQL Azure is fixed
  • InvalidOperationException on editing data in Data Editor is fixed
  • InvalidOperationException on refreshing data in Database Explorer is fixed
  • InvalidOperationException on closing a connection with invalid transaction is fixed
  • InvalidOperationException on executing a query is fixed