ApexSQL Source Control release notes

Enhancements:

• Associate Team Foundation Server work item with a committed changeset
• Team Foundation Server check-in policy
• Create and merge branches

Fixes:

• The Action center tab does not display differences when a column is renamed
• The Defaults button in the add-in option does not reset the Show warning for changing policies in the Administration tab option
• An object will be shown like it is locked by someone else when it is locked, edited and the change is reverted
• Object filtering in the Repository only tab in the add-in options can be performed only for the schemas and object types that exists in a selected database
• Filtering in the Object type drop down list is not available for the Database tab in the add-in options under the Object filtering tab
• The Options form closes upon importing object selection in the Object filtering step when a database is not previously selected from the drop-down list
• Missing informative message that the object selection is exported successfully
• Missing option to navigate to the location where the object selection is exported
• Object excluded in the Global settings tab for one database will be automatically excluded for all other database where the object with the same name exists
• Selecting a database in the global settings is not synchronized with the local settings
• The Action center tab does not inform the user that custom scripts are added after the Options form is closed upon adding a custom scripts folder path
• Schema name is not scripted in the Action center tab for the specific SQL database objects
• The Browse button for the Custom scripts path cannot be used even if the correct path is specified
• The Options form closes when selecting a database from the drop down list in the Local filtering tab
• Connecting to the same SQL Server instance using different connection string shows previously linked databases as unlinked
• The user who excluded objects globally is not shown in the Excluded objects table
• An object that was linked before it is excluded in the Global settings tab becomes unlinked after it is included back
• "An exception occurred while executing a Transact-SQL statement or batch" error is encountered on expanding the Tables node when a database is linked to SQL Server 2017
• "'System.Collections.Generic.List`1 System.Guid" error is encountered in Visual Studio Team Explorer 2015 when the add-in installed
• "Cannot set LocalPath. Method not found:SystemCollections.Generic.IEnumerable" error is encountered when linking the second database to a Team Foundation Server repository on a SQL Server instance where one database is already linked
• The add-in fails to link a database when specific characters are used as a username
• SQL database object is not recognized as linked if it contains the '&' character in its name
• "Could not load file or assembly 'Microsoft.SqlServer.Types, Version=12.0.0.0'" error is encountered when applying the static data
• "Could not load file or assembly 'Microsoft.TeamFoundation.VersionControl.Controls, Version=14.0.0.0" error is encountered when committing objects to a Team Foundation Server 2015
• "System.ArgumentOutOfRangeException. Length cannot be less than zero." error is encountered when the Link database to source control option is clicked from the Object Explorer context menu
• Object status form shows incorrect user that performed a check out or lock operation on an object when previously accessing SQL Server as a different user and performing a check out or lock operations
• "Cannot check in pending changes. The array must contain at least one element" error is encountered when committing the static data to source control

Enhancements:

• Support for Git source control system hosted on Visual Studio Team Services
• Support for Bitbucket in an Active Directory
• Script difference panel options:
  • Change colors
  • Increase/Decrease font size
  • Find
  • Word wrap

Fixes:

• "Item <item_name> is obsoleted. Root.Find() must be used to get actual item" error is encountered when creating a sub-folder in the Team Services repository
• SQL object types included in the add-in options after the database is already linked will not appear in the Action center tab
• Differences are not shown consistently when the Show different rows only option is checked
• New Team Foundation Server project cannot be created through the add-in wizard when using Team Foundation Server 2015 or Team Foundation Server 2017
• The information about SQL users is shown in the Object status window after applying changes to a database even when the status of the object is unchanged
• Change sets are inconsistently ordered in the Project history dialog
• Warning message in the System login step of the source control wizard is not focused when a non-existing project name is specified for the Git repository
• Differences between source control and database version of a SQL table are not highlighted correctly in the Differences section when a not null constraint is added
• The add-in generates different SQL scripts when applying a change through the Action center tab and through the Project history dialog
• Action center tab SQL script differences are highlighted on one side only when a column is renamed
• Missing informative message in the Action center tab when changes are detected after including/excluding SQL schemas from the Object filtering tab in the add-in options
• Database change log dialog filter finds only records that start with the specified filter value
• Username and password fields are mandatory in the System login step of the source control wizard when linking a database to a local repository
• The Action center toolbar command refreshes the Action center tab only if the Action center tab is active
• Inappropriate differences are highlighted in the Action center tab when differences are detected for the custom scripts
• "Database changes detected. Refresh the "Action center" tab" message appears in the Action center tab after closing the Options form even when no database changes were made
• Schema field combo box filter is missing in the Database section under the Object filtering tab
• Key column filtering does not work in the Static data dialog
• Static data dialog filter row works only for values that starts with the specified value
• The Migration scripts window is displayed even when there are no migration scripts specified
• "Database changes detected. Refresh the "Action center" tab" message appears when changing the Enable committing other users changes option
• "Parsing error: Incorrect syntax near 'COMPRESS_ALL_ROW_GROUPS'" error is encountered when applying a change that adds a dropped column from source control to the database
• "Object reference not set to an instance of an object" error is encountered when applying specific changes from source control to database after changing the script option settings
• "Object reference not set to an instance of an object" error is encountered when committing a deletion of a SQL database user that contains a dot in its name
• "There was a conflict while trying to commit" error is encountered when committing a change made by another user using the shared model
• The Ignore comments option does not work
• The Ignore Lock_Escalation option does not work
• The Ignore white spaces option does not work
• "Invalid object name dbo.ApexSQL_SC_ObjectsTable" error is encountered when using the keyboard shortcut for the Object status form while a database in the Object Explorer pane is linked using the dedicated model
• "The link to source control is removed" error is encountered when using the keyboard shortcut for the Static data form in case any object is highlighted in the Object Explorer pane
• The Go offline setting will reset upon restarting SQL Server Management Studio
• The Project history dialog shows incorrect list of committed changes when multiple databases are linked to the same Subversion repository
• The Object filtering step in the source control wizard does not export/import object selection settings properly
• Running instance of the SQL Server Management Studio stops working when installing the add-in
• The add-in Object Explorer context menu commands are disabled until clicking on another Object Explorer node and clicking back
• "Cannot drop database "ApexSQL_SourceControl" because it is currently in use." error is encountered when linking a SQL Server 2005 database
• The add-in fails to apply static data changes if the identity column of a SQL table in source control is different from the database version
• Execution results cannot be copied from the Script execution results window after trying to apply changes from source control to the database
• "Cannot open database 'database_name' requested by the login. The login failed" error is encountered when the add-in database is deleted while at least one database is still linked using the shared model
• Changing the SQL column from null to not null will not be detected as a change by the add-in
• The Initializing progress bar remains open after applying changes using the alternative synchronization engine activated from the add-in options
• The Apply button is disabled after filtering objects in the Action center tab
• "Cannot open database 'database_name' requested by the login. The login failed" error is encountered after the add-in is updated
• "Invalid object name 'information_schema.schemata'." error when linking a SQL Server 2005 database
• "There are uncommitted changes in some of the linked databases. Exit anyway?" message appears twice when closing the SQL Server Management Studio
• A conflict occurs in the shared model when checking out and checking in an object edited by another user
• "Commit failed. Check log file for more details" error is encountered when committing the static data for a SQL Server 2005 database
• The progress bar where the add-in is checking if a database is offline, before initiating the source control wizard, works indefinitely when the currently connected SQL user does not have sufficient permissions for the database
• The information about minimal permissions required for the shared model in the source control wizard is not correct when no databases are linked
• Capitalization differences in SQL schema name are not ignored in the Action center tab
• "An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name." error is encountered when linking a SQL Server 2008 R2 database
• "Table 'table_name' not found" error is encountered when applying changes from source control to the database when the synchronization script includes dependent objects that are not a part of the source control
• "SELECT failed because the following SET options have incorrect settings: 'ANSI_PADDING'." error is encountered when modifying any SQL database object while the add-in DDL trigger is present on the server
• Linked database can be specified as a database to host framework objects by typing its name in the Database field when linking a database using the shared model
• "Cannot access destination table 'table_name'." error is encountered when applying static data from source control to the database
• Custom scripts remain in the Action center tab after committing to source control
• Differences for the committed custom script are shown in the Action center tab after the initial commit
• The Warning about pending changes on exit option does not work
• The Action center tab is not refreshed after switching between linked databases in the Object Explorer pane and then using the Action center toolbar command
• Migration script item will be duplicated in the Action center tab each time only the migration script is applied from source control to a database
• "Object Schema [guest] is ignored: object already exists." error is encountered when applying schema changes from source control to the database after upgrading from the previous version of the add-in
• Team Foundation Server project created inside the repository cannot be deleted through the add-in wizard
• The Migration scripts feature doesn't work when applying changes from source control to the database
• SQL Server Management Studio stops responding after applying large amount of static data from source control to the database
• "The user does not have sufficient permissions to link databases as shared" error is encountered when using the Import connections feature in the shared model
• "Invalid object name 'ApexSQL_SourceControl.UserMappings'" error is encountered when linking the second database in the shared model on SQL Server 2008 or SQL Server 2008 R2
• "Test succeeded" message appears when testing the SSH connection with the URL that is generated for the HTTP connection when linking a database to a Git repository
• "Source control error: Failed commit! Error Exception caught during execution of push command" error is encountered when committing changes to a Git repository when the HTTP URL is specified instead of SSH
• "Database is already linked in the dedicated model" message appears when trying to link a database using the shared model from another location after it is already linked using the shared model
• "Source control error: Provided local path doesn't exist" error is encountered when trying to get a specific version of an object from the source control history
• The Project history dialog closes when trying to apply changes when the linked Subversion project is nested
• Progress bar when applying changes from source control to database is not working correctly
• Static data is not visible in the source control history after it is committed to the source control
• "Enter description" message appears in the Migration scripts dialog even though the description cannot be added like this
• "Object reference not set to an instance of an object" error is encountered when changing the add-in options while the linked database is not selected in the Object Explorer pane
• "Cannot set local path: Method not found" error is encountered when linking a database from the same SQL Server instance to the Team Foundation Server repository where another database is already linked

Changes:

• Support for SQL Server Management Studio 2008 and SQL Server Management Studio 2008 R2 integration has been deprecated
• The add-in now requires Microsoft .NET framework 4.5

Enhancements:

• SQL Server vNext CTP1 support
• Team Foundation Server 2017 support
• Progress bar indicator is now available when checking permissions level for a database that is selected to be linked to source control

Fixes:

• "Failed to connect to server 'server_name'." error is encountered when linking the first database on a server, in case the user does not have the CONTROL SERVER permission
• SQL script comment containing the information about the static data is in a single line in the "Get changes" form when applying the static data for more than one table

Enhancements:

• Significant improvements in the shared SQL source control development model implementation
• SQL Server Management Studio v17.0 RC1 integration
• Global object filtering
• An option to manage number of changesets shown in the history
• An option to manage number of labels shown in the “Labels” form

Fixes:

• The add-in cannot manipulate with Indexes as separate object types
• "An error occurred while adding a new label" error message is encountered when naming a label with spaces between words for Git repository
• Checking the history while in the offline mode is active does not work in some cases
• SQL Server Management Studio stopped working when disconnecting Analysis services
• "Cannot access destination table 'ApexSQL_SC_ObjectsTable'." error when connecting to SQL Server 2005 from SQL Server Management Studio 2014
• The add-in does not accept the '/' character in the branch name
• Shortcuts are not working in SQL Server Management Studio 2016
• "There was a conflict while trying to commit" error appears when trying to commit the change in shared model
• The "Database change log" form does not show rename operations
• A non-intuitive message is shown when starting SQL Server Management Studio, in case the password for the repository must be specified
• "Database changes detected" message is shown when unlinking a single object from the Object Explorer pane
• Database cannot be linked to a subfolder when linking to the Subversion repository
• Changing the location of the intermediary folder does not move any data to the specified folder
• SQL Azure database cannot be linked using the shared model
• The user can link a database with insufficient permissions, although there will be no objects shown in the "Action center" tab
• User defined data types are not properly tracked by the "Action center" tab
• "Object reference not set to an instance of an object" error appears when changing the ANSI option
• Multiple indexes cannot be rebuilt by a running procedure while the Permissive policy is enabled
• Creating of new projects from the Source control setup wizard for the latest version of Mercurial source control system 3.9 and above is not working in some cases
• Wrong information message is shown when switching from one database to another in the “Object explorer” pane
• Migration script is shown in the “Action center” tab as a difference even after it is committed to the repository
• "Database and source control repository are synced" message appears after executing the script to alter specific objects in a database
• The FILLFACTOR is missing for a table in the Script difference view pane of the “Action center” tab, even after executing the specific script that creates it
• System login credentials are not remembered for the same source control system, in some cases, when switching from the Dedicated to the Shared model
• "Permissive policy is enabled on this database. Object ‘object_name’ must be checked out before editing" error is encountered when an object is unlinked and dropped from a database
• A specific object is shown as static data in the “Action center” tab, after changing its structure
• Undoing the check out operation with the “Get latest” option will be prevented if the Permissive policy is enabled
• The "Edited by" column can be edited in the "Action center" tab
• Inappropriate message when changes made by other users cannot be committed
• Clicking the “Defaults” button in the add-in options will restart the script options settings to the inappropriate state
• "Some framework objects are not created successfully" error is encountered when putting framework objects in a single database
• The "Offline" mode does not work in some cases
• "The server principal 'user_name' is not able to access the database "database_name" under the current security context." error when making a change on a database
• "Invalid object name 'containedDb.sys.database_principals'" error is encountered when trying to manually drop the add-in DDL trigger
• The "Object status" form does not show objects for other databases, if more than one database from the same SQL Server is linked
• "Unable to connect to a repository at URL 'file:///C:/Repo/Subversion9'" error is encountered when trying to link a database to Subversion repository
• "Invalid object name 'ApexSQL_SC_UsersMappings'" error is encountered when linking a database in the dedicated model
• "Unable to cast object of type 'System.Int32' to type 'System.String'" when linking a database to a Git or Subversion repository
• The add in database will be removed after the last user unlinks a database
• The "Action center" tab cannot commit any objects on TFS, when working in the shared model
• Changes made in the "Local filtering" tab will not be saved after closing the "Options" form
• SQL Server Management Studio closes when creating a new TFS project through the add-in wizard
• The add-in shows all objects in the "Action center" tab, after the initial commit, with false differences
• DatabaseSettings.xml file is empty when linking a database to a working folder
• The "Action center" tab goes offline upon SQL Server Management Studio restart, in case the repository password is not saved during the linking process
• Object filtering on a local level overrides the global filtering upon opening the add-in options form
• An incorrect message is created when an existing database is used for framework objects
• "Edited by" is not being logged, in some cases, when changes to an object are made
• Objects are displayed in the "Object filtering" tab, even when the "Uncheck all" option is used
• ApexSQL Source Control trigger is not created in SQL Server Management Studio 2008 R2 when using the shared model
• "Must declare the scalar variable "@username"." error is sometimes encountered when linking a database in the shared model
• The add-in fails to integrate in SQL Server Management Studio 2008 in some circumstances
• The add-in trigger is not created when linking a database in the shared model hosted on SQL Server 2008

Enhancements:

• Support for SQL Server on Amazon RDS
• New Script options tab in the Options window:
  • Ignore comparison options
  • Synchronization options
  • Manage owners options
• Improved Import connections feature:
  • New Connections tab in the Options window
  • New pane for choosing databases that will be linked

Fixes:

• Created nested projects are shown as a root for the Subversion repository
• Changing the location of the working copy will impact only databases that are linked after the change
• The "ApexSQL_SC_DatabaseLog" table is not ignored when linking Azure SQL Database using the dedicated model
• The add-in keeps asking for the password upon initiating the Action center, although it does not require any credentials when connecting to a local Mercurial repository
• "Some ApexSQL Source Control framework objects were not created successfully" error is encountered when linking an Azure SQL Database
• The Project history shows the "Initializing" progress bar when the first commit is selected in the project history form, even if the form itself is fully loaded
• The created SQL assembly is shown as object type "All" in the "Object status" form
• “Failed to create a database for checking a validation of migration scripts” error is encountered when trying to apply a change that contains a migration script
• The user is not properly shown in the History forms when working with migration scripts on Team Foundation Server
• Locally deleted migration script cannot be reverted through the "Action center" tab, after deleting from the "Migration scripts" form
• New Team Foundation Server project fails to appear after it is created through the Source control setup wizard in the Project form
• Static data is not shown in the same way across all source control systems
• “An error occurred while adding a new label” error message is encountered when naming a label with spaces between words for Git repository
• Setting up the comment will not affect the Action center if it is opened
• Specific objects cannot be excluded from being version controlled
• “Object reference not set to an instance of an object” error is encountered when committing specific changes to a Git repository
• The add-in’s DDL trigger remains enabled when applying changes from the repository using the Shared model
• The add-in throws an error when applying changes for the specific user that exists on the repository only
• No scripts are shown in the "Differences" section of the "Action center" tab for files that have specific line feed settings
• “[Line 1, Column: 3] Incorrect syntax near \” error is encountered when applying changes using the alternative synchronization engine
• The "External data sources" are not supported as object type
• Excluded schema is shown in the Action center tab
• An error is encountered when applying changes when a schema is excluded from being version controlled
• The "Automatically check for updates on application startup" option does not work
• SQL script of the specific object will not be shown in the "Differences" section of the "Action center" tab
• ”User 'user name' is currently linking the same database” message is encountered after the initial user is back to the first step of the wizard
• SQL Server Management Studio stops working when the framework objects are missing for the linked database
• The add-in does not accept the '/' character in the branch name
• “Some ApexSQL Source Control framework objects were not created successfully” error is encountered after relinking a database
• Specific SQL indexes are not scripted properly to the source control repository
• False differences are shown when linking a database populated by the other ApexSQL tool
• Scripting inconsistencies are encountered when working with the repository populated by ApexSQL Diff
• The "ON PRIMARY" is not properly scripted when working with SQL Server 2008 database
• The control file is not equivalent to the one created by ApexSQL Diff
• The script compatibility level for SQL Server 2008 and SQL Server 2008 R2 have inappropriate values specified
• Executed SQL script for the stored procedure will not be shown in the "Differences" section
• “Database changes detected. Refresh the Action center tab" message appears after closing the "Project history" form
• “The user does not have sufficient rights to link this database” warning appears when a database contains dot in its name
• “An error occurred while updating the database object” error is encountered when pulling the custom script from the "Project history" form
• “Parsing errors: Parse error: [Incorrect syntax near '('] at [position: 1500, line: 26, column: 64]” error is encountered when applying stored procedure against a database
• “Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression” error is encountered when editing an object in the Shared model
• The add-in does not recognize the file protocol used for the repository path and it keeps asking for credentials
• "System.OutOfMemoryException" error is encountered when a system table contains excessive data for the Dedicated model
• “Source control error: Failed to get project ID, check log for more details” error is encountered when deleting a project through the source control wizard
• The “Data types” drop-down list is available in the "Object filtering" tab, even if there is no linked database
• Initiating the Migration script twice for the same change does not open the same tab
• The "New label" form closes after the warning message, in case the label is not properly specified

Changes:

• The Import connections feature is moved from the General tab to the new Connections tab

Known issues:

• New project under the Mercurial repository, cannot be created from the Source control wizard on Mercurial version 3.9.1 and above

Enhancements:

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

Fixes:

• SQL Server Management Studio stopped working when disconnecting Analysis services
• Excessive message appears requiring a comment when applying a change against a database
• "Database Settings from SC wasn't loaded" error appears when the "Script dependencies" option is checked
• "Value cannot be null" error is encountered when applying an object that does not exist in a database
• "Error while trying to retrieve scripts for ApexSQL Source Control framework objects! : String cannot have zero length." error when linking a database
• SQL Server Management Studio hang when installing the 2016 R2 release of the add-in
• "Could not load file or assembly 'Newtonsoft.Json'" error is encountered upon the initial commit using Git dedicated model
• Changes made against DML triggers are not shown in the "Action center" tab
• Database objects are missing from the add-in framework table
• The "Active branch" drop down list is not refreshed along with the "Action center" tab
• The add-in prevents editing an object while the Restrictive policy is set, even if the object is locked
• Parsing errors encountered when applying changes against a database using SQL Server Management Studio 2016
• TFS workspace will be removed after linking the second database to a new subproject in case another database is linked to a subproject of the same parent folder in TFS
• DatabaseSettings.xml file contains inappropriate information for the SQL database compatibility level
• "This Sql Transaction has completed; it is no longer usable." error appears when linking a database hosed by SQL Server that has the limited bandwidth
• The add-in fails to create framework objects when linking a database to a SQL Server with limited bandwidth
• The filter row in the "Object filtering" tab is not working properly
• "There are no committed changesets. Project history will be available after the first commit" message appears after the first commit on a local Perforce depot
• Timestamp for the committed changesets is at correct when working with Subversion repository
• Custom scripts path reported as not found when it is stored in a nested folder inside the custom scripts root folder
• SQL script of the object is not refreshed in the "Object history" form after the change is applied
• Changes cannot be applied from the history when working with Mercurial source control system
• "Length cannot be less than zero. Parameter name: length" error is encountered when clicking the filter row in the "Project history" form
• "Could not find the xml file" error is encountered when applying static data from the "Action center" tab
• SQL Server Management Studio freeze when committing static data after the initial commit

Known issues:

• TFS projects cannot be created on the root repository if TFS 2015 is used

Enhancements:

• Migration scripts
• Basic Git branching support

Fixes:

• Objects will remain highlighted in the "Action center" tab, on attempt to commit without specifying comment
• "Connection failed: Repository is not empty" error is encountered when browsing folders on the SVN repository
• Inappropriate dialog appears when a database linked to the Git repository is offline and changes are committed
• The "Test" button is missing when getting back from the "System login" step to the "System selection" step, in case the "CLI" or the "Working folder" options are initially selected
• The add-in cannot work with an empty file stored in the custom scripts folder
• The "Action center" tab allows static data for only one table to be linked in case the data exists on the repository, but it is not linked in a database
• Filtering objects from Object Explorer causes SQL Server Management Studio to be unresponsive
• Inconsistency with the "Project history" and the "Object history" form when there are no commits made by the user
• The add-in shows the test failed message even when the user selected the correct folder path in the TFS repository, when linking a database
• Database will go offline upon double-clicking the "Action center" command in the SQL Server Management Studio toolbar
• Missing informative message in the "Action center" tab that database changes are detected after unlinking the static data
• Missing informative message in the "Action center" tab that database changes are detected when adding or removing a custom scripts folder from the add-in options
• "Database changes detected" message appears in the "Action center" tab even if there are no changes
• "Database changes detected" message appears when refreshing the "Action center" tab after editing an object
• "Database changes detected" message stays active in the "Action center" tab, after the changes are applied within the Object Explorer right click menu
• Excessive message when test for the repository connection fails
• Custom scripts cannot be filtered from the "Repository only" tab, in the add-in options
• An empty workspace on TFS will be created upon clicking the "Test" button in the source control wizard
• "Could not load part of the path" error is encountered when linking a database to localhost
• Connection timeout is missing when trying to connect to Git repository using SSH protocol
• The "Action center" tab stuck at step 1, after connecting to a Git repository hosted by CentOS using the SSH protocol
• Creating labels causing the inappropriate structure in the AppData folder and performance impact when using SVN
• Changing indexes will be presented in the "Object status" form showing incorrect icon
• "Cannot use TEXTIMAGE_ON when a table has no text, ntext, image, varchar(max), nvarchar(max), non-FILESTREAM varbinary(max), xml or large CLR type columns" error is encountered when applying changes
• Objects are checked out as a different user and the current user cannot access them in case of using specific connection configuration
• Changes from the repository cannot be applied in case the commit was from one version of SQL Server, and the apply process is performed against a database on another version of SQL Server
• "SELECT failed because the following SET options have incorrect settings" error is encountered when trying to delete modified object in SQL Server Management Studio 2008 R2
• SQL Server Management Studio becomes unresponsive when trying to delete empty custom script file
• When unlinking one database from TFS repository, another one, linked to the same repository/project will be unlinked automatically
• "Could not find a part of the path" error is encountered when linking one database to a repository where another database is already linked
• "Object reference not set to an instance of an object" error is encountered when refreshing the AC after creating a label in SVN
• "Source control error: The string must have at least one character. Parameter name: localitem" error is encountered when trying to delete a custom script from the repository
• Changes for SQL table are not properly applied in specific case
• "Object reference not set to an instance of an object" error is encountered when applying static data changes
• "Could not load file or assembly "p4api.net" error is encountered when connecting to Perforce repository
• The add-in shows false differences when committing changes from databases of different compatibility level hosted on different SQL Server versions
• SQL Server Management Studio becomes unresponsive when trying to apply a label
• Differences will disappear when using the "CTRL + A" keyboard shortcut to select entire script in the differences section of the "Action center" tab
• A check-out remains as an object state if an object is edited, after it's checked out, edited, and checked-in
• Missing warning message when applying static data changes only, in case an object change is in the list of changes
• Static data remains in the "Action center" tab, even if the related table is dropped
• An object change remains in the "Action center" tab after it is committed from within the Object Explorer without any messages about committed changes
• "Source control error: Commit failed Changes will not be applied" error when committing changes to a depot on Perforce
• Applying changes is stuck at the "Completed" step when applying static data change from the repository
• "Out of memory exception" error is encountered when making a change that affects all rows when showing the static data differences, in case a table contains a large amount of data
• SQL Server Management Studio stops working when the large script with the static data is shown in the "Action center" tab along with a DDL change
• The add-in cannot compare static data changes from within the "Project history" form
• "Out of memory" error is encountered when comparing between changesets with static data
• Cannot apply static data changes from the "Project history" form
• The "Action center" tab shows differences for SQL custom scripts even if there are no differences

Known issues:

• TFS projects cannot be created on the root repository if TFS 2015 is used

Enhancements:

• Team Foundation Server 2015 support
• SQL Server 2016 CTP3 support
• SQL Server Management Studio CTP3 integration
• Azure SQL Database V12 support
• CLI support for major source control systems
• Support for source control of custom scripts

Fixes:

• Geometry object type will not be written as it should in XML which result data loss
• The upgrade to a newer version is available even after the trial is expired
• Object list in the "Action center" tab cannot be filtered in a way to show only objects edited by the current user
• Wrong default action will be set if linking an empty database to the non-empty repository, when using the shared model
• The filter in the "Action center" tab blocks the entire tab, if another database with applied filter is unlinked
• There is no indication about the end of the process in the Applying changes to database process
• The add-in overwrites the data about the first linked database after the second one is linked, in case of linking two databases with the same name from two SQL Server named instances with the same name
• Changes made by other users can be applied even when an object is locked in case of applying changes from the repository to the database
• Object icon in the "Object Explorer" pane is set as edited after applying a label or the "Get" operation from history
• Missing progress bar after the "Finish" button in the wizard is clicked, and before the "Action center" tab appears
• The database drop-down list for the shared model, in the "Source control" wizard cannot be initiated in a single attempt
• The add-in can be installed even if there are no any SQL Server Management Studio instances presented
• The "Delete" button in the "Choose project" form of the "Source control" wizard closes the form and fails to delete selected project
• Copy functionality does not work in the "Script execution results" form
• Excessive command in the right click menu of the "Script execution results" form
• "Current thread must be set to single thread apartment (STA) mode before OLE calls can be made." error is encountered when copy-pasting the current error in the "Script execution results" form
• "Unexpected error" message is shown when changes cannot be applied from the repository to a database
• Databases are not alphabetically sorted in the drop-down list for the shared model, in the "Source control" wizard
• Inappropriate informative message when trying to create a sub-folder in the root of the TFS repository, when linking the database to source control
• Inconsistency between the message in the "Action center" tab and the "Working offline" option
• The size of the "Differences" section decreases when clicking the "Next/Previous 10,000 lines" command
• Missing option to filter type and action in the "Project history" form
• Inconsistent behavior in the "Action center" tab related to number of checked and selected objects
• "An exception occurred while executing a Transact-SQL statement or batch" error is encountered when the user does not have sufficient permissions to link a database
• "Some ApexSQL Source Control framework objects were not created successfully" error is encountered when the user does not have the "db_owner" database role membership
• Missing informative message in the "Action center" tab that it needs to be refreshed, when linking the static data
• If an object has the same name in different databases on the same SQL server, the add-in will update status of the object incorrectly
• Status bar shows incomplete information for the Mercurial repository, when the project is nested
• Inconsistent messages when linking the static data from the "Object Explorer" pane and the "Static data" form, if a table does not have a primary key
• Table icon will be shown in the "Object history" form for the "Static data" commit
• Initial commit is not allowed from the Object Explorer pane
• Missing option to manipulate with multiple items in the "Static data" form
• Objects will remain highlighted in the "Action center" tab, on attempt to commit without specifying comment
• The database will go offline if the sub-folder is used for SVN and the label is created
• SQL Server Management Studio becomes unresponsive if objects are filtered in the add-in options
• The add-in fails to integrate in SQL Server Management Studio if SQL Server is 32bit, and the operating system is 64bit
• "Connection failed: Repository is not empty" error is encountered when browsing the folders on the SVN repository
• "Failed to update framework" error appears on each click in the "Object Explorer" pane
• The changes will be committed even if the user cancel the commit process
• "Source control error: Applying changes to working copy failed" error when cancelling the commit process twice in a row
• Missing option to save the password when prompted for repository credentials
• "Database changes detected" message appears when refreshing the "Action center" tab after editing an object
• There is no message in the "Action center" tab about changes detected, if the new object is created, nor the icon in the Object Explorer will be updated
• Changes can be committed if the node in the "Object Explorer" pane is changed without checking the object in the "Object selection" section of the "Action center" tab
• Differences will disappear if the CTRL +A is used while the cursor is in the "Comment" field of the "Action center" tab
• "There is nothing to sync" message appears when applying changes from the repository against the database for the SQL Fulltext stoplists
• Missing informative message that there are changes detected in the database when the static data is linked/unlinked
• The zip file for the static data will not be committed when committing the static data
• Initiating the "Project history" form will switch the focus to another application
• The project on TFS repository cannot be created within the add-in wizard
• Excessive space in the "T-SQL script" preview section of the "Change log" form when adding a column
• The "Changes log" form will not show all changes properly
• The add-in menu is missing from the Object Explorer right click menu, if the language environment is not default
• "Cannot check in pending changes "The array must contain at least one element" error is encountered when unlinking and linking back again a database to TFS using shared model
• The "Working folder" functionality does not work
• "Object reference not set to an instance of an object." error is encountered when initiating the "Action center" keyboard shortcut
• "Runtime error (at 89-1940): Internal error: Cannot access 64-bit registry keys on this version of Windows." error is encountered when installing the add-in on 32-bit operating system
• The "Source control" wizard will not be closed and the linking process cannot be continued after clicking the "Finish" button if the Subversion source control system is selected
• Database will switch to offline mode automatically after connecting to the Git repository if the project is created inside the repository
• When the "Action center" tab is initiated upon linking a database, it will show the "Working offline" button, if another database already linked is in the offline mode
• The "Apply changes to database" form appears when committing objects and cancelling the process
• T-SQL script cannot be copied from the "Apply changes" preview section

Known issues:

• TFS projects cannot be created on the root repository if TFS 2015 is used

Enhancements:

• An option to import connections from external options file is added

Fixes:

• "Failed to update framework" error is encountered on each click in the Object Explorer pane
• The add-in fails to integrate in the host application if SQL Server is 32bit, and the operating system is 64bit
• The add-in menu is missing from the Object Explorer right click menu, if the language environment is not default
• "Cannot check in pending changes "The aray must contain at least one element" error is encountered when unlinking and linking back again a database to TFS using shared model
• The "Source control" wizard will not close when clicking the "Finish" button if the "Working folder" is selected from the source control systems drop down list
• Database will to offline mode automatically after connecting to the Git repository if the project folder is created
• The "Source control" wizard will not be closed and the linking process cannot be continued after clicking the "Finish" button if the Subversion source control system is selected
• "Runtime error (at 89-1940): Internal error: Cannot access 64-bit registry keys on this version of Windows." error when installing the add-in on 32-bit operating system

Enhancements:

• The "Working folder" option is added for both dedicated and shared development model
• An option to Check-in/Commit changes through the Object Explorer is added
• An option to Link/Unlink object from the Object Explorer is added
• An option to filter objects that exists only on the repository is added
• An option to add a directory to repository root for Git and Mercurial is added
• An option to delete static data from the repository is added
• An option to see if someone else linked static data and link it from the "Action center" tab is added

Fixes:

• The add-in fails to recognize proper version of SQL Server Management Studio if Cumulative update 7 is installed
• The "Database change log" feature shows all changes, in case framework objects for multiple databases are in the same database, when using shared model
• SQL Server Management Studio becomes unresponsive and closes when connecting to a local SVN repository if it is not available
• The "Action center" tab is broken form inside SQL Server Management Studio
• Deleting objects in shared model doesn't work for Perforce and Mercurial
• The "Action center" tab shows wrong message when linking static data
• The add-in doesn't inform the user that a database is already linked using different development model
• The progress bar is working indefinitely when linking a database to a local SVN repository
• The add-in throws an exception instead of a user friendly message when connecting to SVN set for https with http
• "Conversion failed when converting the nvarchar value to data type int" error is encountered when trying to create a table in SQL Server Management Studio 2008
• Shared model will not work properly if two users link different databases, but choose the same database for storing the framework objects
• Framework objects are not removed on unlinking, in case two users link databases from the same server, when using shared model
• User value won't be removed from the corresponding framework table, when the user unlink the database
• Object will be initially linked if applying any filter from the filter row in the "Action center" tab
• Clicking the "Check all" box in the "Action Center" tab for the first time, fails to check all objects
• Incorrect preview of the database where framework objects are hosted when linking the database already linked by someone else
• The installation wizard offers SQL Server Management Studio integration even if that version is uninstalled
• Inability to view any other version of the specific object from a single changeset in the "Project history" form
• Inability to compare one version of the specific object from a single changeset with any other version in the "Project history" form
• Missing progress bar on changeset selection, or object the changeset selection in the "Project history" form
• Missing filter row in the "Project history" form
• Missing "Previous/Next 10,000 lines" option in the "View all history" form
• Changing the structure of the table with already mapped static data may cause the data loss

Fixes:

• "Source control error: No changes added to commit" error is encountered when simultaneously committing changes to the repository from different databases
• The add-in causes SQL Server Management Studio to stop working when linking the database already linked by other user
• The add-in does not integrate in SQL Server Management Studio if non-administrative Windows account is used

Known issues:

• There is no history for renamed objects in "View history" feature for databases linked to Git or Mercurial repositories

Enhancements:

• The add-in now successfully ensures only users who made changes can commit them
• The Apply label is now 300% faster when using TFS source control system
• Linking static data from the “Manage static data” form is now 3,400% faster
• Linking static data from Object Explorer for a single table is now up to 500% faster, depending on the amount of data
• Opening/refreshing of the “Action center” tab is now 1,400% faster

Fixes:

• There is no way to continue the script execution process if there is an error while loading objects from script for applying to database
• The "Action center" tab does not work properly in SQL Server Management Studio 2008
• Source control system switches to the "Working offline" mode, without asking for credentials
• The user can commit changes to source control made by other user
• "Some framework objects could not be created" error is encountered when a single project is used for different development model
• "Ssms20xxRegistrator.exe" cannot be executed successfully during the installation, causing the add-in fails to integrated within SQL Server Management Studio
• Missing drop down list for the "Action" state in the "Action center" filter row
• Missing icon for the state of the "Action" column in the "Project history" dialog
• Redundant comment column in the "Project history" form
• The "Source control" wizard allows creating the new project in the "Chose project" dialog but project will not be created and thus cannot be selected
• "Source control error: AddFolder failed with message 'Message:MCKCOL request on "path"' failed: 405 Method not allowed" error is encountered when trying to create a new project
• "Could not get the list of items for the folder on the server. Check credentials on the repository path" error is encountered when trying to browse projects in the "Source control" wizard
• After committing the database to source control, wizard will change the repository incorrectly to the last commit folder
• The add in marks the database as linked to source control even when an error prevents the actual commit of any object to source control
• The add-in allows creating label even on an empty repository
• The add-in causes SQL Server Management Studio to become not responsive when canceling the "Apply" operation from the repository to database
• Multiple users have an option to choose the database where the framework objects will be installed
• The add in installs default config files and SSMS2012registrator.exe in wrong administrator account instead of the current user account causing the add-in is not registered with SQL Server Management Studio
• Creating label when using TFS source control system gives an exception
• Static data table names in the "Action center" tab is not correctly specified, when the static data differs from the static data stored in the repository, depending on the name convention used
• Static data changes will not be applied if there are more data rows in the database table than in the table stored in source control
• Schemas won't be shown in the add-in options, when switching from one database to another, and getting back to the initially selected database
• Databases cannot be unlinked from source control when trial period expires
• Single column data will be deleted when applying changes from the source control, if there are more data rows in the database table than in the table stored in source control, and at least one row is different
• Excessive slash in the repository name shown in the SQL Server Management Studio status bar, when the project is nested in the repository
• The add-in shows incomplete information in the SQL Server Management Studio status bar
• "Unexpected error: Operation was canceled by user" error is encountered when pressing the "Cancel" button or the "Close" button in the "Get label" dialog
• The "Comment" section overlaps the object list if there are not enough space
• The add-in cannot recognize the presence of source control system for already linked database and will ask for a password
• The add-in thread cannot be removed from SQL Server Profiler
• "Object reference not set to an instance of an object." error is encountered when switching the "Action center" tab from offline to online mode
• Clicking the "Send logs" button blocks SQL Server Management Studio, and makes it unresponsive until the email is sent
• Changing the source control system from the drop down list in the "Source control" wizard switches the development model to dedicated, when shared model is selected
• When clicking the "Script with dependencies" check box, the operation cannot be canceled
• Excluding objects from monitoring fails to apply to the object explorer icons after the specified time period in the add-in options
• Icon for SQL function is not visible, when object is checked out using the Shared model or edited using the Dedicated model
• When using Perforce source control system, wrong information is shown in the SQL Server Management Studio status bar
• The "Post_Save notification" message box is not informative enough, when changing an object in shared development model, with the "Check out before edit" policy enabled
• The "Action center" tab shows the object after resolving conflict, even if there are no differences between local database and the repository
• Informative message in the "Administrator " tab cannot be set to be shown when it is disabled
• The "Previous" button is excessive in first step of the source control wizard
• "Out Of Memory exception" error is encountered in MergeDiff window when showing large scripts ( > 20mb)

Known issues:

• There is no history for renamed objects in "View history" feature for databases linked to Git or Mercurial repositories

Enhancements:

• The add-in now supports source controlling of static data
• Export / import object change tracking settings is added
• The "Apply" operation is up to 300% faster on committing objects to a repository when working with Team Foundation Server

Fixes:

• Changing database during the object comparing/loading in the "Action center" tab results in false object state
• "Object reference not set to an instance of an object" error is encountered, when expanding the database node in Object Explorer
• The "Action Center" toolbar button is active even when the highlighted database is not linked to source control
• The "Action center" tab shows SQL Application role object as different because only Roles are supported
• Undoing changes before the first commit drops the object
• Missing an informative message that the database is already linked using one of the development models, when trying to link a database from other machine
• "Object reference not set to an instance of an object" error is encountered on initial commit, when filtering schemas in the source control wizard
• The framework object "ApexSQL_SC_DatabaseLog" will be deleted from the wrong server when unlinking the database
• "Strong-name assemblies must specify a public key in their InternalsVisibleTo declarations." error is encountered when connection to Git source control repository using the SSH connection
• The add-in fails to link a database to source control if the database with the same name is already linked from the same machine
• The add-in fails to recognize specific database schema
• The "Save" button in the add-in options is redundant
• The "Logging info" table contains excessive words in column names, and the column order is not properly set
• When executing the "Get" command of the schema changes without static data from the source control to a database, the progress dialog stays opened indefinitely and the "Get" task will not be accomplished
• The add-in cannot work in environment where SQL Server Management Studio 2008 R2 Enterprise is installed
• The add-in causes SQL Server Management Studio to not responding state, when trying to connect to any source control system without specifying any connection parameters
• Missing warning message that database policies are changed before closing the add-in options
• The add-in fails to run properly if the version of SQL Server and SQL Server Management Studio are not the same
• Missing informative message in the "Action center" tab when there is no differences between local and source control repository
• Missing progress bars and icons in the "View all history" form
• The "Administrator" tab remains enabled even if there are no databases linked using the Shared database development model
• The installer does not recognize SQL Server Management Studio version properly
• The "Action center" toolbar cannot be disabled in SQL Server Management Studio toolbar
• Inappropriate "?" icon for credential object type
• The project created in the add-in wizard cannot be found on Visual Studio online repository
• Add-in table from tempdb will be deleted after SQL Server is restarted from SQL Server Management Studio
• The add-in is not selecting all objects on first database linking
• Missing informative message that the "Action center" tab needs to be refreshed after making changes in the database
• Clicking the "Get" button in the "View version" section closes the window and makes SQL Server Management Studio unresponsive, until the "Sync" is shown

Known issues:

• The “Source control” wizard closes if the repository path is wrong, when trying to connect to Subversion source control system
• There is no history for renamed objects in "View history" feature for databases linked to Git or Mercurial repositories

Fixes:

• The system objects are not created properly in the user database, after linking it to source control
• The "CREATE TABLE permission denied in database 'tempdb'. Changed database context to 'tempdb'." error is encountered when add-in wrongly attempts creation of the table in the temp database when using the shared model
• The add-in creates wrong trigger when version of the SQL Server Management Studio version is different from the SQL Server version that hosts the database
• The "Object reference not set to an instance of an object" error is encountered during initial committing of SQL objects to the TFS repository which already contain scripts

Known issues:

• The add-in is not working with old shared model after the update process
• The “Source control” wizard closes if the repository path is wrong, when trying to connect to Subversion source control system
• There is no history for renamed objects in "View history" feature for databases linked to Git or Mercurial repositories

Fixes:

• The "Action center" tab cannot complete the "Comparing objects" process on extremely large databases
• The "Source control" wizard closes on the "Configure monitoring" step when linking large database to source control
• The add-in causes SQL Server Management Studio to stop working when linked database contains the "-" character in title
• Missing informative message that system objects are not created successfully after the database linking process
• "Committing while offline is possible only for distributed SC systems like Git or Mercurial" message appears when trying to commit anything to an empty repository using Perforce
• SQL Server Management Studio hangs each 60 seconds when extremely large database is linked to source control
• If SQL schema is excluded from types, in the add-in options, the script for dropping object will be generated during commit from source control for all schema scoped objects
• "Could not load file or assembly p4api.net.dll" error is encountered when trying to connect to Perforce source control system
• "Unexpected error: There was nothing to sync between Source Control and Database" error is encountered when trying to get an object from source control
• Selecting object in the "Action center" tab is taking too long, for a large database
• Excluding objects from monitoring in the add-in options will be wrongly presented in the "Action center" tab
• The DNS address "tfs.xxxxx.net" cannot be resolved when Team Foundation Server is in a different domain and "Error 404" message will be displayed

Known issues:

• The add-in is not working with old shared model after the update process
• The “Source control” wizard closes if the repository path is wrong, when trying to connect to Subversion source control system
• There is no history for renamed objects in "View history" feature for databases linked to Git or Mercurial repositories

Enhancements:

• Rewritten shared database development model:
  • Support for Git and Mercurial source control systems
  • Communication with source control repository using the Action center tab
  • Edit objects from SQL Server Management Studio
  • Work offline feature is implemented in Action center tab
• An option to prevent objects from being edited if locked\checked out is added
• An option for development policies is added
• The add-in now supports Perforce source control system
• The "View all history" feature is added for a source control project
• The "Multiselect" feature is added in the Action center tab
• An option to exclude objects from monitoring by type, schema and name is added
• An option for logging changes made to the database schema is added

Fixes:

• The "Apply all from source control" feature will generate an incorrect script for some objects and the subsequent operation will fail
• Label 'tip' is present in "Show labels" feature even if it is not made for databases linked to Mercurial repositories
• "Illegal characters in path" error is thrown when comparing objects
• The Source control wizard will close if a source control system is changed after initial login
• The "Go offline" feature is missing in the Object Explorer for the new shared model
• The add-in causes SQL Server Management Studio to stop working after clicking the "Cancel" button when the "Warn about pending changes on exit" option is enabled
• Missing info message that policy cannot be/is successfully changed
• SQL Server Management Studio stopped working if incorrect Perforce credentials were used during the database linking process
• "Timeout Expired" error is thrown when linking large database to Subversion during object linking process
• The "Action center" tab will not display dependent table after data-type changes are made
• The add-in fails to ignore the default objects created when using TFS Online
• "Object reference not set to an instance of an object" error is thrown when applying message type to source control
• The add-in does not revert changes to a local working folder when commit fails with an exception
• The default location for add-in files is changed after a specific Windows update
• The Perforce workspace is not removed when linking database to a previously created workspace after un-linking the database
• Creating Label on Dedicated database is up to 5 times slower than on Shared database
• The "Compare versions" option does not work in the "View history" window
• The "Copy to clipboard" option does not work in the "Apply changes to database" window
• The “There is no info about the previous state of the object” message will appear when the Undo operation is performed in the Action center tab
• Object state icons for shared model are not changed correctly
• Missing informative message that a policy cannot be/is successfully changed
• After the object is checked out, edited and checked in again, the "Action center" tab will open with the selected object, but it is not in focus and the selected object's label says ": 0"
• Clicking on "0" revision on the "View all history" for Subversion throws an error for shared model
• The "Action center" tab will stay open after disconnected from server
• Activation is required after upgrade from previous version
• The add-in can be installed even when there is no host application installed
• "Path not found" error is encountered when connecting two databases to the same Team Foundation Server project
• Performance issue when refreshing the Action center tab while connected to a Team Foundation Server repository

Known issues:

• The add-in is not working with old shared model after the update process
• There is no history for renamed objects in "View history" feature for databases linked to Git or Mercurial repositories
• The DNS address "tfs.xxxxx.net" cannot be resolved when Team Foundation Server is in a different domain and "Error 404" message will be displayed

Changes:

• Support for SourceGear Vault source control system has been deprecated

Enhancements:

• Conflict resolution using integrated merge tool
• Added option to script changes with\without dependencies when applying them to the database
• The "Filter" feature is added for database objects in Action Center tab for dedicated database model
• Added option for obligatory comments with enlarged comment field in Action Center tab for dedicated database model
• The "Apply all to source control" operation is up to 200% faster when working with Git
• The "Refresh" operation is up to 700% faster when working with Subversion

Fixes:

• The "MergeDiff" feature will block Action Center tab from opening for the first time add-in installations
• The "Source control wizard" will enable shared development model for Git before database is linked for the first time
• User will be asked for evaluation on every SQL Server Management Studio restart
• The "Source control wizard" will close when SourceGear Vault is selected
• The "Remove link from source control" is not working in SQL Server Management Studio 2005
• The "Get" from source control operation cannot be performed on database witch names start with numbers
• The "Work Offline" message will not be displayed when Action Center tab is detached
• The "MergeDiff" feature will show false script differences when Action Center tab is open and the database is set offline
• The "Restore previous version" operation will fail sometimes
• The "Test" feature in the "Source control wizard" is not checking credentials for Subversion
• Changed database objects are still marked in the Object Explorer after "Get" of previous database label is performed
• The "Check out" operation is not possible every time on shared database linked to Subversion
• Committing over 2000 objects on CloudForge, GitHub or Bonobo servers the "Prepare object for commit" process will get slower over time
• Object changes will not be reverted when "Cancel" is pressed during the "Prepare objects for commit..." step
• Changes in "View history" will be shown only if Object Explorer is refreshed after commit to Git
• The "Compare version" feature will not display last changes in the "Database version" tab
• The "Object source control status check-up interval" option in Options dialogue doesn't have defined time measurement unit
• The "Setup has detected that SQL Server management Studio is running" warning message is displayed even if SQL Server Management Studio is closed
• The progress bar will stay open over "The file xyz already exist. Overwrite it?" dialog after adding a table to source control
• The "Check out" dialog is missing icon for some database objects
• The "Get specific version" feature in the "View history" will throw error during script execution over shared database linked to Team Foundation Server
• The "Update object to the specific / latest version in SC" feature will throw an error over shared database linked to Team Foundation Server
• The "Error 404" message is displayed when the GIT repository is used for Mercurial and vise verse
• The "Remove link from source control" is not working every time on shared databases
• The "Commit failed" dialog is missing additional info why this actually happened
• The "Action Center" buttons from SQL Server Management Studio toolbar will state that the database is shared
• The "Log in" dialog will appear if Action center tab is in offline mode
• The "Source control wizard" cannot finish database linking process if the wrong Subversion login info is used
• The Object Explorer will not mark object states under source control in real time
• The add-in delete tables from a local database when it is applied to source control without related schema
• XML schema collection, Contract and Message type are carrying same objectID and the Object Explorer will mark all changed objects as check in after only one object is

Known issues:

• There is no history for renamed objects in "View history" feature for databases linked to Git or Mercurial repositories
• Label 'tip' is present in "Show labels" feature even if it's not made for databases linked to Mercurial repositories
• The add-in is not backward compatible with 2014 version or lower

Enhancements:

• The add-in now fully supports dedicated database development model
• The add-in now supports Git, Mercurial and Visual Studio Online
• The add-in now supports HTTP, HTTPS and SSH connections
• The add-in is now completely integrated into SQL Server Management Studio
• The add-in is now supports SVN and SVN+SSH connection protocols
• Real – time monitoring of changes made to database objects
• Comparison algorithm that monitors nature of the changes made between database and source control and offers default actions based on them
• Generating dependency aware, atomic scripts for synchronizing database with source control
• View differences between individual object scripts feature is implemented
• Conflict resolution using third party tools: KDiff3, BeyondCompare and ExamDiff Pro feature is implemented
• Undo changes made to the database feature is implemented in Action center tab for dedicated database model
• Get by version feature is implemented in Object Explorer pane for dedicated database model
• Create label feature is implemented in Object Explorer pane for dedicated database model
• Get by label feature is implemented in Object Explorer pane for dedicated database model
• Work offline feature is implemented in Action center tab for dedicated database model
• Improved Source Control wizard for more intuitive database linking to source controls
• Customized menu based on chosen database model

Fixes:

• Differences window in "Action center" tab will freeze after "Get from history" feature is performed and SQL Server Management Studio needs to be restarted
• The "No pending changes" message will be displayed when attempt to make a new folder in project root is performed on Team Foundation Server
• The "Source Control Wizard" will make database folder in DedicatedData when "Test' button is pressed or connection to source control has failed
• The GitHub will state offline mode in "Action center" tab and commit will fail every time
• The add-in will not integrate in SQL Server Management Studio 2008
• Object differences will not be shown in "Action Center" tab if some operations are performed on other shared database
• Bad data changes in "Action Center" tab are shown in case two or more databases are linked to Mercurial repositories
• The "Cannot get folder" message is displayed when "Get label" feature is performed on a database linked to the project root
• Reports are not working and the "An error occurred during local report processing" message is displayed
• The "Check in" feature is not working on Subversion shared database
• The "Invalid Object name tempdb. Dbo. DatabaseLog" message will be displayed when changes are made on the table
• Tool tips will disappear after sorting in "View history" feature tab
• Individual objects will not be added under Subversion shared database
• The "Remove link from source control" feature will not delete DatabaseTriggerLog trigger
• Commit changes in data type will not empty tempdb. dbo. DatabaseLog
• SQL Server Management Studio stopped working if Subversion login information is provided for user without password on the dedicated database
• Commit to the remote Git repository set up in a local file system is not possible
• Bad data changes in "Action center" tab in case two or more databases are linked to Git repositories
• Connect to a local Git repository using "file:\\" prefix is not possible
• The "Remove link from source control" feature will not delete files from temp folder
• SQL Server Management Studio will freeze after some time without usage when "Action center" tab is open
• The "Undo check out" feature will not revert state before "Check out" and latest change over the object
• The "Get latest" feature is not working under Team Foundation Server shared database
• Actions cannot be performed over databases linked to the root folder as Subversion dedicated database
• The "Get from history" feature is not working correctly under Subversion dedicated database
• The "Get label" feature is not working correctly under Subversion dedicated database
• The "No pending changes" message will be displayed when attempting to make a new folder in root project is performed on Team Foundation Server shared database
• Detaching "Action center" tab will display incorrect "Work offline" feature info
• Label will be created without any information or progress bar
• The "Apply label" function is offering to delete tables added in the meantime for Git and Mercurial
• After "Apply all from source control" feature is performed under Git with only one change, tooltips on an "Action center" tab will disappear
• Apply label under Git and Mercurial will throw "cross thread" exception if there are no differences relative to the database
• The add-in dialogs will be opened out of SQL Server Management Studio focus
• When "Remove link to source control' feature is performed "Action center" tab will stay open and error will be shown
• The "Undo" feature over a large number of selected objects will stuck on "Creating script..." step and "Cancel" cannot be performed
• Click on "?" button will close windows and help will not be initialized
• The localcache.xml file isn’t updating and object changes are lost
• The "Initializing" progress bar is always across dialogs
• The "Get by label" feature will not be fully completed
• The "Object reference not set to an instance of an object" error is thrown when "Cancel" is pressed during the refresh process on large database linked to Subversion

Known issues:

• There is no history for renamed objects in "View history" feature for databases linked to Git or Mercurial repositories
• Label 'tip' is present in "Show labels" feature even if it's not made for databases linked to Mercurial repositories
• The add-in is not backward compatible with 2014 version or lower

Changes:

• Support for Visual Source Safe source control system has been deprecated

Changes:

• The add-in name is changed from ApexSQL Version to ApexSQL Source Control

Enhancements:

• The add-in now fully supports SQL Server 2014
• The add-in now supports Apache Subversion up to version 1.8.9
• The add-in now supports Team Foundation Server 2013
• Linking objects to Apache Subversion is up to 300% faster

Fixes:

• The add-in cannot link all selected objects to source control while leaving a database in a non-linked state
• The "Check out" feature works very slow and brings SQL Server Management Studio occasionally in a non-responding state while the "Progress info" dialog disappears from the screen occasionally
• The "System.OutOfMemoryException" error is encountered in SQL Server Management Studio when linking objects of a large database to source control
• The "Update object" option doesn't work
• The "Check out" status icon in the "Object Explorer" pane is hardly visible, making hard for the user to quickly determine status of the object
• SQL Server Management Studio hangs when multiple medium to large databases are connected to source control
• The SQL foreign keys are lost when a table connected to source control is edited
• Objects connected to source control are marked as "Not in database"
• The "Apply to database after editing" option will have no effect as the add-in will always use the value "Prompt" when editing
• The add-in will wrongly check in an object when the user clicks the "Cancel" button instead of the "Check in" button in the "Check in <object>" dialog and an object will stay in the checked out state
• The add-in will check in an object to source control before editing even when the user explicitly cancels it, when the "Check in to source control before editing" option is set to always
• The "Assertion failed at ApexSQL.Common.SourceControl.UI.Forms.Select.Project.From.btwNewProject_Click" error is encountered when attempting to create a new Apache Subversion project via the "Source control" wizard
• The Red Gate Source Control add-in overrides the add-in's database overlay icon in the Object Explorer pane
• The "Access to "/" forbidden" error is encountered when trying to connect to the CloudForge Apache Subversion server
• Same object cannot be removed and then added back to source control
• The "Evaluation" dialog pops up when the add-in is started, or the "Link database to source control" option is chosen
• The "The process cannot access the file <path>\Options.xml because it is being used by another process." error is encountered when multiple SQL Server Management Studio instances are opened
• SQL Server Management Studio hangs and the "Refreshing" window will stay open after large database is linked on source control

Changes:

• New user interface that follows Metro UI style

Known issues:

• The "System.OutOfMemoryException" error is encountered in SQL Server Management Studio when linking a database to source control with all objects linked for large databases

Enhancements:

• Add-in now supports TFS 2012
• Add-in now supports Vault 6.1

Fixes:

• "Database vs Source Control" and "Database linking status" reports are generated blank
• Source control reports should be created in the "Multiple Document Interface" window in SSMS
• The 'Description' form is not consistent with the 'Extended property edit' form
• In the 'General' tab of the visual object editor, the scale can be set to a higher value than the precision value for numeric and decimal data types
• User data types in sequences do not contain a schema in the 'Data type' droplist
• "Database vs source control difference" instead of "Database linking status report" is shown when using the "Linking status report" option
• The 'Exception: Getting db script for diff report: Index of object [dbo].[t1] is changed' error is encountered when an object under Source Control is recreated
• The SSMS 'Table Edit' window loses its focus and cannot be recalled back even when clicking on the SSMS window
• The missing option to remove multiple objects from Source Control in 'Edit Source Control Setup'
• The Search property list title is misspelled as 'Searchpropertylist' in the confirmation dialog for the 'Remove from Source Control' option
• The add-in is catching and logging errors from non ApexSQL add-ins installed in SSMS
• On 'Edit' or 'Check out' of any Full text stoplist, the Save button becomes enabled as soon as the visual editor dialog is opened even if no changes are made
• There's no progress bar or any progress indication when calling time demanding context menu operations
• The non ApexSQL application appears in the ApexSQL Version's main menu if both add-ins are installed in SSMS
• The not supported 'Label' feature is shown in the ApexSQL Version's context menu for database objects linked to Source Control via Subversion native drivers
• Property values for 'Search property list and Sequences' are not included when importing and/or exporting default linking settings
• No information message appears when an object is added to Source Control
• There's no progress bar when creating database objects type subfolders
• Users and roles on the 'Permissions' tab in the visual editor are listed wrongly
• The "A database name must be specified" message is shown when editing synonyms while the database is linked to Source Control via SVN
• The 'Drop & Create' object script is generated in the 'Visual Editor's Script' tab when editing 'User-Defined Data Types' even if no changes are made
• There's no visual progress indicator in the Source Control configuration when the Test button is clicked in Source Control Wizard
• The "Object reference not set to an instance of an object." error is shown when a table is renamed via the ApexSQL Version's visual editor
• The drop-down list for the schema selection is empty in the 'Properties' pane of the visual table editor
• It is not possible to change a table's schema while editing any table
• The 'There are multiple root elements .' error is shown when editing an XML schema collection via the visual editor under the VisualSVN
• The object removed from Source Control is offered as a valid candidate for the 'Get Latest Version' command when native Visual SourceSafe drivers are used
• The ">file_name_with_full_path< is not a working copy" error is shown if the working folder is empty while the 'Undo Check Out' operation is performed
• During the trial period, even if the 'Evaluation notice' dialog is closed, it is possible to enter the application
• The SourceGear Vault service version 6.x is not supported in Source Control via native drivers
• Using the Object Editor to edit the structure of a SQL stored procedure results with being unable to edit the SQL stored procedure's signature via the 'SQL Body' tab
• Editing a live object whose SQL script is under version control results in the incorrect version of the script being checked out by the add-in

Changes:

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

Enhancements:

• Navigation through the Object Explorer has been significantly improved in all SQL Server Management Studio versions. The speed gain depends on the number of the objects in the database and starts at 500% when working with a database containing a few hundred objects of the same type
• The generation time of the "Database linking status" report has been significantly lowered particularly on databases mapped to Subversion via native drivers. The speed gain depends on the number of objects in the database and starts at 1700% for databases containing few hundred objects
• Mapping databases to a remote Subversion server via native drivers as well refreshing the Object Explorer for such databases has been greatly improved. The speed gain depends on the number of the object types mapped. For databases containing several hundred objects of different object types, the mapping process can be up to several times faster
• A progress indication dialog is now shown while the "Database vs. Source control differences" report is being generated
• A progress indication dialog is now shown in the "Configure linking" step of the "Source control wizard", while adding a database to source control
• The add-in doesn't affect the time needed to generate a CREATE script for SQL full text stoplists any longer
• Checking out databases and objects linked to Subversion is now up to 300% faster

Fixes:

• Navigating databases and tables in the SQL Server Management Studio's Object Explorer on a remote SQL Server connected via VPN is five times slower if the add-in is installed
• ApexSQL Version commands are not disabled for databases that are not linked to source control
• Changes made to the contract object type in the "Visual editor" cannot be saved when VisualSVN is used
• Services created under the queue object type cannot be versioned via the add-in, as an update script is not generated for modifications performed via the "Visual editor"
• Message types cannot be properly handled via the add-in, as an update script is not generated for modifications performed via the "Visual editor"
• The "Modify remote service binding" command via the add-in fails because the update script is not generated
• Updating routes via the "Visual editor" does not work because the update script is not generated
• There is no warning during the add-in's installation process which informs the user if Visual Studio and/or SQL Server Management Studio is running
• The add-in can be uninstalled while SQL Server Management Studio is active resulting in an incomplete uninstall
• The "ErrorFileAlreadyExists" error is encountered after connecting a database to the Team Foundation Server 2010 using a MSSCCI provider and initiating a source control object status refresh
• Cancelling during the "Confirm linking" step of the "Source control wizard", results in SQL Server Management Studio being non-responsive
• The synchronization script is not updated in the "Generated script" tab after adding a new SQL search property when editing the SQL search property list object
• The "Use version from source control" option in the Select object version dialog, loads the database version when editing a table which differs between the source control and the database
• The "Use version from source control" option in the Select Object Version dialog, loads the database version when editing a procedure which differs between the source control and the database, and was previously edited and checked into the database that was linked to Subversion via the Native driver
• The changes are automatically applied to a database after object editing, when the "Apply to database after editing" option is set to "Never"
• The Object Explorer context menu commands "Database vs. Source control differences" and "Show database/Source control script differences" don't open the corresponding reports in SQL Server Management Studio 2005 without Service pack 1
• The Help request invoked by F1 or the "?" button while an object edit dialog is active, opens a non-existing web page
• The text of the two options in the Select the object version dialog is not fully visible when using the 120 DPI system font resolution
• The text of the Edit queue dialog options, "Maximum queue readers" and "Poison message handling", is overlapped by their corresponding value entry controls when using the 120 DPI system font resolution
• The Check-out comment dialog text overlaps the comment edit box, and the "Don't show this again" checkbox text is not fully visible when using the 120 DPI system font resolution
• SQL Server Management Studio displays a depreciated "ApexSQL Version Edit" toolbar with all commands disabled
• High memory leakage and CPU load lead to SQL Server Management Studio 2012 unresponsiveness when expanding a database node, in scenarios where 3 or more large databases are linked to Subversion via native drivers
• The error message "Nije uradjen check-out", when updating an object that was not checked out, is not in English
• Immediately after linking a database to a source control, the differences report shows that all database objects are different from their source control versions
• Objects cannot be linked to a source control via Team Foundation Server native drivers if each object type is not linked to its appropriate subfolder
• The "access to the path >working folder location< is denied" error is shown on attempting to check-out any object, if the database is linked to a Team Foundation Server via MSSCCI drivers
• The "access to the path >working folder location< is denied" or the "Error AccessFailure" error is shown on attempting to check-out any object, if the database is linked to a SourceGear Vault via MSSCCI drivers
• SQL full text stoplists created via system stoplists cannot be processed by ApexSQL Version, as changes applied via the "Visual editor" are not handled
• The "Object reference not set to an instance of an object" error is encountered when attempting to processing SQL FileTables using "Visual editor"
• Database objects removed from source control are marked as different in the "Database vs. Source control differences" report
• Displaying the context menu for any database object linked to source control does not retrieve the correct information on whether the object has been linked to source control
• A checked out without saving, and then changed and saved SQL table is always reported as the same as the version in the source control
• When adding ole members while editing a SQL role, the "Select a database role or user" dialog doesn't have a system menu icon in the top left corner and can be resized to hide all of the UI elements
• Increasing the number of objects significantly increases the time needed for the "Confirm linking" operation
• The add.in doesn't follow the proper version number form in "Add/Remove Programs"

Changes:

• The Source control wizard requires "/vaultservice" to be appended to the SourceGear Vault server address when connecting to the SourceGear Vault server via the native drivers
• The "Object source control status check-up interval" option has been disabled by default in order to improve SQL Server Management Studio's responsiveness
• The "View history" command has been removed on the database level

Enhancements:

• The add-in now fully supports the following SQL Server 2012 object types:
  • FileTable
  • Sequence
  • Search property list
• Visual editors have been introduced for editing versioned objects allowing the following to be edited:
  • DDL
  • Properties
  • Extended properties
  • Permissions
• Improved security: Certificates cannot be versioned any more

Fixes:

• Context menu commands not applicable for the selected object are always enabled if the add-in is installed under SQL Server Management Studio 2005 pre-Service Pack 1
• A database linked to a SourceGear Vault server 5.1 repository via Native driver is no longer displayed as linked after restarting SQL Server Management Studio 2005 pre-Service Pack 1

Enhancements:

• Add-in now works in SQL Server Management Studio 2012
• Add-in now supports SQL Server 2012

Fixes:

• Add-in is not available in SQL Server Management Studio 2012 after applying KB2645410 system update
• "Object <object name> not found in the database" error is encountered when using Update Object | To Specific Version in Source Control command for User Defined Data Type
• Update Source Control command checks in empty object script to source control repository if the object was previously modified
• "Method not found" error is encountered when using Update Object | To Specific Version in Source Control command if ApexSQL Refactor 2011.01 add-in is also installed
• "The type initializer for 'ApexSql.Common.Activation.DllActivationManager 1' threw an exception" error is encountered when attempting to Check for Updates if ApexSQL Complete 2012.01 add-in is also installed
• "Object reference not set to an instance of an object" error is encountered after linking a database to source control if the database was taken offline
• Database and source control versions of recently linked and unchanged Table will be reported as different when checking out the Table
• Add-in log file contains log entries from other installed ApexSQL SQL Server Management Studio add-ins
• New objects are checked in to source control with 'ApexSQL Edit Automatic Operation' comment by Update Source Control command
• Source Control Wizard opens ApexSQL Complete help when this add-in is also installed
• "Value does not fall within the expected range" error is encountered when using Add Object to Source Control command after changing source control linked database's working directory
• Background source control to object explorer object status refreshing stops working over time
• Modified object script is still checked in to source control after difference viewer is cancelled
• "[Online] info operation error for..." error is encountered during check in if the password used for connecting to Subversion repository via Native driver has been changed after logon
• Incorrect logo image is displayed in add-in generated reports
• "Could not connect to..." error is encountered after source control login dialog shown for Add Object to Source Control, View, Edit, Update Source Control or Remove Object from Source Control commands is cancelled
• View Labels command for database linked to Subversion repository using Native driver warns twice about unsupported labels
• Source Control Wizard dialog size and position aren't preserved between sessions
• Source control operation warning message dialogs have ApexSQL Refactor or ApexSQL Complete title when those add-ins are also installed
• "The database was successfully linked to Source Control" message box doesn't have add-in name in the title
• Support Forum main menu command opens ApexSQL Refactor support forum page

Changes:

• Source Control Wizard | Configure Linking Export and Import file save/load dialogs default location is now "ApexSQL\Version" path under user documents folder
• Object Edit command now displays database and source control version selection dialog before the check out dialog if the database and source control object scripts are different

Known limitations:

• Background source control to object explorer refreshing stops working over time
• "ApexSql.SourceControl.Exceptions.OperationException" error is encountered if the password for connecting to Subversion server is changed on the server itself