Redgate Sql Compare Alternatives
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.
Devart is more popular than Red Gate SQL Compare with the smallest companies (1-50 employees) and startups. With medium sized companies (51-1000 employees) Devart is more popular. With large companies (1000+ employees) Devart is more popular as well.
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? DbForge SQL Complete - Powerful T-SQL Formatting Tool.
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. They override your default database so when you hit 'New Query' you are working in a database of their choosing. 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. When you hit 'New Query', run spwho 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. All syntax throughout your whole script must be correct or SQL Complete aborts any attempt to offer completion to the current statement.
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. 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. 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.
There is no way to have it offer prompting help on just one statement in a script. 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. Letters from iwo jima review. 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. Bill Talada 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. You can't post new topics. You can't post topic replies. You can't post new polls. You can't post replies to polls.
Redgate Sql Compare 12
You can't edit your own topics. You can't delete your own topics. You can't edit other topics. You can't delete other topics. You can't edit your own posts.
You can't edit other posts. You can't delete your own posts. You can't delete other posts.
You can't post events. You can't edit your own events.
You can't edit other events. You can't delete your own events. You can't delete other events. You can't send private messages. You can't send emails. You can read topics.
You can't vote in polls. You can't upload attachments. You can download attachments. You can't post HTML code. You can't edit HTML code. You can't post IFCode.
You can't post JavaScript. You can post emoticons. You can't post or upload images.