You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 
SQL formatter with over 160 options
Qualify objects and expand wildcards
Encapsulate SQL into procedures
Add surrogate keys
Replace one-to-many relationships
Change procedure parameters
Safely rename SQL objects
Locate & highlight unused variables
Format SQL objects
Obfuscate SQL

Features

Advanced SQL formatting

SQL formatter with over 160 customizable options

See next feature

Impact analysis

Preview the impact of SQL formatter changes with difference highlighting

See next feature

SQL formatter profiles

Save and quickly toggle between different sets of formatting settings

See next feature

Batch formatting of SQL objects

Use the database-level SQL formatter to format all script based objects e.g. stored procedures, in a database, quickly and easily. Learn more

See next feature

Batch SQL script formatting

Use the bulk SQL formatter to process scripts and script folders in batches

See next feature

Obfuscation

Make SQL code less readable

See next feature

Wildcard expansion

Transform * wildcards into explicit lists of column names. Learn more

See next feature

Object name qualifying

Qualify columns with schema table names and schema or aliases. Learn more

See next feature

Find unused variables and parameters

Clean up your code by identifying and removing parameters and variables that aren’t used. Learn more

See next feature

Safe rename

Rename tables, procedures, views, functions and columns risk-free. Learn more

See next feature

Add surrogate key

Replace complex, multi-column primary keys with a single column surrogate key. Learn more

See next feature

Replace one-to-many relationships

Add a new associative table to replace one-to-many relationships. Learn more

See next feature

Change parameters

Add, remove or change parameters without breaking dependencies from referencing objects. Learn more

See next feature

Encapsulate SQL

Convert blocks of SQL code into scalar or table functions, stored procedures and views. Automatically identify and create the input parameters. Learn more

See next feature

Split table

Improve your database design and make large tables more manageable by partitioning them. Learn more

See next feature

Convert to code

Render T-SQL into its Java, C#, C++, VB .NET, PHP, Ruby or Delphi equivalent. Learn more

See next feature

ApexSQL Refactor 2018 – Screen shot tour

This article represents a screen shot tour of ApexSQL Refactor features with a brief description

ApexSQL Refactor – Overview

This knowledgebase article briefly explains every feature/option in ApexSQL Refactor

Top things you need in a SQL formatter tool

This article lists top things a SQL formatter tool needs to have

How to format SQL like a pro – formatting to implicit Microsoft standards and guidance

In this article, we describe how to implement MSDN, SQL Server online documentation, and Adventure Works formatting standards with ApexSQL Refactor

SQL formatter rules – Nesting and indenting SQL statements

This article explains nesting and indenting of SQL statements as another aspect of SQL formatter styles

Tips and tricks for using ApexSQL Refactor SQL formatting options – General options, Capitalization and Comments

This article provides an explanation of ApexSQL Refactor T-SQL code formatting options in the Formatting, the Capitalization, and the Comments tab

Tips and tricks for using ApexSQL Refactor SQL formatting options – Parameters, Columns, Joins, and Flow control

This article provides an explanation of ApexSQL Refactor T-SQL code formatting options under the Parameters, the Statements, the Joins, and the Flow control tabs

How to customize SQL formatting profiles

This article describes how to use ApexSQL Refactor formatting profiles and is a guidance through the process of managing profiles

How to format all SQL objects in your database

This article shows how to format all SQL objects in a database with the specified formatting profile, without having to script them first

Quickly convert SQL code to language-specific client code

This article describes how to use ApexSQL Refactor convert your T-SQL script into a client language-specific syntax – Java, VB.NET, c#, Perl, PHP, Delphi, PowerBuilder, Ruby, C++, or other custom languages

SQL database refactoring – introduction

This article explains what database refactoring is and what are the reasons for database refactoring

How to set options for the Split Table refactoring method on SQL Server

This article explains how to set the options in the Split Table refactoring method on SQL Server, using ApexSQL Refactor, to gain the best performance based on your needs

ApexSQL Refactor - How to safely rename database objects without breaking dependencies

This video shows how to use the Safe rename feature in ApexSQL Refactor and how to easily rename database objects without breaking any dependencies

Changing SQL stored procedures and functions parameters without breaking dependencies

This article explains how to change parameters of your functions or stored procedures safely using ApexSQL Refactor

How to secure stored procedures against SQL injection

This article shows how to use ApexSQL Refactor to ensure all stored procedures are safe from SQL injection

See more
ApexSQL Redgate®
SQL Server version
      SQL Server 2000
      SQL Server 2005 - 2017
SQL Server editions
      Express
      Standard
      Enterprise
Cloud
      Azure SQL Database
      Amazon RDS for SQL Server
Integration
      SQL Server Management Studio (SSMS)
      Visual Studio
SQL formatter options 281 94
      Data types 3 3
      Indentation 3 3
      Wrapping 1 1
      Aliases 4 1
      Capitalization 23 21
      Comments 8 1
      Expressions 53 8
      Flow control 13 4
      Format lists by type 100 22
      Joins 16 3
      Miscellaneous 5 2
      Parentheses 10 2
      Spacing and Empty lines 8 5
      Statements 30 18
      Variables 4
SQL formatter features
      Impact preview
      Profiles
      Skip formatting for selected code 2019
      Quick format actions
      Batch SQL objects formatting
      Batch SQL script formatting
      Obfuscation
Refactors
      Encapsulate code as: Stored procedure
      Object name qualifying
      Rename variables and aliases 2019
      Safe rename
      Search for invalid objects 2019
      Search for unused parameters and variables
      Split table
      Wildcard expansion
      Add surrogate key
      Change parameters
      Convert to code
      Encapsulate code as: Scalar inline function
      Encapsulate code as: Table inline function
      Encapsulate code as: View
      Replace one-to-many-relationship
Interface
      Toolbar support
      Command line interface 2018 R5
      GUI themes
      High DPI and 4K resolution support
      Host aware theme adoption
      Microsoft standard iconography, colors and other visual effects
Price
Free $365

ApexSQL Refactor 2018.02

Redgate® SQL Prompt 9.2.1.5713


Comparison was conducted on August 24, 2018

Redgate® SQL Prompt also includes Auto-complete. For a comparison of this functionality set click here

Disclaimer: All product and company names are trademarks or registered® trademarks of their respective holders.
ApexSQL is not affiliated, associated, authorized, endorsed by, or in any way officially connected with other companies listed or any of their subsidiaries or affiliates

Testimonials

The ApexSQL Refactor SQL formatter is a great help, and I'm glad to have found something that works well and is easy!

Alex Gadea

Sr. VP of Operations

Hostcentric Inc.

I'm a user of ApexSQL Refactor and I find it a really wonderful product.

Paolo FRANCESCHINI

Software Developer Consultant

I tried the ApexSQL Refactor product and liked it a lot. This is something I have been thinking would make my life a lot easier.

Mathias Hedlund

System Developer

Jeeves Information Systems AB

I used ApexSQL Complete and ApexSQL Refactor. Both are well designed and include all the modern feature compare to other competitors. I found tons of customization options that makes your tools powerful.

Mohammad Sanati

Software & Database developer

PDP.com

I’ve been using ApexSQL Refactor for about three years now and have found it to be the most customizable of any product on the market today. And it is FREE! Kudos to your development team!

Fred Botts

Database Administrator

Aureon

I use ApexSQL Refactor for a couple of years and it helped me a lot in designing and throubleshooting stored procedures and long queries. Thanks for the high and specific customization that I didn’t find in other free products.

Alessandro Losi

SISTEMI S.p.A.

ApexSQL Refactor is essential to keeping formatting standards on my team without getting overwhelmed. Everyone can format as they want, but when it’s production-ready, it all fits the standard. I reach for the formatter after every edit; it’s second-nature.

Steven Hibble

Senior Database Developer

Communicus

Other free tools

Comparison

Script, file and folder comparison

Learn more

Decryption

Database object decryption

Learn more

Discovery

SQL Server instance discovery

Learn more

Plan analysis

Query execution plan analysis

Learn more

Productivity

Improved SQL coding and productivity

Learn more

Propagation

Multi-database script execution

Learn more

Search

SQL text and object search

Learn more

Database lifecycle management (DLM)

SQL Server continuous integration (CI) and delivery (CD)

Learn more