Red-gate Sql Prompt -

Refactoring SQL is usually painful because you have to find every instance of a column name across dozens of stored procedures. SQL Prompt adds IDE-style refactoring.

to generate a SQL script that recreates that data elsewhere. 3. Use Comparison Reports (SQL Compare Integration) red-gate sql prompt