Monday, March 09, 2009
SQL Refactor: Refactor and format your SQL code

What do you do when you have over 863 seriously advanced stored procedures you need to update as soon as possible?

I don’t know about you but here is what I would do. I would download Redgate’s SQL Refactor.

Working with legacy SQL code means untangling someone else's coding format and quickly interpreting the purpose of the script. SQL Refactor provides a range of one-click features that instantly make legacy code as easy to work with as your own, including Layout SQL, Summarize Script, Encapsulate as a New Stored Procedure, and many more.

image
  • Update all dependant objects when you rename tables, views, and procedures
  • Expand wildcards and qualifying object names to improve quality and performance
  • Summarize complex SQL scripts
  • 11 refactorings in total
  • Smart column rename for views and tables
  • Smart parameter rename for procedures and functions
  • Split Table, can also create referential integrity tables
  • Uppercase Keywords
  • Summarize Script
  • Expand Wildcards in SELECT statements
  • Qualify Object Names
  • Find Unused Variables and Parameters
  • Encapsulate As New Stored Procedure
  • Smart Rename, for objects


    • cool | programming
    Monday, March 09, 2009 3:00:00 PM (Eastern Standard Time, UTC-05:00)  #    Comments [0]  |  Trackback
    Comments are closed.

    Theme design by Jelle Druyts

    Pick a theme: