ApexSQL Refactor release notes

Fixes:

• Column primary key reference moves to a new line when the "Place each item on a new line" option under the Columns tab of the Options dialog is enabled
• The "Format data types" option under the Formatting tab of the Options dialog adds excessive space without properly aligning the data types
• Table will not be indented properly if the table aliases are used in the update statement and the "Smart indent" option under the Formatting tab of the Options dialog is enabled
• The "Move WHERE clause to a new line" option under the Statements tab of the Options dialog moves the order by clause to a new line
• The Unused variables and parameters command does not underline unused variables and parameters in SQL stored procedures
• The "Keep empty lines before/after the script" option works even if the parent "Manage empty lines" option under the Formatting tab of the Options dialog is disabled
• The values clause under the merge statement cannot be moved to a new line when the “Place each item on a new line” option under the Columns tab of the Options dialog is enabled
• Excessive spaces are added in the SQL convert function when any of the predefined formatting profiles in the Options dialog are used
• The "Move code within parentheses to a new line" option under the Statement tab of the Options dialog incorrectly places code when the union clause is used
• The select statement stays in the same line with the SQL return keyword when any of the predefined formatting profiles in the Options dialog are used
• Excessive semicolons are added at the end of lines and sections containing the where clause
• The “Insert empty line before each statement” option under the Formatting tab of the Options dialog does not work when there are multiple nested select statements
• The SQL nolock keyword and change_tracking_min_valid_version function are enclosed with brackets when the "Enclose identifiers in brackets" option under the Formatting tab of the Options dialog is enabled
• The SQL lead and lag functions and the SQL nolock hint are enclosed in brackets when the “Enclosed identifiers in brackets” option under the Formatting tab of the Options dialog is enabled
• The Format SQL command is missing in the add-in toolbar in SQL Server Management Studio versions 2012 and 2014

Enhancements:

• SQL Server vNext CTP1.4 support
• The Format SQL command is added in the add-in main menu and in the add-in toolbar that formats SQL code on one click using the active formatting profile

Fixes:

• The “Format comments” option is ignored and lists of successive inline comments are formatted in one line when any of the ‘’Manage empty lines’’ options are enabled under the Formatting tab of the Options dialog
• The inline comments are not formatted into block comments when the “Change all comments to block comments” option is enabled under the Comments tab of the Options dialog
• The join statement does not format correctly when it is used in the update statement
• All SQL files in the selected root folder level will be formatted without any warning when the Format SQL scripts is used
• Two empty spaces will be added at the beginning of the script when the "Insert empty line before each statement" and "Keep empty lines(s) before and after the script" options under the Formatting tab of the Options dialog are enabled
• SQL keywords are not enclosed in brackets when the Wildcard expansion is used in a select statement
• Excess borders are added in the comments when the "Add border above block comments using" and the "Add border below block comments using" options under the Comments tab of the Options dialog are enabled
• The order by and options clauses are moved to a new line when the "Move WHERE clause to a new line" option under the Statement tab of the Options dialog is enabled
• The Export dialog does not close when the (Esc) key is pressed
• The add-in toolbar changes position every time the SQL Server Management Studio or the Visual Studio is started
• The “Add border above block comments using” and “Add border below block comments using” options under the Comments tab of the Options dialog are disabled when a character from their char box is deleted
• “Error in Options form” message is encountered when the Options dialog is opened without previously opening the query editor
• SQL Server Management Studio stops working when the obfuscation options under the Obfuscation tab of the Options dialog are toggled while a Query Editor is opened with a SQL script that has over 2,000 lines of code

Changes:

• Direct execution of SQL scripts generated by refactors and bulk re-formatting features is deprecated

Enhancements:

• The Remove brackets from system name option is now available in the Formatting tab of the Options dialog

Fixes:

• The Align with the beginning of the previous keyword option in the Joins tab under the Options dialog doesn’t remain checked after reopening the dialog
• Format SQL objects command appears in the Visual Studio 2013 Server Explorer context menu when a table is selected
• Convert function parameters cannot be formatted
• The Keep empty lines before each statement option under the Formatting tab in the Options dialog does not work
• The Place nested join operations on separate line option in the Joins tab under the Options dialog does not work
• Profiles cannot be sorted in the Export options dialog under the Options dialog
• The Save dialog does not appear in SQL Server Management Studio when a sql file in an SSDT project is closed in SQL Server Management Studio
• The Cancel button in the Options dialog saves changes
• A SQL syntax error occurs when formatting a code that contains:
  • At time zone function
  • JSON auto/path clause
  • Configuration option
  • Size_based_cleanup_mode
  • Index clause
• The add-in installation will automatically overwrite previously installed add-in version
• The previously installed add-in version is not removed when the default installation path is changed during the installation
• The Safe rename feature does not work for table columns and stored procedure parameters
• The options under the Comments removal section in the Comments tab of the Options dialog do not work
• The Options window needs more than 5 seconds to appear
• The add-in does not format try_cast statement
• SQL Server Management Studio stops working when using the Wildcard expansion feature on an Azure SQL Database
• The Unused variables and parameters feature do not work on Azure SQL Database
• The cross apply and outer apply statements are not treated as a join operation in the Place nested join operations on separate lines option under the Joins tab of the Options dialog
• The Enclose columns in brackets and Enclose identifiers in brackets options under the Formatting tab of the Options dialog put int data type in brackets
• The Schema combo box of the Stored procedure, Scalar inline function, Table inline function, View features under the Encapsulate code as option contains duplicate values
• The add-in does not format the case statement
• The Obfuscate shortcut works after being turned off in the Shortcuts tab of the Options dialog
• The Place at same position option in the Parameters tab under the Lists tab of the Options dialog does not work
• The options Move opening parenthesis to a new line and Move closing parentheses to a new line under the Parameters tab of the Options dialog are not applied for parameters in the procedures
• The Remove unnecessary brackets option in the Formatting tab of the Options dialog removes comments from the query which are located between brackets

Enhancements:

• Visual Studio 2017 RC integration
• SQL Server Management Studio v17.0 RC1 integration

Fixes:

• "The following feature couldn't be installed .NET Framework 3.5 (includes .NET 2.0 and 3.0)" the message occurs when installing the add-in in Windows 8 and Windows 10 OS
• The context menu needs too much time to appear on the right click in the Object Explorer pane
• ApexSQL Refactor is not shown in ApexSQL main menu under SQL Server Management Studio 2016

Enhancements:

• Visual Studio 2015 integration
• Visual Studio 15 Preview 4 integration

Changes:

• Deprecated support for SQL Server Management Studio versions prior to 2012
• Deprecated support for Visual Studio versions prior to 2010

Enhancements:

• Support for SQL Server 2016
• SQL Server Management Studio 2016 integration

Enhancements:

• Code formatting impact preview has been improved

Fixes:

• Option for comments removal removes comments from code in preview editor but doesn't bring back comments once it is toggled off
• The highlighting in the preview section is not correct when making a change in the formatting options
• Applying any formatting option changes position of the script in preview editor

Changes:

• The "Create script" button is now changed to "Format" in the Format SQL objects form

Enhancements:

• SQL Server 2016 CTP3 support
• SQL Server Management Studio CTP3 integration
• Smart indent feature
• Batch format SQL objects feature
• Obfuscate SQL feature
• New parenthesis options for values, where in values, variables, parameters and nested selects
• New Add spaces inside/outside parenthesis option
• Improved Place ON keyword on new line option
• Improved Nested join operations on separate lines option
• New Keep empty lines before and after the script option
• New Indent condition body statement option

Fixes:

• SQL Server Management Studio versions are not recognized and cannot be checked for the add-in integration, during the installation process, in specific environments
• The semicolon is treated as a statement and moved in a separate line, when the "Always use statement terminator" option is unchecked and the "Insert empty line before each statement" option is checked
• The ORDER BY formatting is not applied in the same way as for the GROUP BY
• Formatting of data types is not done in appropriate way in specific cases
• The BEGIN TRY...END TRY block is not indented as the rest of the BEGIN...END blocks in specific case
• "The 'OpeningParenthesisNewLineIndentType' start tag on line 39 does not match the end tag of 'OpeningParenthe'. Line 39, position 69." error is encountered when SQL Server Management Studio or Visual Studio is started with specific options
• Missing an option to keep empty line(s) before and after the script
• Wrong indentation when under the INSERT INTO statement there is the INNER JOIN statement
• The ON and AND keywords are incorrectly aligned with the BEGIN keyword in specific statements
• The INTO keyword is not properly aligned with the SELECT keyword in the specific statement
• The block comments are not indented with the rest of the body
• Sub definition inside the WHERE clause is not properly formatted
• The AND keyword is not properly indented when formatting options are applied for the JOIN statements
• When the "Place body on a new line" option, under the Schema statement tab, is checked, the body should not be affected by the "Indent BEGIN and END block" option, from the Flow control tab
• The "Characters as a single line" string is not in line with the "Copy code with less than" string in the "Language templates" form
• The "Options" window takes too long to open or close
• The TRUNCATE keyword is not supported and cannot be formatted properly
• The "Place nested join operations on separate lines" option does not work correctly
• The "Insert empty line before each statement" option does not insert empty lines after the statement terminator
• The "Preview user's code" remains unchanged, even if the built-in code is selected
• SQL Server Management Studio and Visual Studio load slower after installing the add-in
• The Wrapping option under the Formatting tab is limited to 160 characters
• The "Place column list on a new line" moves the table name from the DROP statement in a new line, and split the ADD CONSTRAINT in separate lines
• The THEN keyword will not be properly formatted if it is under the MERGE statement
• The IF statement will be incorrectly indented in case the previous IF statement does not contain the ELSE clause in the CREATE or ALTER FUNCTION statement
• The "Indent spaces" option from the "Place nested join operations on separate lines" section, under the "Joins" tab does not work
• The add-in reports a syntax error when initiating the format option, even if the query does not contain errors and can be executed properly
• The IF statement after the previous END clause cannot be placed at the beginning of the line
• The comment will go on a new line if the "Place On on new line" option is checked
• The ON keyword is not aligned relative to JOIN keyword, but with the beginning of the line when the indentation is used
• The Default formatting profile will be opened each time when the "Options" window form is initiated
• The ON keyword is not following the parent indentation
• The "Show operation on a multiple lines" option under the "Arithmetic operations" section shows wrong operation
• The ON clause is not properly formatted in the UPDATE statement
• Enforcing comment type change from a single line to block comments adds an empty line in created block comment
• The IF statement is formatted properly, only if the "Always use BEGIN and END in IF statements" option is checked
• The Parenthesis placement formatting is not applied in the INSERT INTO statement
• The "Parenthesis placement" formatting cannot be changed/managed from the "Column list" section, but only from the "Formatting" tab
• The "Move arithmetic operations to a new line moves the wrong operation
• The "Add space inside parenthesis" does not add space in specific situations
• The installation wizard offers SQL Server Management Studio integration, even if that version is uninstalled
• The "Add space outside parenthesis" option adds space in case there is a comma, semicolon, or a new line after parenthesis
• The "Enclose columns in identifiers" and "Enclose columns in brackets" options are enclosing reserved keywords/function calls
• The "lowerCamelCase" and "UpperCamelCase" options are not working correctly for formatting variables
• System functions are formatted with parenthesis options in the Value tab
• The "Place JOIN keyword in new line" option does not work for the UPDATE statement
• The columns are misaligned with the SELECT statement in the previous column

Changes:

• The Set as default profile option is changed and renamed to Set as active option
• All list options are moved to the Lists tab
• The Data statements and Schema statements options are moved to the new Statements tab
• The Expressions tab is split into three tabs:
  • Arithmetic
  • Comparison
  • Logical
• The Parenthesis options are removed from the Formatting tab
• The "Add spaces around operators" option is moved from the Formatting tab into the specific expressions tabs

Fixes:

• The add-in fails to format SQL code and reports an error even it the same code can be executed without errors in SQL Server Management Studio
• The add-in file for SQL Server Management Studio integration is created in the wrong folder
• Nested BEGIN/END block inherits parent's indentation if the WHILE condition is set before the nested BEGIN/END block
• The nested CASE statement is not properly formatted
• Value list is not formatted properly, when the comment exists before the first value
• The BEGIN TRY is not properly indented after applying formatting options
• The DROP TABLE and COMMIT TRANSACTION are not properly indented when formatting is applied
• The AS keyword is not properly indented after the code is formatted
• The "Add spaces after commas" option is not working for the built-in example
• The slowness is encountered while changing between formatting profiles, which are previously imported and saved along with the built-in ones
• SQL Server Management Studio stops working after a certain number of SQL scripts is formatted
• The JOIN statement is incorrectly formatted if the "Align with the beginning of the previous keyword" option is used
• The "Format parenthesis placement" option is checked, under the Formatting tab, for the "Compact" and the "MSDN SQL BOL" profiles, but none of the related options is checked
• E-mail for sending logs is opened in the background
• Some buttons can be clicked even if the main option is unchecked
• The resized "Options" window is not remembered after click on the "OK" button or after SQL Server Management Studio is restarted
• The "Place at the same position" option, for the "Place table on new line" options, under the "Joins" tab, is redundant
• The COLLATE keyword is missing from the list of SQL reserved keywords and therefore is recognized as an identifier
• The BEGIN and END blocks are not indented as a child for the WHILE statement, under the CREATE PROCEDURE statement
• When the "Format data type" option is checked, the CONVERT function parameter is wrongly formatted
• The BEGIN and END blocks are not properly indented when all of them are children of the one BEGIN and END block
• SQL Server Management Studio and Visual Studio loads slower after installing the add-in
• The "Enclose columns in brackets" option encloses the FORMAT
• The "Enclose columns in brackets" option encloses table names in constraints
• The "Enclose columns in brackets" option encloses constraint names
• The "Enclose columns in brackets" option does not enclose columns in the ORDER BY clause
• The EXEC statement fails to stay in the new line inside the BEGIN/END block, after unchecking the "Always use statement terminator" option
• The IDENTITY keyword goes to a separate line and breaks up the data type alignment
• All refactoring features will not work if the Cumulative update 7 for SQL Server 2012 Service pack 2 is installed

Enhancements:

• New "Parenthesis placement" option has been added for Arithmetic operation, Comparison operation, Logical operation, and Column list
• New "Data types" alignment option
• New CamelCase capitalization option
• New BEGIN and END blocks indent options
• New "Place JOIN keyword in new line" option
• New "Insert empty line before each statement" option
• New "Align SELECT with INSERT" option
• New "Compact" formatting profile has been added
• New "Extended" formatting profile has been added
• New "MSDN SQL BOL" formatting profile has been added

Fixes:

• The "Enclose identifiers in brackets" option encloses the wrong part of the code
• The add-in does not recognize a custom template as a default
• The "Send logs" option is not working
• Two default formatting templates can be created and none of them can be deleted
• The "Formatting profiles with duplicate names exist" message appears when there are two formatting templates with the same name which are preventing others to be set as default
• After the uninstallation of ApexSQL Installer, certain files and folders may remain in the Program Files folder
• The auto-update feature fails to detect the new version, when the host application is started

Changes:

• A new dialog for creating formatting profiles has been added

Fixes:

• "The queue '' cannot be dropped because it is bound to one or more service" error is encountered when renaming specific procedure with Safe rename feature
• "Error HRESULT E_FAIL has been returned from a call to a COM component" when the OK button is clicked, in the add-in formatting options in SQL Server Management Studio 2005
• Missing an option to put a table name after the FROM statement in a new line
• The FORCESCAN keyword will be wrongly enclosed in brackets when selecting the "Enclose identifiers in brackets" option
• The built-in code for the "Place body on a new line" option is not working appropriately
• The add-in can be installed even if the system requirement is not met
• Shortcuts in the add-in options are not saved after they are unchecked
• Tooltips are not shown on hover over the bulb icon, if that option is not checked
• Identing a column list is not working correctly when there is a comment before the list

Enhancements:

• The add-in now supports Azure SQL Database V12

Fixes:

• The list of the WHERE IN clause is not formatted
• The Remove unnecessary brackets option removes brackets that are necessary
• The Encapsulate as Table Inline Function generates code with syntax error without informing the user about in case source code contains CTE construction
• Formatting a SQL script will change its encoding
• Comments after column names are moved to new line
• The "Format parentheses placement" options are not working under Comparison and Logical operations
• After inserting in code, the BEGIN statement will be formatted differently after IF and ELSE statements
• The option "Place column list on new line" is not working correctly
• "Find unused variables and parameters" marks that user-defined types are unused after their value is changed with SELECT statement
• There is no space between the parenthesis ")" and the next word
• The EXECUTE command is not recognized as a new line
• Variables are not separated into new lines
• The application cannot be installed when Visual Studio is opened and it's unchecked from the installation wizard
• Tooltips for The BEGIN and END set of options are incorrect
• The "Tabs equal (x) spaces" option is enabled when the "Indent using spaces" option is enabled
• The needed brackets are removed from the IF statement when applying the default formatting options
• The "Indent" option under the "Place value list on a new line" from the "Value lists" tab is not working
• The "Enclose identifiers in brackets" option fails to format SQL code properly
• The "Place column list on a new line" option does not work properly for the UPDATE statement, if the "Place comma before column names" option is checked
• The "Enclose identifiers in brackets" encloses columns
• The add-in fails to format the specific code properly
• The NOLOCK keyword is enclosed with brackets when the "Enclose identifiers in brackets" option is checked
• SQL syntax error dialog cannot be closed via Esc key
• The default location for add-in files is changed after a specific Windows update
• Changes for the "Indent using tabs" option are applied incorrectly
• "Tabs equal (x) spaces" and the "Wrap lines longer that (x) values" options loss focus if the mouse pointer is places outside the value field
• The "Send logs" button does not open the log file location, if there is no e-mail client installed on system
• The "Preview" section in the "Formatting options" window is not resizable enough
• In the add-in "Formatting options" vertical scrollbar doesn't move on a mouse wheel and arrow keys
• "Manage empty lines" option affects column formatting
• "Manage empty lines" option does not work correctly
• "Add surrogate key" option does not work on tables with IDENTITY columns, when connected to Azure database
• "Method not found: 'Void ApexSql.Common.UI.Controls.AxConnectToDB.set_ShowSystemDatabases(Boolean)'." error is encountered when applying the "Object name qualifying" option to a script
• "Keep empty lines before each statement" option inserts empty lines where they do not exist before statement

Changes:

• A new "Options" window is added
• New toolbar buttons are added
• New default formatting options are added

Enhancements:

• The add-in now fully supports SQL Azure

Fixes:

• Redundant "My Computer" node is shown in the "Format SQL files" dialog
• The default location for the exported options file is not offered, when exporting options in Visual Studio
• Shortcuts from the "Options" window remain the same after new shortcut settings are imported, until the "Options" window is reopened
• The System32 folder is shown when exporting shortcut settings
• SQL Server Management Studio/Visual Studio will freeze and get into the "Not responding" state, when the "Find unused variables and parameters" function is initialized on script with more than 50.000 lines
• The refactored code cannot be executed in SQL Server Management Studio
• The "Format SQL scripts" dialog should not be closed after formatting is performed
• The exception is encountered when the "About" button is clicked in SQL Server Management Studio
• The "Format SQL script" dialog cannot be closed with the ESC key
• The shortcut key combination for the "Unused variables and parameters" option remains in the main menu window, even if the shortcut is disabled in the "Options" window
• The "Reset all" button on the "Split table" dialog does not clear the "Generated script" window
• The "Split table" option allows moving all columns from primary to secondary table
• The disabled shortcut with the already used combination can be enabled
• The "Object name qualifying" option cannot affect only a part of the query
• The "Expand wildcards" option cannot affect only a part of the query
• The "Formatting templates" options are lost and the shortcut is rendered as unusable when shortcuts in the "Options" window are changed in any way in Visual Studio
• Line breaks between the SELECT statement and the next column, even though the "Place column list on a separate line" option is checked
• The "OK" button in the "Custom language templates" does not work
• The "The process cannot access the file 'C:\...\FormattingOptions.xml' because it is being used by another process" error is encountered when starting Visual Studio 2008
• SQL Server Management Studio 2012 will stop work when the "Expand wildcards" option is initiated for a specific script
• The "A column with the name "..." already exists" error is encountered when changing capital letters for columns with the "Safe rename" option
• The "The ConnectionString property has not been initialized" error is encountered after starting the "Change parameters" option in Visual Studio
• The "Could not find method 'IsDescendant' for type 'Microsoft.SqlServer.Types.SqlHierarchyId' in assembly 'Microsoft.SqlServer.Types'" error message is not shown under the "Warnings" tab when performing the "Split table" option
• The "Exception of type 'System.OutOfMemoryException'" error is encountered when the "Encapsulate as" option is performed on scripts with more than 50.000 lines
• The "Split table" option does not remove columns from the secondary table, if you remove column of the invalid type
• The "Send logs" button opens a new email window, which stays on top and does not allow to switch to another application
• The CROSS APPLY and OUTER APPLY statements are not treated as a join operation in the "Place nested join operations on separate lines" option
• Missing space after the WHERE statement when formatting code
• The add-in causes Visual Studio 2013 to stop working when initiating the right-click context menu in a database with 1.500 stored procedures
• The "The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG))" error is encountered after changing the shortcut for the "Safe rename" option
• Nonfunctional shortcuts set can be assigned to shortcuts from the "Options" window
• The "Exception of type 'System.OutOfMemoryException'" error is encountered when the "Object name qualifying" option is performed on scripts with more than 50.000 lines
• Disabling the "Always use BEGIN and END in IF statements" option in the "Formatting options" window will corrupt refactoring of the IF statement
• The "System.ArgumentException - The parameter is incorrect" error is encountered when adding incorrect shortcut key
• The "Options" window closes after pressing the ENTER key

Known issues:

• The "Manage empty lines" option is not working correctly
• The "Add surrogate key" option does not work on tables with IDENTITY columns, when connected to Azure database

Enhancements:

• An option to enclose all identifiers in square brackets has been added
• An option to enclose only column identifiers in square brackets has been added
• An options for formatting "SET" clause has been added
• An option to schema-qualify all objects when applying a formatting profile has been added

Fixes:

• The "Remove unnecessary brackets" option removes brackets from the arithmetic operations and functions, although that brackets should not be removed
• Installer does not detect previous version of the add-in, and will install over it
• The "Manage empty lines" option interferes other formatting options
• The "Safe rename cannot be applied to the selected object. Select a table, view procedure, function, or column, or parameter" error is encountered in case the "Safe rename" option is initiated for any supported database object in Visual Studio, if the Server Explorer's layout is configured as Object Type
• The "Invalid column name" error is encountered when executing the a split table operation
• The "Parameters on new line" option applies incorrectly to a built-in example in the add-in options
• Incorrect mouse-over effect in the "Variables" tab of the "Formatting options" dialog
• The "Customize language templates" editor disappears when ENTER key is used
• The "Add spaces outside parentheses" option does not handle double parentheses correctly
• Error report instead of a warring message will appear, on attempt to apply formatting when a query window is not opened
• The "Align with keyword" option doesn't work for WHERE clause, and variables
• When importing exported formatting template options, imported formatting template will have different name
• New formatting template does not save random names
• Surrogate key cannot be added to a table with already specified key
• The "Format SQL code" option will be triggered using the shortcut keys, if the default settings have been changed, while the "Format SQL code" option is disabled in the add-in options
• The "ApexSQL default" option is missing in the "Format SQL code" menu, when the "Format SQL code" option is changed from "Disable" to "Enable" in the add-in options
• The "No item was found matching name "Object Node"" error is encountered when starting Visual Studio with Server Explorer removed (not present)
• The "Add spaces inside parentheses" and "Add spaces outside parentheses" options are not applied correctly in WHERE statement
• Code refactoring will duplicate INTO keyword with INSERT statements enabled in the add-in options
• The "The ConnectionString property has not been initialized." error is encountered when initiating the "Change parameters" option from Visual Studio
• The shortcut for each of the add-in option can be assigned to non-functional shortcut set
• Importing the add-in options applies to one option only

Enhancements:

• The add-in now fully supports SQL Server 2014

Fixes:

• The "Qualify object names" function does not work when query contains the USE statement
• The "Qualify object names" function does not work for the procedure names
• The "Highlight changes" option does not provide better understanding of the script changes highlight
• The "Change Parameter" refactor will stop working when the default value entered for the table-valued parameter is wrong
• The "Smart Rename" function misses columns used in Joins inside stored procedures
• The effect of changes for settings with a spin box is not shown in the Preview window
• Missing icons in Visual Studio 2005 context menu
• Copied than moved column will be treated as copied in the generated script
• The "Object reference not set to an instance of an object." error is encountered in case any SQL Server 2000 database table is processed via the "Split Table" refactor
• Columns contained in a primary key can be moved to a new table using the "Split Table" refactoring option
• Value of the "Wrap lines" option resets each time when the "Formatting options" dialog is started

Changes:

• New user interface that follows Metro UI style

Enhancements:

• The add-in now integrates with Visual Studio 2013
• The 'Format SQL Code' option can now be executed from the context menu in the query window

Fixes:

• The 'Place joined object on a new line' and 'Place ON on a new line' formatting options are not applied when formatting code

Fixes:

• Saving a reformatted script file using an already existing file name just overwrites the existing file without warning
• The "Value does not fall within the expected range: Microsoft.VisualStudio.CommandBars" error is encountered when SSMS or Visual Studio starts with the add-in installed

Fixes:

• Slow startup time for Visual Studio and SQL Server Management Studio instances

Changes:

• The add-in menu is now under the "ApexSQL" parent menu

Enhancements:

• The add-in now integrates with Visual Studio 2012
• Based on the previously selected formatting settings, the SQL scripts stored on the Windows file system can now be formatted in batches
• Different formatting settings can now be saved as formatting profiles that can be toggled between quickly
• The startup time for a Visual Studio 2010 instance with the integrated add-in, is now up to 300% faster
• The startup time for a SQL Server Management Studio with the integrated add-in, is now up to 500% faster

Fixes:

• The add-in replaces the functionality of SQL Server Management Studio's Ctrl+Shift+R keyboard shortcut with its own
• The "Object reference not set to an instance of an object" error is encountered when using the "Copy SQL code as" command
• The "Manage empty lines" option removes all of the empty lines in the script regardless of the other formatting options related to empty line management
• The "Change several lines into one empty line" option removes all of the empty lines in the script regardless of the other formatting options related to empty line management
• dbForge SQL Complete hampers the functionality of the add-in's refactoring features
• Mapping/remapping hotkeys requires restarting SQL Server Management Studio
• Clicking the "Defaults" button in the "Options" dialog deselects all shortcuts
• The question mark button in the "Options" dialog doesn't initiate Help, but turns the cursor into a question mark instead
• The add-in allows the user to create a shortcut that already exists
• Uninstalling the add-in from Visual Studio doesn't remove the "ApexSQL Refactor" menu item from the Visual Studio menu bar
• The "ApexSql.Common.Formatting.Refactoring.Exceptions.RefactoringException" error is encountered when attempting to split a SQL table using the "Split table" feature
• The add-in's installer does not warn the user if Visual Studio or SQL Server Management Studio are active and running during the installation process
• The add-in's uninstaller does not warn the user that SQL Server Management Studio is active and running during the uninstallation process
• The "Split table" refactor disregards the values for the "Create foreign key on" and "JOIN type" settings, if the dialog isn't reopened after changing them
• A column that has been copied and then moved is treated as if it has only been copied in the change script generated by the "Split table" refactor
• Using the "Replace one-to-many" command on a table that has no foreign keys specified, results in switching between application windows
• Enabling the add-in in Microsoft Visual Studio doesn't enable the add-in's context menu in "Server Explorer" until Microsoft Visual Studio is restarted
• SQL table refactors are accessible for SQL stored procedures from the add-in's context menu in Microsoft Visual Studio 2010 "Server Explorer"
• The "Split table" refactor does not remove invalid columns from the secondary table
• Errors from other SQL Server Management Studio add-ins appear in the add-in's log file
• The "ApexSql.Common.Formatting.Refactoring.Exceptions.RefactoringException" error is encountered when attempting to copy an XML column via the "Split table" refactor
• The "ApexSql.Common.Formatting.Refactoring.Exceptions.RefactoringException" error is encountered when attempting to copy a timestamp column via the "Split table" refactor
• The "ApexSql.Common.Formatting.Refactoring.Exceptions.RefactoringException" error is encountered when attempting to move a full-text index column via the "Split table" refactor
• The "Split table" refactor can move the primary key of the SQL table being split to the new table
• The position of the "Split table" refactor is different in the SQL Server Management Studio's main menu's "ApexSQL Refactor" item and the "Object Explorer" context menu
• The summary is missing when the "Smart rename" refactor is used to change the owner of a SQL table created in SQL Server 2000
• The "Object cannot be found" message is displayed when attempting to rename a trigger in the "Server Explorer" via the "Smart rename" refactor
• The "Object reference not set to an instance of an object." error is encountered when attempting to use the "Split table" refactor on a SQL table stored in a SQL Server 2000 database
• The "Change parameters" refactor can't be used for aggregate functions in SQL Server Management Studio 2012
• The "Split table" refactor in Visual Studio doesn't verify if any of the columns are copied
• The "System.ArgumentException" error is encountered in Visual Studio when attempting to use the "Smart rename" refactor on database objects in a database which is connected via the OLE DB data provider
• The "ApexSql.Common.Formatting.Refactoring.Exceptions.RefactoringException" error is encountered when moving a computed column without the column it depends on
• In Visual Studio 2010, the add-in's context menu in "Server Explorer" is displayed for objects to which it cannot be applied
• The incorrect icon is displayed for the "About ApexSQL Refactor" command located in the SQL Server Management Studio's main menu's "ApexSQL Refactor" item
• The icons displayed for the "Expand wildcards", "Support forum" and "About ApexSQL Refactor" menu items located in the SQL Server Management Studio's main menu's "ApexSQL Refactor" item in SQL Server Management Studio 2008 R2 differ from the ones in SQL Server Management Studio 2012
• The "Add surrogate key" refactor cannot be applied to SQL FileTables even if its keys have been specified
• The change SQL script generated when attempting to rename a SQL FileTable's column using the "Smart rename" refactor is incorrect
• The "Replace one-to-many relationships" refactor does not verify if the associative SQL table name is already in use
• The "Replace one-to-many relationships" refactor does not use the SQL schema of the SQL table containing the one-to-many relationship when creating the associative SQL table
• The "Expand wildcards" refactor does not expand SQL system tables' columns
• The "Include summary description" checkbox status is not preserved when reopening the dialog window
• The name of the "Replace one-to-many relationships" refactor is different in the SQL Server Management Studio's main menu's "ApexSQL Refactor" item and the "Object Explorer" context menu
• The add-in's icon is missing from the "Add/Remove programs"\"Programs and Features" dialog in the Windows Control Panel

Changes:

• The formatting option "Move join operation to new line" has been renamed to "Place first table on new line"
• "An item with the same key has already been added" error is encountered when re-enabling the add-in in Visual Studio 2010
• Predefined matching SQL Server Management Studion and Visual Studion keyboard shortcuts are overriden by keyboard shortcuts defined for the add-in commands
• Native Visual Studio error is encountered on startup when third party .NET developer tools are also installed in Visual Studio 2010

Enhancements:

• The add-in is now
• The add-in now integrates with:
  • Visual Studio 2005
  • Visual Studio 2008
  • Visual Studio 2010
• 'Split Table' refactor is now available for tables via the 'ApexSQL Refactor' Object Explorer or Server Explorer context menu and from the application's main menu
• Fully supports SQL Server 2012 including FileTable refactoring

Fixes:

• Formatting Options | Comments | Add border above/below block comments settings add block comments to previously commented blocks with the same border
• Formatting Options | General | Add spaces inside/outside parenthesis settings don't add spaces to an empty system function call inside a SELECT statement
• The add-in is not available in SQL Server Management Studio 2012 after applying KB2645410 system update
• Product activation dialog is displayed after using free SQL Formatting CTRL + SHIFT + P keyboard shortcut if the trial period has expired on a localized non-English SQL Server Management Studio 2008 R2
• Smart Rename Function Parameter Refactor generates a script that permanently drops referring Table column if the column is calculated using the selected scalar Function
• Qualify Object Names Refactor fully qualifies temporary Table columns
• Qualify Object Names Refactor fully qualifies a non-declared Table variable in a SELECT statement if the Table variable was declared in a previous execution block in the same script
• Qualify Object Names Refactor doesn't fully qualify Sequence in a SELECT NEXT VALUE FOR statement
• Qualify Object Names Refactor doesn't fully qualify Table in a CREATE COLUMNSTORE INDEX ON statement
• Qualify Object Names Refactor doesn't fully qualify Table in an EXECUTE WITH RESULT SETS AS OBJECT statement
• Smart Rename Table Refactor doesn't rename the Table in a Procedure containing EXECUTE WITH RESULT SETS AS OBJECT statement
• Replace One-to-Many Relationship Refactor doesn't delete selected foreign key column and associated index from the source Table
• Formatting Options | Schema Statements | Place parameters on new line | Align with keyword setting aligns parameters with Schema name instead of keyword

Changes:

• Smart Rename Column Refactor will now display an informative message instead of generating an empty script when renaming FileTable column

Enhancements:

• Add-in can now work on SQL Server Management Studio 2012 RC0
• Add-in now fully supports SQL Server 2012 RC0

Fixes:

• Formatting Options Preview drop down menu remains hidden after resizing the dialog and reopening it
• Smart Rename Function Refactor uses incorrect Function name in the resulting script when renaming scalar recursive Function
• Smart Rename Procedure Refactor uses incorrect Procedure name in the resulting script when renaming recursive Procedure
• Formatting Options | General | Remove unnecessary brackets setting doesn't remove excessive brackets used to encapsulate logical operations in a WHERE clause of SELECT statement
• "Critical error occurred when loading metadata information" error is encountered on any Refactor operation if the currently logged user has only 'db_datareader' permission
• Find Unused Variables and Parameters Refactor incorrectly reports unused variable when the variable was used in a WHERE clause of SELECT statement
• "A transport-level error has occurred when receiving results from the server" error is encountered if the connection to the server is lost during the Smart Rename Refactor operation
• "A surrogate column already exists" error is encountered when using Add Surrogate Key Refactor to add a key to a Table using Primary key constraint name the same as Primary key column name
• Formatting Options | General | Always use statement terminator setting doesn't add statement terminators to IF ... ELSE control flow nested statements when Formatting Options | Flow Control | Always use BEGIN and END in IF statements setting is also ON
• CASE keyword is capitalized based on Formatting Options | Capitalization | Format System Functions setting value
• Formatting Options | Value Lists | Place value list on new line setting doesn't differentiate between Align with keyword and Indent spaces values when Formatting options | General | Add spaces inside parentheses and Add spaces outside parentheses settings are ON
• Formatting Options | General | Remove unnecessary brackets setting removes all excess brackets except the last pair if multiple bracket pairs were used to encapsulate the same statement
• Formatting Options | Data Statements | Format Column Lists | Place column on new line | Indent spaces setting doesn't place all columns on individual lines in a SELECT statement following OVER clause
• Replace One-to-Many Relationship Refactor resulting code cannot be executed as it generates a duplicate key name for the Table being refactored when Associative table name is the same as existing Table Index name
• Expand Wildcards Refactor doesn't expand wildcards in SELECT statement nested within an INSERT statement
• Inline comments are formatted and put on a new line even when the Formatting Options | Comments | Format Comments setting is OFF
• "Object reference not set to an instance of an object" error is encountered after attempting to open Add Surrogate Key Refactor dialog for a Table object with no keys
• F1 keyboard shortcut opens both Windows Help and add-in support pages when used in Formatting Options | Export dialog
• A valid Formatting Options | Comments | Add border above/below block comments using [character] is required when accepting Formatting Options changes even when the setting is OFF
• Add-in logs excessive errors during validation of Change Parameters Refactor default parameter values
• Formatting Options | Import dialog doesn't display full default file name for exporting formatting options
• Smart Rename Table Column Refactor resulting script alters Views that don't directly reference renamed column

Changes:

• Add-in log file is now saved in a new location: '%LOCALAPPDATA%\ApexSQL\ApexSQLRefactor2011\ApexSQLRefactor2011.log' or '%USERPROFILE%\Local Settings\Application Data\ApexSQL\ApexSQLRefactor2011\ApexSQLRefactor2011.log' for operating systems prior to Windows Vista

Known issues:

• Check for Updates main menu command for previous add-in major version reports incorrect new add-in version availability

Enhancements:

• 'Add Surrogate Key' Refactor is now available for Tables accessible through the Object Explorer context menu 'Refactors' for Tables and from the application main menu
• Format SQL Code functionality and Formatting Options have been improved to double the number of formatting configuration settings groups and more than double the number of configurable individual formatting settings

Fixes:

• "Selected object cannot be found, please refresh Object Explorer and try again" error message is encountered when initiating Change Parameters Refactor for an aggregate function
• Find Unused Variables and Parameters Refactor doesn't work if the SQL code being refactored contains syntax errors
• "The type 'table' doesn't exist" error message is encountered when attempting to display script preview generated for a Stored Procedure by Change Parameters Refactor if any of the procedure parameters is of TABLE type
• "The type doesn't exist" error message is encountered when attempting to display Change Parameters Refactor script preview if user-defined data type with a non-default schema is specified as a parameter type
• Change Parameters Refactor generates script with syntax errors for stored procedures created with no parameters and ending with ';' terminator
• "An error occurred while validating the default for parameter " error message is encountered after modifying a parameter's default value using Change Parameters Refactor on a SQL Server 2000 stored procedure
• Smart Rename Column Refactor encapsulates the column name with additional square brackets in the generated script after each subsequent refactoring
• Change Parameters Refactor generates code with syntax errors if any of the existing procedure parameters are followed by inline code comments
• "Object with name '.' already exists" error message is encountered when using Smart Rename Refactor to only modify the casing of the object name in a case sensitive database
• Smart Rename Refactor generates script with syntax errors when renaming a view column if the new column name contains '#' character
• Change Parameters Refactor dialog doesn't display schemas of user-defined data type parameters
• Change Parameters Refactor stops validating parameter default value if the parameter type is changed
• Change Parameters Refactor doesn't remove READONLY attribute from a table valued parameter after the parameter's data type is changed
• Encapsulate As Scalar Inline Function Refactor encapsulates entire SELECT statement when only sub-query CASE expression is selected for encapsulation
• Smart Rename Refactor cannot rename an object with non-Latin characters in its name
• Change Parameters Refactor displays only one warning after generating a script to remove multiple parameters that are being used in procedure's body

Changes:

• Evaluation Notice dialog will now appear on the first and each 25th usage of non-free refactors during the evaluation period

Enhancements:

• Add-in can now work on SQL Server Management Studio 2008 R2
• The following new refactors have been added to the application:
  • 'Replace One-to-Many Relationship with Associative Table' Refactor for Tables accessible through the Object Explorer context menu 'Refactors' for Table objects and from the application main menu
  • 'Change Parameters' Refactor for Stored Procedures and Functions accessible through the Object Explorer context menu 'Refactors' for Stored Procedures and Functions
  • 'Find Unused Variables and Parameters' Refactor accessible from the application main menu
• Encapsulate As Refactor now supports View as the target object type
• Formatting Options Preview panel now supports previewing code formatting changes on both built-in examples and current query with changes highlighting
• Main menu and Object Explorer context menu commands have been assigned corresponding graphical icons
• Support related commands have been introduced into application main menu: 'Activate', 'Check for Updates', 'Support Forum' and 'Help'
• Smart Rename Refactor has been assigned a default keyboard shortcut Ctrl+Shift+R

Fixes:

• "ArgumentException" error is encountered on the second attempt to rename an object that had schema just renamed using Smart Rename Refactor
• "Index was outside the bounds of the array" error is encountered when attempting to display a script generated by encapsulating any code as scalar inline function
• Encapsulating CREATE TABLE statement as a table-valued function returns unmodified code without any warning messages
• "Some objects have failed the check for schema object validity" error is encountered when using Smart Rename Refactor to rename a table containing non-alphanumeric characters in its name
• Smart Rename Refactor doesn't rename table columns in case sensitive databases if only column name casing is changed
• Encapsulate As Refactor fails without warning to encapsulate a code if the database already contains an object with the same name
• Smart Rename Table dialog is displayed instead of Smart Rename Column dialog when the selected column's parent table is named with non-alphanumeric characters
• "ArgumentNullException" error is encountered when encapsulating an entire function code as a new scalar inline function
• Previously renamed table column cannot be renamed again if the new name contains an apostrophe
• Format SQL removes blank code segments if the formatted code contains syntax errors
• Smart Rename Refactor doesn't validate new object name length and produces an incorrect script if the maximum SQL Server allowed object name length is exceeded
• Expand Wildcards and Qualify Object Names refactors remove empty lines from the script after refactoring
• Smart Rename Column Refactor doesn't drop foreign key constraints prior to renaming a table column

Changes:

• Application main menu has been moved from the Tools menu to the SQL Server Management Studio menu root bar
• Remove Parameters Refactor has been removed as it was made obsolete by the new Change Parameters Refactor
• Encapsulate As Refactor target type is now only selectable from the main menu 'Encapsulate As' before invoking the refactor dialog
• Qualify Object Names Refactor default keyboard shortcut is now Ctrl+Shift+B
• Expand Wildcards Refactor default keyboard shortcut is now Ctrl+Shift+W
• Format SQL Code Refactor default keyboard shortcut is now Ctrl+Shift+D
• About dialog has been updated for usability and easier access to ApexSQL support pages
• Encapsulate As and Smart Rename dialog 'Refresh' buttons are now named 'Generate preview'
• Smart Rename dialog 'Generated script' text box has been moved to a new tab with the same name
• Copy SQL Code As Customize Language Templates dialog has been updated for usability by introducing graphics and rearranging existing input controls

Known limitations:

• Data type that belongs to a non-default schema cannot be used as a parameter type in Change Parameters Refactor
• Table type cannot be used as a parameter type in Change Parameters Refactor
• Smart Rename Refactor cannot rename non-table objects that already contain characters from a non-English alphabet in their name

Enhancements:

• The following new refactors have been added to the application:
  • 'Smart Rename' Refactor for Tables, Views, Stored Procedures and Functions accessible through the Object Explorer context menu 'Refactors' for specified object types
  • 'Smart Rename Column' Refactor for Columns accessible through the Object Explorer context menu 'Refactors' for Table or View object Columns
  • 'Smart Rename Parameter' Refactor for Parameters accessible through the Object Explorer context menu 'Refactors' for Stored Procedure or Function Parameters
  • 'Remove Parameter' Refactor for Parameters accessible through the Object Explorer context menu 'Refactors' for Stored Procedures, Functions and Stored Procedure or Function Parameters
• Encapsulate Now button is added to the Encapsulate As dialog to allow for immediate execution of the generated Encapsulate code script

Fixes:

• Parameterized SELECT statement cannot be encapsulated as a table inline function
• Expand Wildcards refactor does not work under SQL Server Management Studio 2005 without service packs
• Qualify Object Name refactor does not work under SQL Server Management Studio 2005 without service packs
• Encapsulate As refactor doesn't embrace new object name with square brackets when the name contains special characters
• Warning message about incompatible ApexSQL Debug version displays twice at SQL Server Management Studio start up
• Encapsulate As refactor resulting script doesn't have GO statements in the Modified source section
• Encapsulate As refactor always encapsulates the entire code from the Query Editor window disregarding existing code selection
• "Selected code cannot be refactored" message is displayed each time Encapsulate As Table Inline Function refactor is used in case the selected code contains empty lines
• Encapsulate As refactor dialog size and position is not saved in between SQL Server Management Studio sessions
• SQL Server Management Studio loses focus right after Encapsulate As menu item is clicked
• "Value cannot be null" error is encountered when copying empty code from Encapsulate As dialog
• "Object reference not set to an instance of an object" error is encountered when closing information dialog reporting problems with network communication
• Two BEGINs are added to a new inline function after applying Encapsulate As Inline Function refactor
• "InvalidOperationException" error is encountered when refactoring any object from a database containing space in its name
• 'Place Parenthesis Content on New Line' formatting option is not applied for single-line statements
• 'Place ")" on New Line' formatting option is not applied for data statements
• 'Indent Definitions' formatting option for schemas is not applied if 'Place First Schema Definition on New Line' option is OFF
• 'Use BEGIN-END on Procedures' formatting option always adds additional BEGIN-END pair to a procedure after formatting even if the procedure already has a BEGIN-END pair of statements
• 'Place on New Line' formatting option value for JOINs is not saved between SQL Server Management Studio sessions
• Formatting Options dialog has overlapping and incorrectly sized controls when using 120 DPI screen font resolution
• Encapsulate As Stored Procedure refactor does not encapsulate simple SELECT queries when querying using an asterisk
• Copy SQL Code As refactor does not include GO statements into refactored code
• NOT FOR REPLICATION attribute of a stored procedure is not moved to a new line when formatting schemas
• 'Indent Contents' formatting option for Expressions | Parenthesis section is applied to contents inside parentheses of a single-line statement
• CONSTRAINT keyword inside a table definition is not indented with other columns if 'Indent Definitions' formatting option is ON
• 'Proper case' formatting option for Types is not applied for NUMERIC type
• Table columns are not placed on new line after COMPUTE attribute in case 'Place Next Items on New Line' option is ON

Changes:

• The following features are now free and available after the application trial period expires:
  • 'Format SQL Code' and 'Format SQL Options'
  • 'Expand Wildcards' Refactor
  • 'Qualify Object Name' Refactor
• This version of the add-in is now fully compatible and can coexist with any ApexSQL Debug version
• Add-in log file is now saved in a new location: '%LOCALAPPDATA%\ApexSQL\ApexSQLRefactor2010\ApexSQLRefactor2010.log' or '%USERPROFILE%\Local Settings\Application Data\ApexSQL\ApexSQLRefactor2010\ApexSQLRefactor2010.log' for operating systems prior to Windows Vista
• Encapsulate As and Customize Languages dialogs now have updated control positions, default dialog sizes and new icons in dropdown controls
• Encapsulate As no longer has 'Open in Existing Window' functionality
• Formatting Options dialog has been redesigned for improved usability: option groups are now vertical, only one preview script is available per group of options, multiple individual options were renamed placed in corresponding groups and information balloons are added for each of the individual options
• All add-in proprietary assemblies are now signed using ApexSQL private key and can be manually verified for validity

Fixes:

• SQL Server Management Studio errors are caught and displayed in the Error Reporter even if they did not originate from the add-in
• Error Reporter dialog closes SQL Server Management Studio when dismissed

Changes:

• This version of the add-in can now coexist with ApexSQL Debug version 2008.05 only

Known limitations:

• This version cannot be run successfully on machines where ApexSQL Debug 2008.04 or lower is installed

Enhancements:

• The following new refactors have been added to the application:
  • 'Qualify Object Name' Refactor which fully qualifies all object names found in the SQL code
  • 'Expand Wildcards' Refactor which replaces wildcards found in the SQL code with the actual object names
  • 'Encapsulate As' Refactor which encapsulates selected SQL code into scalar inline functions, table-valued functions, or stored procedures
  • 'Copy SQL Code As' Refactor which encapsulates SQL code into a customizable client code language syntax and copies it to clipboard

Fixes:

• Case operators in SELECT statement aren't placed at new line if the Placement | Expressions | Place operators at New Line option is ON
• For commas that separate tables in a FROM clause, the Placement | Commas in Multi-line SQL | Place at start | Line up to list | One Space After Comma option does not work, that is, no space is added after each comma

Changes:

• Format SQL Code command keyboard shortcut is now Ctrl+Shift+F to avoid collision with the Ctrl+Shift+R option (Refresh Local Cache) in SQL Server Management Studio 2008
• This version of the add-in can now coexist with ApexSQL Debug version 2008.04 only
• Format SQL Code command is now always enabled but will only work if a Query Window is open or will show an informative message otherwise
• This is the first commercial version. The add-in has an evaluation period of 14 days. ApexSQL Refactor 2008 remains to be a FREE version

Known limitations:

• This version cannot be run successfully on machines where ApexSQL Debug 2008.03 or lower is installed

Enhancements:

• Add-in now can work on SQL Server Management Studio 2005 without SP2 or higher

Fixes:

• Proper case option turns data types to camel case (i.e. varChar) instead of proper case (i.e. Varchar)
• SPARSE is not recognized as a keyword
• Proper case option isn't applied to MAX keyword
• Placement | Expressions | At End option doesn't work for expressions in WHERE clause
• Geography, geometry and hyerarchyID data types aren't recognized as such
• Cases | Keywords formatting option isn't applied to NOCOUNT keyword
• Place operators at New Line option is on by default but isn't colored with default color
• 'Space after ( and Before )' option doesn't add space after opening parenthesis
• Line break is missed between variable declaration ending with semicolon and SELECT statement
• Placement | Lists | Place Next Item On New Line option doesn't work for lists in parentheses
• Closing parentheses aren't aligned with opening ones in inline table-valued functions

Features:

• Allows searching for text within database objects including object names
• Allows searching SQL table and SQL view data
• Allows fast access to previously searched objects using search history
• Visualizes all object's relationships
• Change names and schema of tables, views, stored procedures, functions, columns and parameters without breaking dependencies
• Identifies interdependencies of all objects including those SQL Server itself fails to process
• Support encrypted objects
• The add-in now integrates with Visual Studio 2010, 2008 and 2005
• The add-in now integrates with SQL Server Management Studio 2012, 2008 and 2005