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: Tuesday, August 7, 2012 1:07 PM
Points: 1, Visits: 19
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
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse