SQL Prompt and SQL Refactor from Red Gate Rock!
by David Hayden ( Florida .NET Developer ), Filed: .NET Tools
SQL Prompt and SQL Refactor from Red Gate have become so integrated into my daily development activities that I forget they are add-ins.
I upgraded to the new version of SQL Prompt today to find out that you now get the code completion benefits from within Visual Studio! This may have been in there for awhile as I was a few minor releases back, but this is a nice addition to the intelligent code completion they already provided while creating queries and stored procedures in SQL Server Management Studio.
SQL Refactor has this really cool Smart Rename... functionality where you can rename a table and it will create a script that will not only rename the table but also alter any dependencies that would be affected by the name change. I used the functionality yesterday to do a table name change and it ended up saving me an hour or two of monotonous work. Here is an example of the feature using Northwind:
I must have been miserable without these tools in the past :) You can find out more about SQL Prompt and SQL Refactor on the Red Gate Website.