Meet SQL Tools v6.0 with Massive Updates

June 17th, 2021

We are delighted to inform our dbForge for SQL Server users that we have just released the hugely updated pack of our SQL Server tools, dbForge SQL Tools, v.6.0. Take a sneak peek of new features and improvements introduced in this release!

To quickly navigate to a certain product-specific section of the article, click a product name from the list below:

dbForge Schema Compare v5.1

Redesigned Progress Window for Schema Comparison and Synchronization

The updated dbForge Schema Compare for SQL Server features drastically redesigned progress schema comparison and synchronization windows with the sequential list of processes taking place and specification of time elapsed.

In-place SQL Formatting Option for the Text Compare Control

The new option allows formatting database object scripts right in Text Compare.

Pre/Post-scripts execution tab in Schema Synchronization Wizard

Schema Synchronization Wizard now includes the Additional Scripts tab that can be used to add additional scripts executed before and/or after data synchronization. You can either import the necessary scripts or enter them directly in Schema Synchronization Wizard.

Append Timestamp to the File Name option in Schema Synchronization Wizard

The Append timestamp to the file name option has been added to the Output tab of Schema Synchronization Wizard. When enabled, the option adds date and time to the generated schema sync script file.

Formatting Profiles Added

The tool includes the span-new formatting profiles that let you tune your SQL code like never before. Now you can not only format your code exactly as you want but also switch quickly to an alternative style or apply formatting specifically to certain parts of your SQL script if required.

Options Search

The Options Window has been improved with the Search box for instant navigation to an option you need to configure at the moment.

Ignore History Tables Option

The option allows ignoring properties of history tables during comparison and synchronization.

Integration into MS SSMS v18.9

Azure SQL Managed Instance Connectivity Support

dbForge Data Compare v5.1

Redesigned Progress window for Data Comparison and Synchronization

Exclude Newly Added Objects Option in Data Compare Wizard

When this newly added option is enabled, dbForge Data Compare for SQL Server deploys only those tables and views that are explicitly included in the saved comparison project (*.dcomp). This allows you to make sure that those objects that were added to a database after the comparison project had been created will not get into synchronization.

Tolerance Interval Option in Data Compare Wizard

The option allows specifying the module of difference between the values of source and target. If it does not exceed the specified value, the values are considered equivalent.

Pre/Post-scripts Execution Tab in Data Synchronization Wizard

New Formatting Profiles

Options Search

Integration into MS SSMS v18.9

Azure SQL Managed Instance Connectivity Support

dbForge Data Generator v4.3

Redesigned Progress Window for Data Generation

New Formatting Profiles

Options Search

Integration into MS SSMS v18.9

Azure SQL Managed Instance Connectivity Support

dbForge Query Builder v3.16

New Formatting Profiles

Options Search

Data Export to CSV

dbForge Query Builder for SQL Server now includes an option to export the Query Execution History to a .csv file.

Azure SQL Managed Instance Connectivity Support

dbForge Documenter v1.5

Auto-line-break of long headings

In the updated dbForge Documenter for SQL Server, the Auto-line-break of Long Headings improvement is introduced. The improvement makes the whole name of the document displayed and hence gives you more clarity when working with the database documentation.

New Formatting Profiles

Options Search

Integration into MS SSMS v18.9

Azure SQL Managed Instance Connectivity Support

dbForge Source Control v2.3

Redesigned Data Diff Control

Viewing of exact data differences has become more smooth and clear In dbForge Source Control v2.3: tabs of the grid became more informative with more crisp data differences highlighting.

Redesigned Objects Text Diff Control

The coloring model of diffs highlighting simplifies and speeds up the whole schema comparison process.

Integration into MS SSMS v18.9

Azure SQL Managed Instance Connectivity Support

dbForge SQL Complete v6.8

Support for WITH INLINE for CREATE OR ALTER FUNCTION

The WITH INLINE construct is prompted in the completion list for CREATE OR ALTER FUNCTION.

Support for APPROX_COUNT_DISTINCT

The function is prompted in the completion list and is available in the Parameter information.

Support for ALLOW_BATCH_MODE

ALLOW_BATCH_MODE is listed in the OPTION ( USE HINT ( ->  hint list.

Integration into MS SSMS v18.9

Azure SQL Managed Instance Connectivity Support

dbForge Unit Test v1.6

Integration into MS SSMS v18.9

Azure SQL Managed Instance Connectivity Support

Integration into MS SSMS v18.9

Azure SQL Managed Instance Connectivity Support

dbForge Index Manager v1.11

Integration into MS SSMS v18.9

Azure SQL Managed Instance Connectivity Support

dbForge Monitor v1.3

Integration into MS SSMS v18.9

Azure SQL Managed Instance Connectivity Support

dbForge Data Pump v1.6

Data Export/Import to Google Sheets

The updated dbForge Data Pump allows you to easily migrate table data between your SQL tables and Google Spreadsheets. All you need to do is to specify the URL/ID of your Google Spreadsheets table, and our handy Data Export Wizard and Data Import Wizard will do the rest of the work for you!

Information about the Export Format is Added to the Data Export Wizard Header

Output Settings Tab is Added to Data Export Wizard

Integration into MS SSMS v18.9

Azure SQL Managed Instance Connectivity Support

dbForge DevOps Automation v1.1

dbForge DevOps Automation PowerShell features the following new cmdlets:

Class Register-DevartTools

Class Unregister-DevartTools

The cmdlet helps to deactivate any of the tools included in SQL Tools.

Availability

Download the new version of dbForge SQL Tools and share your thoughts about the product. Your feedback helps us find the right direction with future updates and improve the tools according to the needs of our users.

Leave a Comment