ApexSQL Refactor is a SQL Server tool that functions as a free formatter and refactoring solution. It offers capabilities for formatting queries, refactoring code and database tables, and renaming SQL database objects. This tool expands wildcard and fully qualifies object names.
One of the best things about ApexSQL Refactor is that it can format and refactor code directly within SSMS or MSVS. This means you can manage your SQL code right where you're working, without having to switch between different programs or tools.
Some of ApexSQL Refactor's key features include support for SQL Server 2005 and above, as well as Visual Studio 2010 and above. The tool also offers a variety of advanced SQL formatting options, allowing you to create custom formatting profiles and share them across your team.
In addition to formatting and refactoring tools, ApexSQL Refactor also includes features for impact analysis, wildcard expansion, object qualification, and much more. Whether you need to replace complex primary keys, clean up unused variables, or encapsulate SQL into scalar or table functions, this tool has you covered.
Overall, ApexSQL Refactor is a powerful and versatile tool that can help you manage your SQL code and database tables more effectively. And with support for SQL Server 2017 CTP 2, SSMS integration, and Visual Studio 2017 integration, it's a great choice for developers and database administrators alike.
Version 2017.02: Major feature, major fix release
Version 2016.04: Medium feature
Version 2016.01: Major feature, major fix release
Version 2014.07: Medium feature, minor fix release
Version 2014.06: Medium feature, minor fix release
Version 2014.03: Major feature, major fix release
Version 2010.05: Medium Feature, Minor Fix Release
Version 2010.04: Medium Feature, Minor Fix Release