TrustRadius Insights for dbForge SQL Tools are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Pros
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.
Dbforge SQL complete is a very powerful tool that we have integrated with the SQL server and we are using this tool in the whole organization. prior to this tool, we were using an SQL server that was lacking quick development due to unorganized features
difficult in different environments.
lack of shortcuts.
No proper code formatter.
less power IntelliSense.
to overcome the above problems, we started using this tool which saves our budget and speeds up development.
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.
Likelihood to Recommend
Suited for:
Can be easily integrated with visual studio and SQL server.
dbForge SQL Complete is being used by our analytics department to speed up the process of writing SQL (structured query language). The intellisense provided within SSMS helps speed up the process of writing code significantly. Aside from speed, it also cleans up some of the indention errors people write on accident.
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
Likelihood to Recommend
dbForge SQL Complete is well suited for professionals that have to write code all day. In my role in the business intelligence department we are writing SQL pretty much all day. Having a tool that helps us do that faster, in a cleaner way is pretty awesome and something that pays for itself quickly.
Was purchased to ensure consistent formatting of code, allowing developers to have their personal style, and a consistent CICD style. Currently used on a single project.
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.
Likelihood to Recommend
We have raised issues with Devart but they appear to have no interest in maintaining bread & butter functionality. Guess they are focused on the next bright shiny ball in the room, and not the day-to-day stuff that most teams have to deal with. Upgrades cause activation errors, the company blames the customers.
VU
Verified User
Consultant in Information Technology (10,001+ employees)
dbForge SQL Complete is used by all developers in our IT department who work with databases as part of their day-to-day activities. It speeds up our database development and query time through its autocomplete and code snippets. It also assists us with consistent code formatting and improves our programmer efficiency.
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.
Likelihood to Recommend
It is well suited to DBAs or database engineers who work with databases daily, however, it is also a good aid to those who occasionally work with a database as it will aid their interactions through suggestions/code completion, etc if they are forgetful around how to form SQL syntax.
VU
Verified User
Professional in Information Technology (201-500 employees)
My department uses SSMS and SQL all day every day. dbForge SQL Complete saves us a lot of time and effort. I especially like SQL Formatter, Intelligent SQL completion, and Tab Coloring. The last option lets me color PROD tabs in red, which helps avoid accidents. Generate Script As is a great feature too, letting me take the results of one statement and turning them into IN() or SELECT clauses. All around SQL Complete is the best tool out there for added SQL Productivity.
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
SQL Complete provides real-time formatting, suggests the correct keywords and databases, checks to spell, and provides an execution history. Most importantly, I am able to customize formatting rules to provide a consistent framework to all my SQL coding, as well as allow me to store templates for reuse. SQL Complete has saved me countless hours.
Pros
Development templates provide a consistent framework
Srores execution history
Cons
Sometimes crashes. I suspect memory issues. But it is rare
Likelihood to Recommend
I have several other developers working with me. I plan to upgrade to an enterprise version so we all have the same tools and agree on the proper SQL formatting. Makes review and troubleshooting so much easier.
VU
Verified User
Administrator in Information Technology (11-50 employees)
SQL Complete is used across the entire organization
It adds value to the IntelliSense and scripting tasks within SQL Server Management Studio. It increases productivity by expanding upon that feature.
Pros
Object Model browsing
Table Hint and Object suggestions
Code Formatting
Cons
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
Likelihood to Recommend
SQL Complete is great for accelerating development at the database level.
VU
Verified User
C-Level Executive in Information Technology (1-10 employees)
Myself, along with many other SQL developers on my team, are working daily in SSMS on pulling audits, developing stored procedures, and architecting databases. It is used across my organization and it helps improve productivity for our SQL developers. My team members frequently share new tips, tricks, and custom snippets with one another.
Pros
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!
Cons
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.
Likelihood to Recommend
I work as a Data Analyst within SSMS daily. SQL complete greatly increases my productivity and honestly just makes writing SQL code more fun! The days of manually typing field names, frequently used queries, alias, etc. are over for me. The things I love the most are the custom snippets. I have a whole slew of them I use daily which prevents me from having to type the same thing over and over. SQL complete is great for any repetitive tasks you do!
VU
Verified User
Analyst in Research & Development (10,001+ employees)
I started using dbForge SQL Complete a few years ago, and when I moved to my current job, I brought it with me. Members of my development team have noticed me using it and have tried it out for themselves, then gone on to purchase licenses. It's made working within SQL Server Management Studio much easier, and when I recently installed the 2018 preview of SSMS, I found myself missing dbForge SQL Complete quite a lot until I installed it there, too.
Pros
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.
Cons
Every now and then the intellisense isn't current with database changes, but that's easy to fix and happens with SSMS vanilla anyway.
Likelihood to Recommend
If you're not in a database management app every day, dbForge SQL Complete might be overkill for you. I know some of my team members are just as happy with Azure Data Studio and a few extensions. I walk through a lot of production support issues, so being able to clearly tell which environment I'm working in, at a glance (QA, dev, staging, prod backup, etc), is a huge help for me. I also pick through generated SQL from an ORM, and dbForge SQL Complete makes it easy to comb through that. SQL Complete is also excellent for finding where (or if) a certain column or table or view is referenced within the database(s) on a given server. This is immensely helpful when I'm working in an area I'm not very familiar with.
VU
Verified User
Professional in Information Technology (10,001+ employees)