Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

devArt SQLComplete vs RedGate SqlPrompt Expand / Collapse
Author
Message
Posted Saturday, April 28, 2012 8:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 8:59 AM
Points: 1, Visits: 25
I wanted to get other's opinions as well as share my own.

I just came across a pretty good product from devArt called SQL Complete that is an add-in for SSMS and VS. It includes upgraded Intellisense (which allows you to replace the Intellisense included with SSMS) and T-SQL formatting tools. This is the first time I have used this product but in the past I have used Sql Prompt from RedGate, which I would consider a competitor. I love RedGate tools because they are solid and are very powerful. However, being on my own, they can be cost prohibitive so I went looking for less expensive alternatives, which is how I came across devArt SQL Complete.

From my testing it looks like both have the same basic functionality. However, I found 2 things that set the devArt product apart from the RedGate tool. First, SQL Complete allows for Intellisense similar to how it works in VS, in that Intellisense will display entries that "contain" the text being entered while Sql Prompt only displays entries that "start with" the text being entered. Second, the cost is a factor in that SQL Complete is $99 for the Standard edition or they offer a FREE edition, yes a FREE edition. devArt is kind enough to display a matrix comparing the 2 editions so you know exactly what is included in each. RedGate only offers 1 edition at $195 and a trial that lasts 14 days.

So, given that info, my preference is the devArt SQL Complete product. What is yours? Has anyone used either of these and maybe could provide some feedback?

<a href="http://www.devart.com/dbforge/sql/sqlcomplete/" target="_blank" >
<img alt="sqlcomplete" src="http://media.linkedin.com/media-proxy/ext?w=100&h=80&hash=G5etneXgiLriHtrNg9hsiBl7cOc%3D&url=http%3A%2F%2Fwww.devart.com%2Fimages%2Flogos%2Fdbforge-sql-complete-small.jpg">
dbForge SQL Complete - Powerful T-SQL Formatting Tool
</a>
Post #1292088
Posted Monday, April 30, 2012 1:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 9, 2012 2:24 AM
Points: 1, Visits: 18
Hi Jeffrey,

I'll leave any comparison to others, but I just wanted to point out that SQL Prompt now has partial and camel-case style matching, and that there are two editions that can be compared here: http://www.red-gate.com/products/sql-development/sql-prompt/feature-matrix

Thanks,

Justin Caldicott
Product Manager, SQL Productivity Tools
Red Gate
Post #1292288
Posted Tuesday, August 7, 2012 4:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 7, 2012 4:08 AM
Points: 1, Visits: 0
Hi Justin,

I wanted to upgrade to your latest version, but chose DevArt as your upgrade fee was more than the price we paid for the original version of your software (SQLPrompt).

DevArt SQL Complete has all the features I need at less than a third of the price of SQL Prompt. (Wildcard expanding, table definitions, snippets, etc)

Regards, Ian
Post #1341129
Posted Tuesday, December 9, 2014 8:30 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 7:02 AM
Points: 157, Visits: 978
For those considering buying SQL Complete from dbforge DevArt, I'd just like to say that I've been having serious issues with it for the past year and they do not fix them.

1. They override your default database so when you hit "New Query" you are working in a database of their choosing. Be careful! You could be updating a database other than your expected one. They connect to other databases on startup, preventing you from restoring databases you never connected to.

2. When you hit "New Query", run sp_who or something short, and close the window, ALL of SSMS gets completely locked up and you lose all work in all sheets. This is because they create a second connection that takes 40 seconds and somehow it is attached to your new query sheet window. This happens to me every day unless I explicitly look and wait, and wait, and wait.

3. All syntax throughout your whole script must be correct or SQL Complete aborts any attempt to offer completion to the current statement.

4. Cached prompting is rarely up to date and is generally in limbo with what it presents. It is like its always two or three steps behind you.

5. You have to write your statements out of order for it to be somewhat helpful. For example, always write "select * from table1, etc" so that you can use alias prompting back in your select columns list.

6. I tend to jump around and write parts of a SELECT and have it all come together at the end; this doesn't work well with SQL Complete as it gets confused by non-sequentially progressive writing.

7. There is no way to have it offer prompting help on just one statement in a script.


Post #1642661
Posted Wednesday, December 10, 2014 4:13 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:10 AM
Points: 2,462, Visits: 1,064
Hi Bill,

I am just about to purchase SQL Complete (have a discount code so good value) but disappointing to hear that they haven't fixed the issues you have mentioned. Would you mind me sending them your bug list and see what reply I get?

Cheers

qh


SQL 2K acts like a spoilt child - you need to coax it round with lollipops.
Post #1642893
Posted Wednesday, December 10, 2014 6:29 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 7:02 AM
Points: 157, Visits: 978
My frustration with SQLComplete is due to being unheard month after month. I submitted these as bugs and enhancements many times. Their consistent canned response is to upgrade to their newest version...which never actually addresses my issues.

I did get value out of their product at first. I went through the 1000+ developers' stored procedures in my project and cleaned up the formatting and added aliases, etc. SQLComplete works well for code that is already written.

My guess is that they are calling Microsoft's sql parser and cannot solve some of the problems I've requested unless they roll their own parser. They are following such strict rules that it diminishes the value of the product for development use. This is similar to a browser not showing a website because of a single unmatched tag somewhere on the page.

When all is said and done, SQLComplete gets in the way with useless dropdown lists more often than it is helpful at completing a sql statement.
Post #1642922
Posted Wednesday, December 10, 2014 6:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 9:35 AM
Points: 39, Visits: 195
Bill Talada (12/10/2014)
My frustration with SQLComplete is due to being unheard month after month. I submitted these as bugs and enhancements many times. Their consistent canned response is to upgrade to their newest version...which never actually addresses my issues.

I did get value out of their product at first. I went through the 1000+ developers' stored procedures in my project and cleaned up the formatting and added aliases, etc. SQLComplete works well for code that is already written.

My guess is that they are calling Microsoft's sql parser and cannot solve some of the problems I've requested unless they roll their own parser. They are following such strict rules that it diminishes the value of the product for development use. This is similar to a browser not showing a website because of a single unmatched tag somewhere on the page.

When all is said and done, SQLComplete gets in the way with useless dropdown lists more often than it is helpful at completing a sql statement.


Have you tried ApexSQL Complete? It's free and works very well.
Post #1642931
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse