dbForge SQL Tools

Score6.7 out of 10

26 Reviews and Ratings

What is dbForge SQL Tools?

The dbForge SQL Tools package comprises 15 functional add-ins for SQL Server Management Studio (SSMS) and standalone tools. These add-ins integrate with this default IDE, enhancing the standard capabilities by adding new features and improving existing tools with additional options.

dbForge SQL Tools cover a wide array of database-related tasks in SQL Server, particularly in the following areas:

T-SQL coding assistance

Database schema & data comparison and synchronization

Deploying changes onto on-premise and cloud platforms

Source control with all popular version control systems support

High-quality test data generation

Automatic database documenting

DevOps automation

Index analysis and management

Incorporating SQL Tools allows users to perform a broader range of tasks directly within familiar interfaces in visual mode, eliminating the need for extensive code typing.

Once installed, dbForge SQL Tools are accessible in SSMS through dedicated tabs and context menus for tables and databases. All tools feature SSMS-like visual interfaces, making them easier to learn and use.

Categories & Use Cases

Media

1 / 19

Scott Kennedy View profile

Director, eCommerce Analytics and Digital Marketing in Marketing at Franklin Sports (201-500 employees employees)

Pros

Speeds up coding process
SQL formatter cleans up code for readability
Works nicely inside of tools you already own.

Cons

There is a lag in the intellisense from time to time
The phrase completion doesn't work perfect all the time
The JOIN clause auto generation isn't correct all the time

Most Important Features

Disable/enable code completion
Name suggestions for linked servers
Keeping track of recently closed documents

Return on Investment

Code readability has improved, decreasing errors
Code speed has improved, allowing projects to finish faster
QC'ing code has become much faster

Alternatives Considered

Snowflake and DbVisualizer

Other Software Used

Snowflake, DbVisualizer, Oracle Enterprise Manager

Simon Kingaby View profile

Manager, Global Data & Analytics in Information Technology at Deloitte Global (10,001+ employees employees)

Pros

SQL Formatter
Generate Script As
SQL Completion and Suggestion

Cons

Better support for Azure Data Studio would be nice
Integration with Azure Synapse Analytics would also be cool

Most Important Features

SQL Formatter
Code Completion
It's many productivity extensions

Return on Investment

SQL Complete saves us a lot of time in a lot of little ways

Other Software Used

Microsoft Visual Studio Code, Microsoft SQL Server, Notepad++

Verified User

Team Lead (501-1000 employees employees)

Pros

Great Tool that really helps to increase our productivity.
Provides advanced IntelliSense to speed up the development.
Provides code competition, formatting and refactoring.
Using advance mechanism to write joins with shortcuts.
Great feature of color indicator for different environment(Dev, Production, Test)
Customized your formatting rules.

Cons

Sometimes shortcuts are not properly loaded.
Sometimes it is getting stuck.
Improvement need on SSMS intelligence.

Most Important Features

Return on Investment

Speed up development and on time production releases.
Cost effective and quick support for your queries.
Performance is very good dB developer to love to work in this tool.

Verified User

Consultant in Information Technology (10,001+ employees employees)

Pros

CICD
Allows developers to work with their style of coding.

Cons

Old dated product, not handling modern structures.
Limited formatting options.
No interest from vendor in making improvements.

Most Important Features

Code formatting.
Command line option.

Return on Investment

It's had zero impact on productivity.

Verified User

Professional in Information Technology (201-500 employees employees)

Pros

Metadata gathering & presentation.
Code formatting.
Connection tab color coding.

Cons

Sometimes it can be slow to retrieve the database metadata.
Updating the software with the activation/deactivation of licenses could be further streamlined.

Most Important Features

Code completion
Code formatting
Connection color coding

Return on Investment

Improve development speed.
Reduced coding errors.

Other Software Used

dbForge Event Profiler for SQL Server

ApexSQL by Quest

dbForge SQL Tools