Is there a tool for refactoring SQL, a bit like a ReSharper for SQL [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.

Closed 8 years ago.

开发者_如何学JAVA Improve this question

The sort of stuff I'm after right now is quite basic:

• Auto format
• Detect unused variables
• Variable naming convention checking

I wouldn't be surprised if there was a tool available that could handle more complex refactorings such as those found in Refactoring Databases, but I appreciate that the added complexities introduced by current db structure and data state may prevent many of them.

I suppose I'm after ReSQLer

---

RedGate offers SQL Refactor and SQL Prompt, along with a slew of other SQL related tools. Check out their pages for more info and for a free trial.

---

There is a free SQL formatting and refactoring add-in for SSMS and VS developed by ApexSQL. I suggest you check these articles before you decide if it's the right tool for you:

http://solutioncenter.apexsql.com/category/sql-code-refactoring/

---

I have used Embarcadero Rapid SQL for code formating.

---

Something like SQL Prompt from RedGate?

---

SQL Prompt has basic format and beautify functions now, if you don't want to buy both products

The free SSMS Tools Pack supports basic beautify as well I believe http://www.ssmstoolspack.com/Features?f=3

Uppercase/Lowercase keywords and proper case Database Object Names. Set all keywords to uppercase or lowercase letters. Custom keywords can be added. Format all database objects to their proper case sensitive name.

---

I use SQL Enlight, which is a fairly inexpensive tool which does autoformatting, validation and refactoring pretty well. (And -- no, I am not affiliated w/ Ubitsoft in any way...)

---

JetBrains have just announced 0xDBE - a new IDE for SQL machines.

It's build on the IntelliJ platform, so should have many of the same shortcuts you get in the JetBrains suite of products.

http://www.jetbrains.com/dbe/