ApexSQL Refactor 2010.03 Released – Smart Rename, Move Schema and Improved Formatting

ApexSQL is excited to announce the release of several new features for our SSMS add-in, ApexSQL Refactor. This upgrade will be free for all existing customers of with current Software Assurance plans

Here’s a quick summary of what is new

Smart Rename and Move Schema Refactoring

Smart renaming of object, columns, and parameters is now available in ApexSQL Refactor, along with the ability to easily change the schema of objects. This set of Refactors implements name changes and automatically updates all referencing objects throughout the database

Smart Rename and Move Schema Refactoring

Smart Rename Objects – Change the name or schema of tables, views, functions, and stored procedures

Smart Rename Columns – Rename columns within tables and views

Smart Rename Parameters – Rename parameters within functions and stored procedures

Remove Parameter Refactoring

Also in the new release of ApexSQL Refactor is Remove Parameter refactoring, (previously released in ApexSQL Edit v2008.10). This feature allows users to easily remove parameters from stored procedures and functions, automatically updating all dependent objects

Remove Parameter Refactoring

Formatting Interface facelift

We’ve given our formatting interface a major face lift including improved navigation, organization, visual help and formatting previews

Formatting Interface facelift

These additional features will complement our current set of refactors, which include:

  • Qualify Object Names – Add missing schema and data source name to object and column names
  • Expand Wildcards – Replace * in SELECT * with explicit list of referenced columns
  • Generate Client Code (i.e. C#, Java, VB.NET) – Translate scripts for use in client languages
  • Encapsulate as Scalar Function – Extract scalar expressions into new scalar function and replace with function call
  • Encapsulate as Inline Table-Valued Function – Extract queries into new table function and replace with function call
  • Encapsulate as Stored Procedure – Create stored procedure based on selected code fragment and replace it with a procedure call

Qualify object name

Even more refactors coming soon!

We are planning to release even more refactors soon including:

  • Find Unused Variables and Parameters – Find and highlight all unused variables and parameters
  • Add Surrogate Key – Generate surrogate key and add foreign key columns to linked tables
  • Replace One-to-Many link with Associative Table – Automatically create associative table based on complex one-to-many links
  • Encapsulate as View – Store queries as views for use in future scripts
  • Expanded Formatting Options – Improved automatic script formatting features and controls
  • Introduce Parameter – Add parameters to functions and procedures and automatically update all function or procedure calls
  • Change Signature – Change order of parameters within functions and procedures and automatically update all function or procedure calls

About ApexSQL Refactor

ApexSQL Refactor is a SQL formatter and database refactoring tool for SQL Server. Format SQL queries, refactor SQL code, database tables and much more

July 8, 2010