ApexSQL Build release notes

Enhancements:

• Export database into:
  • Script folder
  • Snapshot
  • Source control
• Save project as batch file
• Support for SQL Server 2017 CTP 2
• Support for SQL Server on Amazon RDS
• Full support for Azure SQL Database
• Visual Studio 2015 and Visual Studio 2017 C# solution and executable installer output
• GUI themes:
  • White
  • Colorful
  • Dark
• CLI switches:
  • Package options
    • Compression [/pkcm]
    • Error handling [/pke]
    • Author [/pcaa]
    • Company [/pkco]
    • Legal [/pkal]
    • Comments [/pkac]
    • Visual studio version [/vsv]
    • Create manifest file [/cmf]
    • Create script file [/cdf]
    • Create CLI file [/ccf]

Fixes:

• “Cannot drop user defined type ‘object_name’ because it is being referenced by ‘object_name’” error is encountered when updating an existing database which contains SQL user-defined data types
• Objects from a wrong database will be shown in the Build objects step when two databases are linked to the same source control repository in separate folders
• “Script execution failed” error is encountered after clicking the Finish button in the Consolidate scripts wizard
• Grid in the Post deployment script step appears to be empty when backtracking through the wizard and it doesn’t allow adding scripts which were previously added
• “Error 1934, Severity 16, Line 2522 (at line 51 within procedure 'ApexSQL_SourceControl_DDLTrigger') SELECT failed...” error is encountered when creating a new database from a snapshot that contains the mentioned trigger after the Finish button is clicked

Changes:

• The Automatically check for updates on application startup option is now checked by default

Enhancements:

• The “Include static data” option in the Options tab and in the Static data preview step in the wizard
• CLI switches:
  • Connection options:
    • Server [/s]
    • Database [/d]
    • User [/u]
    • Password [/p]
  • Script options:
    • Script drops [/sdr]
    • Script filegroups [/sfg]
    • Script logins [/slg]
    • Script names [/snm]
    • Script collation [/sc]
    • Script ANSI options [/sao]
    • Script triggers [/str]
    • Script permissions [/sp]
    • Script extended properties [/sep]
    • Script use [/su]
    • Include transaction [/ith]
    • Comments [/cm]
    • Print statements [/ps]
    • Database script [/ds]
    • Database script type [/dst]
    • Drop if exist [/die]
    • Output script [/os]
  • Specific options:
    • Project type [/pt]
    • Output type [/ot]
    • Output name [/on]
    • Source type [/st]
    • Source name [/sn]
    • Output action type [/oat]
    • Include static data [/isd]
    • Invalid objects [/io]
    • Compatibility level [/cl]
    • Postscript file path [/postfp]
  • Source control options:
    • Source control user [/scr]
    • Source control password [/scp]
    • Source control server [/scs]
    • Source control repository [/scr]
    • Source control branch [/scb]
    • Source control project [/scj]
    • Source control label [/scl]
    • Source control folder [/scf]
  • Create database options:
    • Database directory [/dbd]
    • Database log directory [/dbld]
    • Database collation [/dbc]
    • Database recovery mode [/dbrv]
    • Database size [/dbs]
  • Help to HTML [/hth]
  • Silent [/slt]
  • Play sound upon finished operation [/be]
  • Logging level [/log]:
    • Errors
    • Warnings
    • All
    • None
  • Return error codes [/rc]
• CLI return error codes:
  • Invalid switch [2]
  • Duplicated switch [3]
  • Missing argument [5]
  • Missing a dependent switch [6]
  • Value out of range [8]
  • Invalid file path [9]
  • Invalid project file [10]
  • Unsupported edition [11]
  • Invalid activation key [12]
  • Trial has expired [13]
  • Connection timeout [14]
  • Connection failed [15]
  • Operation cancelled [17]
  • Application error [18]
  • Execution error [19]
  • Execution timeout [20]
  • Insufficient permissions [21]

Fixes:

• "'Create view' must be the first statement in a query batch" error is encountered when scripts are consolidated and run using the executable installer
• "Index was out of range. Must be non-negative and less than the size of the collection" error is encountered when moving the script up in the list, reversing the order of the files, and then moving the same script up again
• "The module will still be created; however, it cannot run successfully until the object exists" message is encountered in the Script execution results window while creating database from a source control repository
• The Get database properties from input source option in the Connect to SQL Server dialog only retrieves the collation information when building a database from a script file or when creating an executable installer from a script file
• "Repository path is not empty. Link to empty repository or use the one created by ApexSQL Source Control" message is encountered when the Finish or Test button is clicked in the Source control wizard for existing Git repository
• The Get database properties from input source button is missing when building a database from the source control repository
• “Execution error: Error 1934, Severity 16, Line 10 (at line 51 within procedure 'ApexSQL_SourceControl_DDLTrigger')” error is encountered when trying to create a database when the ansi_padding is enabled
• "Index was outside the bounds of the array" error message is encountered when building a database using a project file in CLI
• Password for connecting to SQL Server is not saved in the project file
• When using the “script drops” option SQL user guest cannot be dropped
• "The TFS project ’project name’ is not found" error is encountered when executing project file from the CLI which uses TFS server as an input type
• When database name is changed in the Database options window it is not saved in the project file
• "Script execution failed" error is encountered when trying to consolidate scripts after the Finish step
• "Could not find a part of the path 'C:\Users\UserName\AppData\Local\Temp\ApexSQLBuild\SourceControl\’project name’’" error is encountered while reloading the script folder for Team Foundation Server
• "An error occurred while connecting to the source control server... TCP connect to local:1666 failed. No such host is known." error is encountered when using individual CLI switches to build a database from a Perforce source control server
• "Value cannot be null. Parameter name: stream" error is encountered when running executable installer
• "Database does not exist" error is encountered when updating an existing database using a project file via CLI
• The "Update an existing database" functionality does not create working update script
• When updating an existing database all SQL database objects will be shown in the Dependencies tab even if only one object, which has no dependencies, is checked for updating

Changes:

• Execute multiple scripts on multiple databases functionality is now only available in ApexSQL Propagate
• Switch [/pf] is renamed to [/pr]

Enhancements:

• SQL Server 2016 CTP3 support
• /dn CLI switch for recognition of invalid referenced objects

Fixes:

• The application creates additional files, when deploying a database with an executable installer
• The Connection manager appears after the Open script in editor option is selected for building the SQL script output file
• Unsupported SQL Server 2000 version is allowed to be selected after clicking the Get database properties from input source button for specific Script folder as the source
• Missing compatibility for SQL Server 2005 will cause specific errors in the output script
• Missing a button to Remove server from the Database deployment list
• Local servers are not displayed in the Browse for servers window
• "An error occurred while compiling" error is encountered when a wrong path is entered for the project file in the CLI

Changes:

• The application now requires Microsoft .NET framework 4.5
• Windows Server 2003 is no longer supported

Enhancements:

• Base CLI support for executing project files: /project or /pf - specifies the path of the project file

Fixes:

• After uninstallation certain files and folders remained in Program Files
• The application cannot process data if Get by label is selected
• Redundant folders are created in the following location: C:\Users\UserName\AppData\Local\ApexSQL
• Wrong version in the name of the folder in the following location: C:\Users\UserName\Documents\ApexSQL
• The application does not have "any CPU" configuration
• "Could not load file or assembly" error is encountered when the Finish button is clicked while setting up the Git project
• "Sequence contains no matching element" error is encountered when retrieving files from the Mercurial source control project
• "Source control error: GetByLabel failed with message 'Message: Could not find label 'label1' for '$/DatabaseSettings.xml''" error is encountered when a label is chosen for the Subversion source control project
• "Source control error: 'Sync' operation failed with message: 'Invalid changelist/client/label/date '@..." error is encountered when a label is chosen for the Perforce source control project
• "Source control error: 'Sync' operation failed with message: 'Invalid changelist/client/label/date '@..." error is encountered when the project is edited and another label is chosen for the Perforce source control project and compared
• The close button in the deployment wizard doesn't offer to save the project file after it is clicked
• The application stops working when inserting wrong credentials in SVN
• "Connection was failed with message: "The type initializer for N'Git threw an exception"" when trying to connect to Git
• The application cannot connect to a project file in SVN

Known issues:

• Missing a compatibility for SQL Server 2005 will cause specific errors in the output script

Enhancements:

• Support for Azure SQL Database V12
• Full support for Mercurial source control system
• Full support for Perforce source control system

Fixes:

• Missing expand/collapse tooltips in the Action summaries step of wizard
• "Parse error: Error : [Incorrect syntax near 'FROM'] at [position: X, line: Y, column: Z]" error is encountered when scripting ASSEMBLY with binary value
• Multiple errors are reported when executing script created from a Script folder or a Snapshot
• Specific stored procedure is not scripted well when building from a Script folder or a Snapshot
• The application does not recognize the creation of multiple objects via incremental WHILE loop
• The source control credentials are not remembered during the one or multiple sessions while working with the application
• "System.InvalidOperationException" error is ecountered when trying to connect to the Perforce source control system
• An opened project does not appear in the "Recent projects" list, unless its executed
• The "Recent projects" list becomes empty after application is updated
• Missing icons for databases in the "Execution results" pane, after executing scripts on multiple databases
• Missing tooltips for all buttons in the "Execute scripts" window
• Inconsistent behavior of Apply changes options button
• The scroll bar at "The following error were detected while parsing source scripts" step is never positioned at beginning
• Small buttons in the "Execute scripts" window are user unfriendly and they need names or tooltips about their function
• Nonstandard behavior of the "Execute scripts" window while minimizing it
• Missing borders for the opened tab names inside "Execute scripts" window
• The incorrect release notes are shown when prompted with the "ApexSQL automatic update service" window
• The generated script has no columns defined for the clustered primary key
• Mismatch between the object name and the file name when source is set to Team Foundation Server and the destination is a database
• The "Script permissions" option in the "Options" tab is cut off

Changes:

• Support for SourceGear Vault source control system has been deprecated
• Support for Microsoft Visual SourceSafe source control system has been deprecated
• Support for MSSCCI-compliant source control systems have been deprecated

Enhancements:

• The application now fully supports Git up to version 1.9.4

Fixes:

• The SQL Server authentication is offered by default, unlike in other applications, when adding a new SQL server to deployment list
• Incorrect form of login process in the "Edit database deployment list" section
• Value greater than 100 cannot be utilized when setting version for built script
• In the "Internal script editor" section there is no option "Check for syntax"
• The IF statement specified in the script is completely ignored when the application builds a new script
• Changing the "Output action" value resets the "File path" value in the "Save script" section
• The "Advanced <<" button resets check boxes
• A database name cannot be changed when building a database from the multiple scripts
• The "System. ArgumentException" error is encountered when trying to add all scripts from the folder

Changes:

• Improved user interface that follows Metro UI style

Enhancements:

• The application now fully supports SQL Server 2014
• The application now fully supports Apache Subversion up to version 1.8.9
• The application now supports Team Foundation Server 2013

Fixes:

• Unnecessary warning message after closing an empty project
• The Script wizard closes after choosing the non-installed SQL Server version
• The "ApexSQL Error 404 - page not found" error is encountered when initiating help from the application
• The "Error/Warning list" dialog does not have a vertical scroll
• Invalid link for the "Help" button in the "Execute scripts on multiple databases" window
• Invalid link for the "Help" button in the "Resources" tab
• The "Other" output options are not editable
• The "?" button for the help leads to the "Not found" page
• The "Index was out of range. Must be non-negative and less than the size of the collection." error is encountered during the order manipulation in the "Add SQL script files to the package" dialog
• The "Enter a valid xyz file" dialog is displayed when canceling a project
• Redundant application name in the warning dialog "ApexSQL Build - ApexSQL Build Do you want to save project before exiting?"
• Visual Studio 2012 and 2013 are not offered when selecting the project file format during the package build for C#
• Stepping back through the "Build" wizard does not reset the "abandoned" steps
• The "Refresh" and "Execute" buttons are disabled by default in the internal editor
• The "The page is not redirecting properly" error is encountered when initiating help from the internal editor

Changes:

• New user interface that follows Metro UI style

Enhancements:

• The application now supports Team Foundation Server 2013
• The application is now FIPS compliant

Fixes:

• Script containing the USE <database> statement and all scripts after that are executed on the database defined in the USE statement instead on the selected database
• Clicking on the Cancel button is not canceling the build script creation
• The default database name is always used when creating an update script
• When adding optional scripts all files are shown instead of just SQL scripts although the filter is set only to sql files
• The "Add Optional Scripts" option dialog is titled wrong
• Default options are not applied when clicking the 'Defaults' button in the 'Scripting options' dialog
• Default settings are still applied when clicking the 'Defaults' button and then the 'Cancel' button in the 'Options' dialog
• The action titles 'Create a new database', 'Update an existing database' and 'Other' in the main window are clickable
• Inconsistent title fonts in similar menus between different applications
• The 'Clear unpinned items' command in the 'Recent projects' section does not clear the list of projects from the main grid
• Grammar error on the 'Resources' tab
• Automatic check status change of the databases checkbox in the 'Deployment Database List' window under the 'Execute Scripts' dialog is not indicating properly
• The application is continuing to process when the 'Save a copy of script' options is checked but path is left blank in the 'Output options' section under the 'General' tab
• The "Please enter valid directory for backup" error is encountered when the 'Use Default Backup Directory' option is selected in the 'Output options' page
• Visual inconsistencies are noticeable in various dialogs if the 120 DPI font size is used
• Objects dependencies analysis process terminates without stating the problematic object if script parsing is failed due to a syntax error
• The Check connections button in the Execute scripts dialog is not functional if no database is checked
• The Refresh button is not working when adding databases to the deployment list in the 'Edit Database Deployment List' dialog
• The progress dialog window for executing scripts remains with the 'Running' status in the title when the process is complete
• Only a single script can be selected for 'Add SQL script files to the package' page of the 'Package scripts' dialog
• There is no option to exclude header in the resulting script
• The warning that valid Source control settings must be entered is displayed when using the Source Control option, before the 'Save project' dialog is displayed
• The 'Execute script' project cannot be saved, only the script list
• The 'Build a deployment script', the 'Build and package deployment script into C# project' and the 'Build and package a deployment script into .NET executable file' dialogs are identical
• If selected, the 'On error' option is ignored when executing scripts
• The Execute Script dialog does not minimize to taskbar
• The 'Script USE for databases' option under the 'Scripting options' tab in the Options dialog is not marked blue as a default option
• The 'Action summaries' pane is not updated after scripting options are modified
• There is no warning if a target database already exists when executing deployment script if the 'Build a deployment script' option is used
• Full-Text Search dependent objects cannot be deployed via .NET executable file
• There is no warning if a .sql file already exists when using the 'Save a copy of script' option in the 'Output options' page of the Build new database dialog
• The 'Script filegroups' setting doesn't result with custom filegroups deployed in the target database
• Logins cannot be deployed using .NET executable packages
• It is not possible to choose if the .sql scripts will be loaded only from the selected folder or from all folders recursively when using the Script file as an input source
• The "CREATE INDEX failed because the following SET options have incorrect settings: 'ARITHABORT'" error is encountered when deploying a specific SQL Server 2000 database
• Scripts are removed without any confirmation from the 'Add optional scripts that will be executed after the database is created' dialog
• The 'Deployment database list' window items are not selected/deselected with the first Space tab press
• The removing script command is not properly named in the Execute Script dialog
• The application fails to create extended properties for database triggers when creating the .NET executable file
• The "System.IO.DirectoryNotFoundException" error is encountered when using the 'Consolidate scripts into a single script' option and one of the selected files is missing
• There is no option to select several scripts at once for removal from the 'Scripts' list in the 'Execute scripts' dialog
• Information about datasource used in all "Update" projects is missing in the 'Project management' dialog
• Skipped scripts are counted as failed when using the 'On Error: Stop executing' option in the 'Execute scripts' dialog
• The process status is not updated in the Project Management dialog for executed projects
• The application fails to deploy full-text indexes properly
• The application doesn't retrieve object names properly
• The FROM field is empty for ASSEMBLY scripting in deploying script
• Font spacing in label names in the Main window is irregular
• Database update via .NET package freezes and must be terminated manually because the 'Cancel' button doesn't respond
• The application cannot create a database from a specific script
• The copyright 'ApexSQL LLC' label is missing in the properties window of the applications .exe file in the details tab
• The 'Get database properties from input source' option reverts the created database name to default
• The 'Select at least one object to include in the build' warning message is shown when clicking on the 'Back' button in the 'Select at least one object to include in the build creation' step
• There is no Save dialog when canceling or exiting a project
• Incorrect link leads to the nonexistent page when clicking on the help icon in the 'Connect to SQL Server' dialog
• The application can be uninstalled while it is running
• The 'Object reference not set to an instance of an object' error is encountered when attempting to reload a script folder with Unicode characters
• In the 'Edit Database Deployment List' window databases can be added one by one only
• A .NET executable created to update an existing database cannot be successfully executed, since SQL column attributes cannot be created and SQL users cannot be mapped to SQL logins

Features:

• Builds new or updates existing databases creating deployment SQL scripts, C# packages or .NET executables
• Creates deployment scripts, packages and executables from SQL scripts, script folders, snapshots or source control
• Consolidates multiple scripts into a single SQL script, C# package or .NET executable
• Executes SQL scripts against multiple databases
• Allows specifying the database object to be created or updated
• Allows packaging of custom SQL scripts to be executed post-deployment
• Recognizes and accurately processes all objects - interdependencies
• Rearranges SQL scripts' statements to ensure their execution in the proper dependency order
• Supports encrypted objects
• Supports SQL Server 2012, 2008 R2, 2008 and 2005