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 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
Formatting Interface facelift
We’ve given our formatting interface a major face lift including improved navigation, organization, visual help and formatting previews
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
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
