Skip to main content
TrustRadius
dbForge SQL Tools

dbForge SQL Tools

Overview

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.…

Read more
Recent Reviews

TrustRadius Insights

dbForge SQL Complete has proven to be an invaluable tool for SQL developers across a wide range of use cases. Users have found that the …
Continue reading

Sql Complete Review

8 out of 10
July 12, 2021
Incentivized
  • SQL Complete is used across the entire organization
  • It adds value to the IntelliSense and scripting tasks within SQL Server Management …
Continue reading
Read all reviews
Return to navigation

Pricing

View all pricing

Subscription Standart 1 year

$429.95

On Premise

Subscription Professional 1 year

$649.95

On Premise

Perpetual Standard 1 year

$849.95

On Premise

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://www.devart.com/dbforge/sql/sql…

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Starting price (does not include set up fee)

  • $429.95 per year
Return to navigation

Product Details

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.

dbForge SQL Tools Features

  • Supported: SQL autocompletion, formatting, and refactoring
  • Supported: Comparison and synchronization of table data
  • Supported: Analysis and fixing of SQL index fragmentation
  • Supported: Generation of meaningful, realistic test data
  • Supported: Reduction of database development and release costs via DevOps Automation

dbForge SQL Tools Screenshots

Screenshot of Screenshot of Screenshot of Screenshot of Screenshot of

dbForge SQL Tools Video

dbForge SQL Tools is a database development toolset designed to increase the daily productivity of developers. These tools offer functionality for SQL Server development and administration, as well as integration with SQL Server Management Studio and Visual Studio. A Continu...
 Show More

dbForge SQL Tools Integrations

dbForge SQL Tools Competitors

dbForge SQL Tools Technical Details

Deployment TypesOn-premise
Operating SystemsWindows
Mobile ApplicationNo
Supported LanguagesEnglish

Frequently Asked Questions

dbForge SQL Tools starts at $429.95.

ApexSQL by Quest are common alternatives for dbForge SQL Tools.

The most common users of dbForge SQL Tools are from Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(25)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

dbForge SQL Complete has proven to be an invaluable tool for SQL developers across a wide range of use cases. Users have found that the intellisense feature significantly speeds up the process of writing SQL code, allowing them to write queries more efficiently and with fewer errors. The SQL Formatter, Intelligent SQL completion, and Tab Coloring features are particularly well-liked by users, as they assist in maintaining consistent code formatting and avoid accidental errors. Additionally, the Generate Script As feature has received high praise for its ability to quickly turn query results into IN or SELECT clauses.

The tool is not limited to a single project but is utilized by all developers in the IT department who work with databases. It has greatly improved productivity by speeding up database development and query time through autocomplete and code snippets. Users appreciate the real-time formatting suggestions, correct keyword and database suggestions, spell-checking capabilities, and execution history tracking. With the ability to customize formatting rules and store templates for reuse, dbForge SQL Complete allows developers to work with their personal style while adhering to a consistent CICD style.

Overall, dbForge SQL Complete has become an essential tool for many users who rely on it daily to simplify their work within SQL Server Management Studio. By reducing manual efforts, improving code accuracy, and enhancing programmer efficiency, this tool has made a significant impact on the productivity of SQL developers throughout the organization.

SQL Formatter: Improves Coding Process and Code Readability Several users have found that the SQL formatter in the product speeds up their coding process and improves code readability. It provides out-of-the-box formatting capabilities and allows for detailed customization of formatting options. Seamless Integration with Existing Tools: Convenient to Use Reviewers appreciate that the product can be seamlessly integrated into existing tools, making it convenient to use. This feature enhances productivity by eliminating the need for switching between different software. Intelligent Code Suggestions with SQL Completion and Suggestion Feature The SQL Completion and Suggestion feature has been praised by many users for providing intelligent code suggestions, including foreign key navigation. This simplifies the process of writing JOIN statements and enhances development speed.

Intellisense and phrase completion lag: Some users have experienced occasional delays in the intellisense and phrase completion features, resulting in a less smooth coding experience. These lags can disrupt the workflow and hinder productivity.

Incorrect JOIN clause auto generation: Several reviewers have reported that the automatic generation of JOIN clauses is not always accurate. This can lead to errors or inefficiencies when writing queries, requiring manual intervention to correct them. It adds an extra step in the query writing process and can be time-consuming for users.

Limited support for Azure Data Studio and Azure Synapse Analytics: Customers have expressed their desire for better support and integration with Azure Data Studio and Azure Synapse Analytics. They feel that improvements are needed to enhance compatibility and functionality between these platforms. The lack of seamless integration impacts their ability to effectively work with these tools, limiting their overall efficiency and effectiveness in managing databases.

Reviews

(1-9 of 9)
Companies can't remove reviews or game the system. Here's why
Score 8 out of 10
Vetted Review
Verified User
  • 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.
  • Sometimes shortcuts are not properly loaded.
  • Sometimes it is getting stuck.
  • Improvement need on SSMS intelligence.
Scott Kennedy | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Speeds up coding process
  • SQL formatter cleans up code for readability
  • Works nicely inside of tools you already own.
  • 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
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Metadata gathering & presentation.
  • Code formatting.
  • Connection tab color coding.
  • Sometimes it can be slow to retrieve the database metadata.
  • Updating the software with the activation/deactivation of licenses could be further streamlined.
July 12, 2021

Sql Complete Review

Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • Object Model browsing
  • Table Hint and Object suggestions
  • Code Formatting
  • Cache Refresh could be faster and more accurate
  • For each version update, I'd like to not bring back the default snippets. Each time I update Sql Complete the default snippets are added back. This is a bit of a nuisance
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • SQL complete allows you to create custom snippets that allow you to store frequently ran queries in shortcuts. The code can be populated within seconds!
  • Another great benefit is custom aliases. If you frequently reference the same tables over and over again it gets tiresome to retype the aliases. Storing these can make your code more consistent and save time.
  • SQL complete will also highlight the metadata within your database. For example, if you start typing an insert statement you populate code for all the field names by pressing the tab. This is a real-time saver for wide tables!
  • I think the default code formatting could be a little more consistent with other platforms I've seen.
  • The ability to uncomment/comment a large chunk of code at once would be pretty cool. I am sure SQL complete could make provide this in a very clean and functional way.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
  • Intellisense - it's not just what columns are on what tables, but foreign key navigation as well, which makes writing JOIN statements a breeze.
  • Formatting - I think most developers doing any kind of database querying like to see cleanly formatted statements, and dbForge SQL Complete formats well out of the box but also allows you to customize the formatting options to a really detailed degree.
  • Tab colors - this sounds like a small thing, but when I'm opening multiple database server connections, being able to tell at a glance which open tabs are for which connection is great. You can manage this to a degree in SSMS without dbForge SQL Complete, but it's a nice touch.
  • Every now and then the intellisense isn't current with database changes, but that's easy to fix and happens with SSMS vanilla anyway.
Return to navigation