Top Rated dbForge SQL Complete Alternatives

RaimaDB

Visit Website

dbForge SQL Complete Reviews & Product Details - Page 5

dbForge SQL Complete Overview

What is dbForge SQL Complete?

Write, beautify, refactor your code easily and boost your productivity dramatically due to the features that are included in SQL Complete but are lacking in SSMS and Visual Studio IntelliSense: - Smart IntelliSense-style SQL completion - Great code snippet collection - T-SQL Code Analysis - SSMS tab coloring & document sessions - Intelligent renaming of aliases and variables - Advanced customizable code formatting - Fatal execution warning reminder - Results grid aggregates & data visualizer

dbForge SQL Complete Details

Discussions

dbForge SQL Complete Community

Languages Supported

English

Show LessShow More

Product Description

dbForge SQL Complete is an add-in for SQL Server Management Studio and Visual Studio with fully-featured tools designed to speed up SQL code writing, offer context-based smart suggestions, perform automatic formatting and refactoring, improve code readability, increase productivity, and lower costs.

Seller

Devart

Description

Since its founding in 1997, Devart has been working on simplifying and enhancing data workflows for both individual professionals and teams, including enterprise-level organizations from the Fortune 100 list. Currently, Devart is one of the leading developers of data integration, backup, management, and connectivity solutions, as well as database tools for major database management systems and cloud platforms.

Overview Provided by:

Jordan Sanders

PR Manager at Devart

dbForge SQL Complete Media

SQL Autocompletion

Code formatting

Smart refactoring

Productivity Enhancement

Code Analysis

G2 reviews are authentic and verified.

Here's how.

Verified User in Computer Software

Small-Business (50 or fewer emp.)

7/6/2021

"It is a license NIGHTMARE. Never change laptops or upgrade anything unless you want hell."

0/5

What do you like best about dbForge SQL Complete?

You can make your own rules for formatting. Review collected by and hosted on G2.com.

What do you dislike about dbForge SQL Complete?

Every time I upgrade to the newer version, there is a lot of trouble. Hours of hassle. All the time saved is lost. I have the license, but apparently, I have to do hours of contortions if I dare to do anything differently than they think it should be done. Review collected by and hosted on G2.com.

Recommendations to others considering dbForge SQL Complete:

Don't switch computers. Even if you work for multiple companies as I do, make sure the same company buys all products, they get confused. And never upgrade. Review collected by and hosted on G2.com.

What problems is dbForge SQL Complete solving and how is that benefiting you?

When working, it is easier to read code. Review collected by and hosted on G2.com.

Response from Jordan Sanders of dbForge SQL Complete

edit

Hello,

Thank you for leaving your comment, and please accept our sincere apologies for the inconvenience.

The last SQL Complete release introduced a new license activation system (it will make future license management simpler). Unfortunately, switching to this new activation system also suggested the necessity of additional actions on the user’s side during the upgrade.

We did our best to make this upgrade as smooth as possible. We sent 2 letters to all users to inform about those peculiarities and provide them with detailed instructions on the license activation. Unfortunately, it turned up to be insufficient.

We are deeply sorry that you faced these difficulties during the product upgrade. We assure you that it was a one-time issue that will never happen again in the future.

Robert R.

iT Consultant / Developer

9/29/2021

"Working Dev."

5/5

What do you like best about dbForge SQL Complete?

Thoughtfully designed and easy to use, yet highly sophisticated in its capabilities. Review collected by and hosted on G2.com.

What do you dislike about dbForge SQL Complete?

The installation on Windows 10 runs into problems with Windows Defender (the Antivirus program). Review collected by and hosted on G2.com.

Eric S.

Senior Software Architect

Small-Business (50 or fewer emp.)

6/17/2021

"Worth the money"

4/5

What do you like best about dbForge SQL Complete?

It's easy to use, has enough features to help with my tasks Review collected by and hosted on G2.com.

What do you dislike about dbForge SQL Complete?

I'm not happy with the SQL Formatter. For example the RedGate product is better. It should use a full lexical parser / analyser. It doesn't make a difference between a schema name or table name. Review collected by and hosted on G2.com.

Verified User in Accounting

Mid-Market (51-1000 emp.)

7/19/2021

"Using SQL Complete"

5/5

What do you like best about dbForge SQL Complete?

I like the Auto completion and the reformatting capabilities Review collected by and hosted on G2.com.

What do you dislike about dbForge SQL Complete?

it can sometimes cause SSMS to Freeze with no warning Review collected by and hosted on G2.com.

Response from Jordan Sanders of dbForge SQL Complete

edit

Hello,

Thank you for the high appreciation of SQL Complete! It means a lot to us.

Could you specify which version of SQL Complete you use? The issue you've mentioned is already fixed in the latest version of SQL Complete.

Stavros B.

Delivery Manager / Senior Software Developer

Computer Software

Mid-Market (51-1000 emp.)

7/7/2021

"Thumb up for good work"

4.5/5

What do you like best about dbForge SQL Complete?

Autocomplete and format features because sql studio is not working well Review collected by and hosted on G2.com.

What do you dislike about dbForge SQL Complete?

that many feature are not available in free edition Review collected by and hosted on G2.com.

Dan P.

Enterprise (> 1000 emp.)

7/15/2020

Business partner of the seller or seller's competitor, not included in G2 scores.

"Great productivity tool when using SSMS"

4.5/5

What do you like best about dbForge SQL Complete?

Auto-complete and other code snippets and shortcuts are time saving in terms of coding faster and more accurately. The code formatting and layout improves readability and consistency. I really like being able to generate insert update and delete statements quickly via the tool.

In SSMS it remembers the open tabs after closing the application as well as keeping unsaved changes. All of which are time savers. Finally connection tabs can be colour coded to differentiate between different servers or environments. All of these help reduce the risk of mistakes or making changes on the wrong servers. Review collected by and hosted on G2.com.

What do you dislike about dbForge SQL Complete?

Sometimes it can be slow to retrieve database metadata which it does when connecting for the first time to a database instance. It must complete database metadata retrieval in order to start functioning. On occasion it has made SSMS unresponsive and requiring a restart to start functioning normally again. Review collected by and hosted on G2.com.

Recommendations to others considering dbForge SQL Complete:

Great tool for DBAs and programmers alike who want to improve their SQL game. Review collected by and hosted on G2.com.

What problems is dbForge SQL Complete solving and how is that benefiting you?

We are always striving for consistent code formatting and ways to improve programmer efficiency. This tool achieves both of these aims by having built-in code formatting capabilities as well as all the various intelli-sense / code snippet enhancements. The net result is that we are able to code more quickly and efficiently. Review collected by and hosted on G2.com.

Response from Jordan Sanders of dbForge SQL Complete

edit

Our team has optimized the processes of obtaining metadata in version 6.7. We recommend you upgrade to the latest version of SQL Complete.

Juan O.

Business Technology Transformation Process Lead

Small-Business (50 or fewer emp.)

7/9/2020

"SQL Complete is a time saving tool"

5/5

What do you like best about dbForge SQL Complete?

There are several things I like about SQL Complete. First, I love the history. This keeps a history of all of the queries that were performed. Second, When you close SSMS, when you reopen, all of your query windows open back up. Finally, I like the intellisense that SQL complete provides Review collected by and hosted on G2.com.

What do you dislike about dbForge SQL Complete?

The one thing I do not like is with the history, it keep the connection as part of the query. So, for example, if I open SSMS and connect to my prod server and run a query, then open another SSMS and connect to my dev server, I can see the query I performed on prod. The problem is if I execute that query from dev(using the open in window feature), it will run it against my prod server, even thought SSMS is connected to my dev server. This is very problematic. There may be a option to turn this off, but I'm not aware of it. Review collected by and hosted on G2.com.

Recommendations to others considering dbForge SQL Complete:

I highly recommend this project. I've been using it for approximately 4 months and love it. Review collected by and hosted on G2.com.

What problems is dbForge SQL Complete solving and how is that benefiting you?

No longer have to save multiple open query windows. Can now close SSMS and when I reopen all of my windows open back up. Review collected by and hosted on G2.com.

Response from Jordan Sanders of dbForge SQL Complete

edit

Yes, a SQL document with an already organized connection opens from the Execution History, but the query is not executed automatically, the user can choose a different connection in the SQL document and execute it on the required server.

You see, if we do not store the connection, then the essence of this feature will be lost since having opened a document with a query, the user will not know which server he queried earlier. To avoid a situation with an already organized connection you've described, you can copy a query to the clipboard and paste it into a new SQL document with the required connection.

Verified User in Accounting

Small-Business (50 or fewer emp.)

7/9/2020

"dbForge SQL Complete has helped me maintain clarity in my daily work."

4.5/5

What do you like best about dbForge SQL Complete?

Rename, navigation, & Connection coloring. Review collected by and hosted on G2.com.

What do you dislike about dbForge SQL Complete?

Having export to Excel capability would be a real productivity booster. Review collected by and hosted on G2.com.

Recommendations to others considering dbForge SQL Complete:

Take your time to explore the formatting profiles and create a copy of a profile you can fiddle around with.

Parts of the profile editor show you accurate previews and some do not.

It might also take a few minutes to get familiar with the tree of formatting options, which is to be expected from a formatting tool with so much flexibility; YMMV. Review collected by and hosted on G2.com.

What problems is dbForge SQL Complete solving and how is that benefiting you?

Developing in multiple databases spread across multiple servers, and various ‘stacks’ is annoying. SQL Complete has helped me stay focused and productive through the use of connection coloring, document outlining, renaming, jumping to definitions, code completion, and multiple formatting profiles. Review collected by and hosted on G2.com.

Response from Jordan Sanders of dbForge SQL Complete

edit

Yes, we do have plans to implement data export to the Excel format in the nearest future.

Verified User in Government Administration

Small-Business (50 or fewer emp.)

7/11/2020

"Definitely increases productivity"

5/5

What do you like best about dbForge SQL Complete?

Love using the execution history to find recent SQL statements executed for customer support or system installations. With this feature, I can easily continue where I left and don't have to rewrite stuff. Review collected by and hosted on G2.com.

What do you dislike about dbForge SQL Complete?

No downside at all. Personally, I don't like auto-generation of table aliases because abbreviations sometimes don't make the code readable. Review collected by and hosted on G2.com.

Response from Jordan Sanders of dbForge SQL Complete

edit

We plan to improve aliases in the nearest future, but we need a specific example on how you would like aliases to be generated.

At the moment, you can customize aliases in the SQL Complete -> Alias menu.

For more information on how to set up aliases, you can use HELP:

https://docs.devart.com/sqlcomplete/writing-sql-with-code-completion/working-with-aliases.html

Verified User in Consumer Services

Mid-Market (51-1000 emp.)

7/9/2020

"Insights"

2.5/5

What do you like best about dbForge SQL Complete?

refactoring (like renaming columns) is convenient Review collected by and hosted on G2.com.

What do you dislike about dbForge SQL Complete?

When refactoring cross database dependencies are hard to get right.

As an example a secondary database has a synonym to table in the primary database. Then when a column in table in primary database is renamed you really want the SPs etc in the secondary database to be examined for refactoring effects too. Review collected by and hosted on G2.com.

Response from Jordan Sanders of dbForge SQL Complete

edit

At the moment, SQL Complete doesn't support renaming of server objects. Refactoring is done only in the script.

We plan to improve refactoring functions, including the ability to rename server objects in the upcoming versions.