ApexSQL Refactor!

SQL script http://solutioncenter.apexsql.com/create-a-database-script-from-a-backup-without-restoring-it
| | Direct execution against database (synchronization | | Proprietary schema snapshot http://blog.apexsql.com/apexsql-diff-exporting-sql-data-sources
| | Database installer package (e.g. Executable installer, C# solution http://knowledgebase.apexsql.com/all-about-apexsql-database-installer-packages
| | Source control project or label (synchronization http://knowledgebase.apexsql.com/configure-apexsql-diff-to-work-with-source-control-data-sources
| | **Integration** SQL Server Management Studio (SSMS http://solutioncenter.apexsql.com/how-to-compare-sql-databases-in-ssms
| | **Reports and exports**

ApexSQL Refactor alternatives

  • dbForge SQL Complete

  • dbForge SQL Complete is a useful add-in for SQL Server Management Studio and Visual Studio. Free and paid editions of the tool offer the powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense. The tool can also be integrated into Visual Studio 2008, 2010, 2012, 2013 and 2015. Besides the extension of the List Members, Complete Word and Parameter Info features, SQL Complete also includes SQL Formatter.

    tags: autocompletion code-completion code-formatting snippets sql
  • SQL Prompt

  • Write, format, and refactor SQL effortlessly in SQL Server Management Studio and Visual Studio

    tags: autocompletion formatting intellisense intellisense-ssms refactoring
  • Sql Assist

  • SQL Assistant easily integrates with many widely used database editors and database management and development environments including native tools that come with your database systems. It provides assistance with code typing, automatic word completion and database object and attributes completion and browsing. It provides functions for quick entry of common SQL constructs and code snippets. It also provides integrated and fully interactive SQL code assistance system for instant help with SQL command syntax and options available in specific database versions, real-time code syntax checker, spell checker and a number of other vital coding tools. ยป

    tags: intellisense mysql sql-server