ApexSQL Refactor

Deployed as a Visual Studio add-in, ApexSQL Refactor makes it possible for you to refactor and format SQL code with ease, putting a plethora of customization options at your fingertips. With its help, you can improve the code consistency and enhance its efficiency.

Advanced formatting and refactoring tools

The addin is compatible with Visual Studio versions from 2005 to 2013, enabling you to create custom formatting profiles that can be easily activated and shared with other developers. Its aim is to help you easily change the layout of your SQL code and tamper with tables, functions, procedures and parameters without any impact on dependencies and code functionality.
You can change capitalization, indentation and spacing settings, insert comments, manage expressions, schema and data statements, values, variables and the execution flow. The result of your actions is previewed before any change is applied. Not only that it can format your code, but ApexSQL Refactor enables you to format existing SQL files in batch mode.

Optimize execution and convert your SQL code

ApexSQL Refactor can identify and remove unused variables or parameters, reducing the execution time. Also, it can be used for replacing complex relationships with associative tables and wildcards with explicit lists, all to optimize statements and the code.
It also features options for renaming tables, functions, views, and procedures, and changing parameters without worrying about dependencies, which are automatically updated. It can insert surrogate keys to replace multi-column primary ones and split large tables.
One of its major advantages is that it enables you to quickly convert and export your SQL code into various programming languages, such as Java, C++, C#, PHP, PowerBuilder, Ruby, Delphi, or VB.NET.

A Visual Studio addin to help SQL Server users

With its advanced formatting capabilities, ApexSQL Refactor can clean and optimize your SQL code, streamlining your database structure and enhancing execution efficiency. And since you can create different formatting profiles and toggle between them, it will surely be easier to handle future projects.
Its purpose is to help you enhance the design of your SQL databases without impacting dependencies and functionality. With the generous array of customization options, it can surely cater to any SQL Server user.