ApexSQL Source Control Changelog

What's new in ApexSQL Source Control 2021.01.0131

Dec 25, 2022

Fixes:
"[Incorrect syntax near '=']" at [position: 476, line: 14, column: 61] error is encountered when synchronizing SQL database to the repository
Database changes are not shown in the "Action center" tab' after the linking process is done for databases containing procedures with the "at time zone" statement
The delay of 5 s in opening a new query appears when 20 databases are linked to the source control repository
The right-click context menu commands are not applicable on the group header in the "Action center" tab when the groups are collapsed
Excluded objects present only on the repository side are shown in the "Action center" tab after SSMS restart
Database changes are not shown in the "Action center" tab after the linking process is done for databases containing procedure with the output parameter defined without the square brackets in a script
Database changes are not shown in the "Action center" tab after the linking process is done for databases containing an object with formatted query result as JSON without ROOT node name defined in a script
"Parse error: [Incorrect syntax near 'UPDLOCK']" error is encountered when try to link a database
Database changes are not shown in the "Action center" tab after the linking process is done for databases containing objects with the number formatted as <number>.e<number> in a script
Action Center doesn’t show static data for tables with custom schema owners
"No committed changesets" error is encountered when the "Object Explorer" panel right-click context menu "Project history" command is clicked after the initial commit is finished for the Perforce source control system
"Make sure correct username and password are specified" error is shown when the Test or Finish button is clicked in the Source control setup window for Perforce when linking a second database to the same workspace and depot
Credential object type is missing under the "Object filter" tab in the "Options" window
"Parse error: [Incorrect syntax near '@locale'] at [position: 820, line: 26, column: 53]" is encountered when trying to link database to Git repository hosted on Azure Services
Database changes are not shown in the "Action center" tab after the linking process is done for databases containing procedures with the "at time zone" statement
Credential object type is missing under the "Object filter" tab in the Options window
Changes:
The activation model is switched to Subscription
The application does not support integration into SQL Server Management Studio 2012, 2014, and 2016 versions

New in ApexSQL Source Control 2021.02.2124 (Jul 13, 2021)

Fixes:
204610: The labels created on the Subversion repository using the File authentication are not shown in the Labels window
202359: ''Database <database_name> not accessible for the user 'username''' message is shown when the Link to source control right-click database command in the Object Explorer panel is clicked for a database with an apostrophe in its name
204550: ''One or more errors occurred'' error is encountered when the Get button is clicked in the Labels window for a label created on a root of the Git repository
205736: An object is listed for deletion from a database in the Get changes from the repository window after the Get button is clicked in the Labels window when all objects on which it depends are not a part of the selected label
206194: "The path is not of a legal form" error is encountered when any other changeset is selected after the initial commit changeset in the Object history window
206202: ''Connection failed with message: 'The path is not of a legal form''' error is encountered when a non-existing string is typed in the text filter for any object grid column in the Project or Object history window
206330: The name of an object with the migration script is shown as .%object_name% in the Migration scripts dialog after the migration script is being edited
206199: The Script errors dialog is shown when the Get or Get changeset button is clicked in the Project or Object history window for a changeset related to label creation or deletion on the Subversion repository
205996: ''One or more errors occurred'' error is encountered when the Get button is clicked in the Labels window for a label created on a root of the Mercurial repository
205737: The Project history window closes when the Get changeset button is clicked for a changeset that does not contain all dependent objects for a database linked to a repository root
206211: ''Nothing to sync between the source control and database versions'' error is encountered when the Get changeset button is clicked in the Project history window for a previously committed static data change
206205: The script for the first object on the list of the selected changeset is shown in the Object history window
206158: The add-in’s object status icons and right-click context menu commands are shown on the sub-object level in the Object Explorer panel
206066: The Action center tab is opened after SQL Server Management Studio restart even though the credentials are not present in the Connect to source control dialog
206203: ''Connection failed with message: 'Value cannot be null. Parameter name: path2''' error is encountered when a non-existing string is typed in the text filter for any changeset grid column in the Project or Object history window
206072: The static data is shown as conflicted in the Action center tab for the second database linked in the dedicated model to the same repository
205997: A database can be linked to the Azure DevOps Server/Services repository root
206020: All objects from a database are shown in the Object filter grid in the Object filter tab of the Source control setup window after the object filter is imported
206660: Filter options in the Object filter tab under the Source control setup and Options window do not work
198750: “System.OutOfMemoryException” error is encountered when the Create button is clicked in the New label window for a database linked to the Azure DevOps Server repository in the shared development model and there are more than 10K labels
204313: The Show/Hide objects button under the Object filter tab in the Source control setup window does not respond if in the same session the development model is changed
200240: The Action center tab is not fully visible on Full HD display resolution (1920x1080) and 150% scaling
203664: Database changes are not shown in the Action center tab after the linking process is done for databases containing objects with the With result sets command in a script
204017: Database changes are not shown in the Action center tab after the linking process is done for databases containing values inside quotes as a part of the Dateadd function
203665: Database changes are not shown in the Action center tab after the linking process is done for databases containing values inside square brackets as a part of the Dateadd function
204020: Database changes are not shown in the Action center tab after the linking process is done for databases containing the Reseed value inside quotes as a part of the Dbcc checkident command
204249: Objects containing the 'con' in the name will be shown without names in the Action center tab after upgrading to the 2021.01.2063 add-in version
204250: The latest object state is not shown in the Action center tab after upgrading to the 2021.01.2063 add-in version if the label exists on the repository
203565: ''Database %database% not accessible for the user 'username''' error is encountered when the Encrypt connection and Trust connection options are checked under the Connection Properties tab in the Connect to Server dialog
203384: "The path is already mapped in workspace" error is encountered when the Browse for folder button, under the System login tab in the Source control setup window, is clicked for Azure DevOps Server and a non-default collection is chosen
203385: "Object reference not set to an instance of an object" error is encountered when the Browse for folder button, under the System login tab in the Source control setup window, is clicked for Azure DevOps Server and the chosen collection is offline
204272: ''Database '%database name%' not accessible for the user '%username%''' error is encountered when the Link database to source control right-click Object Explorer panel context menu command is clicked in SQL Server Management Studio 18 and ApexSQL Analyze is integrated as well

New in ApexSQL Source Control 2021.02.2119 (May 13, 2021)

Enhancements:
SQL graph tables support
Temporal tables support
Delete button is added in the Labels window
Refresh button is added in the Labels window
Fixes:
204610: The labels created on the Subversion repository using the File authentication are not shown in the Labels window
202359: ''Database <database_name> not accessible for the user 'username''' message is shown when the Link to source control right-click database command in the Object Explorer panel is clicked for a database with an apostrophe in its name
204550: ''One or more errors occurred'' error is encountered when the Get button is clicked in the Labels window for a label created on a root of the Git repository
205736: An object is listed for deletion from a database in the Get changes from the repository window after the Get button is clicked in the Labels window when all objects on which it depends are not a part of the selected label
206194: "The path is not of a legal form" error is encountered when any other changeset is selected after the initial commit changeset in the Object history window
206202: ''Connection failed with message: 'The path is not of a legal form''' error is encountered when a non-existing string is typed in the text filter for any object grid column in the Project or Object history window
206330: The name of an object with the migration script is shown as .%object_name% in the Migration scripts dialog after the migration script is being edited
206199: The Script errors dialog is shown when the Get or Get changeset button is clicked in the Project or Object history window for a changeset related to label creation or deletion on the Subversion repository
205996: ''One or more errors occurred'' error is encountered when the Get button is clicked in the Labels window for a label created on a root of the Mercurial repository
205737: The Project history window closes when the Get changeset button is clicked for a changeset that does not contain all dependent objects for a database linked to a repository root
206211: ''Nothing to sync between the source control and database versions'' error is encountered when the Get changeset button is clicked in the Project history window for a previously committed static data change
206205: The script for the first object on the list of the selected changeset is shown in the Object history window
206158: The add-in’s object status icons and right-click context menu commands are shown on the sub-object level in the Object Explorer panel
206066: The Action center tab is opened after SQL Server Management Studio restart even though the credentials are not present in the Connect to source control dialog
206203: ''Connection failed with message: 'Value cannot be null. Parameter name: path2''' error is encountered when a non-existing string is typed in the text filter for any changeset grid column in the Project or Object history window
206072: The static data is shown as conflicted in the Action center tab for the second database linked in the dedicated model to the same repository
205997: A database can be linked to the Azure DevOps Server/Services repository root
206020: All objects from a database are shown in the Object filter grid in the Object filter tab of the Source control setup window after the object filter is imported
206660: Filter options in the Object filter tab under the Source control setup and Options window do not work
198750: “System.OutOfMemoryException” error is encountered when the Create button is clicked in the New label window for a database linked to the Azure DevOps Server repository in the shared development model and there are more than 10K labels
204313: The Show/Hide objects button under the Object filter tab in the Source control setup window does not respond if in the same session the development model is changed
200240: The Action center tab is not fully visible on Full HD display resolution (1920x1080) and 150% scaling
203664: Database changes are not shown in the Action center tab after the linking process is done for databases containing objects with the With result sets command in a script
204017: Database changes are not shown in the Action center tab after the linking process is done for databases containing values inside quotes as a part of the Dateadd function
203665: Database changes are not shown in the Action center tab after the linking process is done for databases containing values inside square brackets as a part of the Dateadd function
204020: Database changes are not shown in the Action center tab after the linking process is done for databases containing the Reseed value inside quotes as a part of the Dbcc checkident command
204249: Objects containing the 'con' in the name will be shown without names in the Action center tab after upgrading to the 2021.01.2063 add-in version
204250: The latest object state is not shown in the Action center tab after upgrading to the 2021.01.2063 add-in version if the label exists on the repository
203565: ''Database %database% not accessible for the user 'username''' error is encountered when the Encrypt connection and Trust connection options are checked under the Connection Properties tab in the Connect to Server dialog
203384: "The path is already mapped in workspace" error is encountered when the Browse for folder button, under the System login tab in the Source control setup window, is clicked for Azure DevOps Server and a non-default collection is chosen
203385: "Object reference not set to an instance of an object" error is encountered when the Browse for folder button, under the System login tab in the Source control setup window, is clicked for Azure DevOps Server and the chosen collection is offline
204272: ''Database '%database name%' not accessible for the user '%username%''' error is encountered when the Link database to source control right-click Object Explorer panel context menu command is clicked in SQL Server Management Studio 18 and ApexSQL Analyze is integrated as well
Changes:
Create label and Show labels commands under the right-click Object Explorer panel context menu are now replaced with the Labels command
Object filter and Script options tabs are now under the Advanced options tab in the Source control setup window
Known limitations:
Objects containing Windows reserved words in their name and committed to source control with the 2021.01.2063 or 2021.01.2072 add-in versions are shown in the Action center tab as non-existing on both sides and history for those objects is not accessible
An object containing special characters in the schema name is shown as non-existing on a database side in the Action center tab after the initial commit is finished
"TortoiseSVN version is not supported" message is shown when the Browse for folder button is clicked in the Source control setup window when working with the TortoiseSVN client version higher than 1.9
Excluded objects present only on the source control repository are shown in the Action center tab after SQL Server Management Studio is restarted

New in ApexSQL Source Control 2021.01.2080 Patch (Mar 29, 2021)

New in ApexSQL Source Control 2021.01.2072 Patch (Mar 4, 2021)

New in ApexSQL Source Control 2021.01.2063 (Feb 22, 2021)

Enhancements:
Performance of the Action center tab has been improved up to 280%
New framework object for both development models is added
Additional ignore comparison options are added under the Script options tab:
Server and database names in synonyms
Next filegroups in partition schemas
Additional synchronization options are added under the Script options tab:
Include dependent objects
Script USE for database
Static data resolve conflict support
New ApexSQL Updater allows users to configure advanced updating settings of all installed ApexSQL products
Application telemetry now collects anonymous data on the use and performance of applications and application components
Fixes:
199093: “The ‘Stub’ package did not load correctly” warning message is shown on SQL Server Management Studio startup after the add-in installation
187619: The static data remains listed in the Action center tab after applying it against a database linked to the working folder
168784: The Object Explorer right-click database source control context menu is shown only for the first selected database from a connected SQL Server
177730: ''Policy Warning. Internal error in Changeset Comments Policy'' error is encountered when committing changes to the Azure DevOps Services repository and the commit comment policy is set
169832: Switching between the Options tab is not possible if the linked database is not selected in the Object Explorer panel before the Options main menu command is clicked
182664: ''Make sure correct username and password are specified'' error is encountered when the Finish button is clicked in the Source control setup window for the Git repository hosted on the BitBucket.org or GitHub service using the SSH authentication
187993: The repository script is not shown in the Action center tab for procedures that contain the Alter table and Drop if exists statements in that order
192734: ''Commit failed and changes will not be applied'' error is encountered when the Apply button is clicked in the Action center tab for objects created under the aux schema
193836: ''SELECT failed because the following SET options have incorrect settings: 'CONCAT_NULL_YIELDS_NULL''' error is encountered when an object is altered using the Concat null yields null statement if the ApexSQL_SourceControl_DDL trigger is present on a Server level
193990: ''Error occurred updating database object: Parse error: Object reference not set to an instance of an object'' error is encountered when applying a procedure created under the usercreated schema against a database linked to a working folder
200041: An object can be edited without been previously checked out and locked even though when the Restrictive database policy is set
185108: '''ApexSQL_SourceControl_DDLTrigger' missing. Re-link database to track changes'' error is encountered on every click for SQL Server 2008 SP4 database linked in the shared development model
178410: Changes can be committed by the other user when the Restrictive database policy is set and the Commit other user changes option is not enabled for a database linked in the shared development model on the Azure DevOps Server
179247: The maximal value of the Number of changesets shown in the ''History'' form option is limited to 1,000 changesets
180249: ''Could not select repository '' on Server'' error is encountered when the Browse for folder button is clicked in the Source control setup window for the Azure DevOps Server when using Token
181591: The collation part is not shown in the object script in the Action center tab when the Collations option is checked under the Script options in the Options window
181594: The Latin1_General_CI_AS_KS_WS collation is generated in the synchronization script regardless of the set database collation when the collation is not specified in the repository script
179234: The object status for the user object type does not follow the check status for a database linked in the shared development model
179246: All committed changesets to a source control repository are shown in the Object history window
180927: The exported excluded objects list will be different if previously is clicked the Show objects button in the Local settings tab of the Options window
167076: "Could not connect to Server 'https://dev.azure.com/' with message: 'Method not found: 'Void..." error is encountered when the Finish button is clicked in the Source control setup window for the Azure DevOps Services
167873: "Make sure correct username and password are specified" message is shown when the Finish button in the Source control setup window is clicked for the Git repository hosted on the GitLab service using the SSH authentication
168613: "Changes were not applied" message is shown when the Get button is clicked in the Labels dialog
129467: "Make sure that correct username and password are specified" message is shown when the Finish button is clicked in the Source control setup window for the Git repository hosted on the Bitbucket Server when using the SSH authentication
152841: ''To commit changes reenter password'' message is shown when the Apply button is clicked in the Action center tab for the Git repository hosted on the BitBucket.org service when using the SSH authentication
152849: The getting latest from source control step in the Action center tab never ends for the public Git repository hosted on the BitBucket.org service when using the SSH authentication
157548: The Acton center tab cannot be opened if previously is closed using SQL Server Management Studio shortcut
163799: The object status is not updated in the framework object tables for the shared development model
164177: Object history window is not functional in high DPI and 4K resolution
164179: Project history window is not functional in high DPI and 4K resolution
165004: SQL Server Management Studio restarts when the Finish button in the Source control setup window is clicked for the Git repository hosted on the BitBucket.org service when using the SSH authentication
166021: SQL Server Management Studio closes when the Finish button is clicked in the Source control setup window when a database is linked to a new empty Git repository hosted on the GitLab service when using the SSH authentication
166904: "Object reference not set to an instance of an object" error is encountered when the Get changeset button is clicked in the Project history window
167069: Framework objects are not dropped after the unlinking process is done for the Azure SQL Database linked in the shared development model
192942: Data compressed tables are scripted as partitioned tables, when any other filegroup under a table is not created, is set as a default one
199832: The add-in options are not present in the Object Explorer right-click context menu for any object in the linked database
76737: "SystemOutOfMemory exception" error is encountered when applying changes against a database with more than 8,000 objects
87834: SQL user created from a login is scripted as a SQL user with a password when applying changes against a database
88077: Additional empty lines are shown as a difference in the edited object script for a database linked to the Team Foundation Server 2017 repository
94386: An object change cannot be applied against a database if the only difference is white space
94387: The Get changes from the repository window will not be open when the Check constraint change is applied against a database
95081: Table columns will not be scripted in the Action center tab after a table is dropped and re-created and one column is set to be nullable
111194: An object will be shown as a conflicted one in the Action center tab after switching branch for a database linked to the Subversion repository
115873: ‘’Object references not set to an instance of an object’’ error is encountered when the Action center tab is opened by the user with the lack of permissions
120507: Linked static data will become unlinked after connecting to a SQL Server with another login and connect back with the same login used to link a database
123542: The static data remains in the Action center tab after being committed if in the same changeset the custom and migration script are committed as well
125085: "Commit failed! Check log for more details" error is encountered when the Apply button is clicked in the Action center tab by a user that has the minimal required permissions
149571: The Connect to source control window is shown after every button-click for the Git repository hosted on the Azure DevOps Services
152639: SQL Server Management Studio becomes unresponsive when the Refresh button in the Action center tab is clicked for a database with 10,000 objects
155462: Ignore comparison options are not loaded when the My default button is clicked in the Source control setup window
157571: The add-in Export folder is created wherever the SQL Server Management Studio shortcut exists on the machine
157624: The Action center tab cannot be open using the Ctrl+Shift+X keyboard shortcut if it is previously closed using the Alt+F4 keyboard shortcut
159525: The Action center tab does not detect the custom script folder unlink change
163811: The shortcuts under the Shortcuts tab of the Options window cannot be disabled
164220: The resolve conflict window is not shown when single object changes are committed to the repository using the Commit changes command from the Object Explorer panel right-click context menu
164923: SQL Server Management Studio becomes unresponsive when branches are merged
164930: SQL Server Management Studio becomes unresponsive when the Refresh button is clicked in the Action center tab for a database linked to the Git repository hosted on the BitBucket.org service when using the SSH authentication
164932: The Insert scripts are not executed when applying changes against a database
164938: The Migration script window is closed when the Edit button is clicked
164939: The Add migration script right-click context menu command in the Action center tab is missing after the previously created migration script is deleted for that table
166794: "Specified project '$/<project_name>' not available. Ensure that project exists and is available" error is encountered when the Refresh button is clicked in the Action center tab for a second database linked to the same repository
166889: "Cannot create branch '$/test-branch1'. The item $/branch already exists" message is shown when the Create button in the Create branch window is clicked for the Azure SQL Database
167207: "Make sure correct username and password are specified" message is shown when the Finish button is clicked in the Source control setup window for the Git repository hosted on the Azure DevOps Services
167395: "Credentials are not valid" message is shown when the Finish button is clicked in the Source control setup window for the Azure DevOps Services when the Use Windows authentication option is checked
167634: A changeset is not present in the Merge branches dialog when change is committed to a newly created branch for the Git repository when using the File authentication
168278: ‘’Passphrase filed is empty or the passphrase not valid’’ message is shown when the wrong URL is typed in the Source control setup window and the Finish button is clicked for the Git repository when using the SSH authentication
168609: The Migration script window is closed when the Edit button is clicked for the existing migration script
168680: "Depot with name '$/DepotName' doesn't exist on this server" message is shown when the Browse for folder button is clicked in the Source control setup window and folder path is already present in the Project filed for the Perforce server
178559: "Could not select repository "on Server" error is encountered when the Finish button is clicked in the Source control setup window for the Azure DevOps Server when using the wrong credentials
Changes:
Error handling and send logs functionality has been modified
ApexSQL defaults, My defaults, and Save as my defaults functionality has been modified
Ignore comparison options tooltips are clickable now and they show examples for each option
Minimal required SQL Server permissions to work with ApexSQL Source Control are changed
Minimal required Azure SQL Database permissions to work with ApexSQL Source Control are changed
Minimal required Amazon RDS for SQL Server permissions to work with ApexSQL Source Control are changed
Merge branches option is now supported only for the Git source control system
Known limitations
"TortoiseSVN version is not supported" message is shown when the Browse for folder button is clicked in the Source control setup window when working with the TortoiseSVN client version higher than 1.9
''Database <database_name> not accessible for the user 'username''' message is shown when the Link to source control right-click database command in the Object Explorer panel is clicked for a database with an apostrophe in its name

New in ApexSQL Source Control 2019.2.1483 (Jan 17, 2020)

New in ApexSQL Source Control 2019.4.1443 (Dec 13, 2019)

Enhancements:
Object status icon for linked static data is added in the Object Explorer panel
SQL Server 2019 support
Getting entire changeset in the Project History window is faster by 6,000%
Fixes:
The initializing progress bar never ends in the Action center for shared database after importing connection
"Get latest version failed with the message" error is encountered when the Action center tab starting after importing connection for database linked to the VSTS repository
The application cannot be uninstalled if any version of SQL Server Management Studio is running, even though the application is not integrated in it
The application cannot be uninstalled if any version of Visual Studio is running, even though the application is not integrated in it
The application can be integrated into SQL Server Management Studio 18, even though it's currently running
"Changes were not applied" error is encountered when the label is applied for the Azure DevOps repository hosted on the Azure DevOps Server
Changes can be committed to the Azure DevOps repository without specified work item, even though the work item policy and the comment policy are set for that repository
The White space ignore comparison option under the Action center tab does not work with views
"AT" alias is deleted in the synchronization script when applying changes against a database
A database object can be deleted, even if it is not checked out and locked when the Restrictive database policy is set for database linked in the shared development model
Table index containing the Include clause is not scripted correctly in the Action center tab
New object cannot be created when the restrictive policy is set for database linked in the shared development model
The Connect to source control window is not show in the Action center tab after SQL Server Management Studio is restarted for a databases linked to the Git repository using the SSH authentication
"ApexSQL_SourceControl_DDL Trigger is missing" error is encountered when linking a SQL Server 2005 database to Azure DevOps Server repository
"Merge successful" message is shown when the OK button is clicked in the Merge branches window, even when the branches are not merged
"Object reference not set to an instance of an object" error is encountered when applying changes against a database linked in the dedicated model to the Git repository hosted on GitHub
The Action center tab hangs after SQL Server Management Studio is restared for a databases linked in the shared development model
"The given path's format is not supported." error is encountered when linking a database to a source control repository from a SQL Server that has ':' in its name
The Resolve conflict window is shown when two branches are merging for Git repository hosted on Azure DevOps Services
"Object references not set to an instance of an object" error is encountered when linking the Wide World Importers database to source control
"Object reference not set to an instance of an object" error is encountered when applying changes against a database linked in the dedicated model to the Git repository hosted on GitHub
The add-in commands appear in the right-click context menu in the Object Explorer when connected to a SQL Server Analysis Services or SQL Server Reporting Services or SQL Server Integration Services
Scripts for the renamed table are not shown in the Differences preview window in the Action center tab
"ApexSQL Source Control - Permissive policy is enabled on this database. Object must be checked out before editing" error is encountered when changes made against a locked object are reverted and the Restrictive policy option under the Administration tab of the Options window is enabled
The Action center tab does not recognize adding custom scripts as a change
All objects are shown as not committed in the Action center tab after importing connection for a database linked to the Subversion repository
SQL Server Management Studio stops working when connecting to SQL Server with the Active Directory - Universal with MFA support authentication
Known limitations:
"Make sure that correct username and password are specified" message is shown when trying to link a database to the Git repository hosted on the Bitbucket Server using the SSH authentication
SQL Server Management Studio stops working when linking a database to Git repository hosted on the BitBucket.org using the SSH authentication and SSH keys are created with the Command Prompt
"TortoiseSVN version is not supported" message is shown when the Browse for folder button is clicked in the Source control setup window when working with the TortoiseSVN client version higher than 1.9
SQL Server Management Studio freezes when the Confirm button is clicked in the Merge branches window for merging branches
"Specified project '$/<project_name>' not available. Ensure that project exists and is available" error is encountered when the Action center tab is refreshed for the second database with the same name and linked to the same repository

New in ApexSQL Source Control 2018.14.1293 Patch (Oct 10, 2019)

New in ApexSQL Source Control 2018.14.1287 Patch (Sep 24, 2019)

New in ApexSQL Source Control 2018.14.1285 (Jun 21, 2019)

New in ApexSQL Source Control 2018.14.1284 (Jun 13, 2019)

New in ApexSQL Source Control 2018.13.1280 Patch (May 31, 2019)

New in ApexSQL Source Control 2018.13.1279 (May 17, 2019)

New in ApexSQL Source Control 2018.13.1278 (May 15, 2019)

New in ApexSQL Source Control 2018.11.1273 (May 2, 2019)

New in ApexSQL Source Control 2018.11.1263 (Apr 2, 2019)

Enhancements:
The time for showing all database objects in the Object filtering tab of the Source control setup window has been improved by up to 567%
The time for showing the Action center tab after the Finish button is clicked in the Source control setup window has been improved by up to 50%
Fixes:
The repository credentials are required after the unlinking process is done for a database linked to the Azure DevOps repository
"Make sure correct username and password is specified" message is shown when linking to the Git repository hosted on Azure DevOps Services over SSH authentication
ApexSQL_SourceControl schema is shown in the Action center tab as an object that can be changed
"Could not get value for key 'password'" error is encountered when linking a database to Code Commit hosted on Amazon RDS for SQL Server
"Abort: http authorization required" error is encountered when linking a database to the Mercurial repository hosted on RhodeCode
The Action center tab cannot be started when the framework database name contains hyphen
ApexSQL Source Control framework objects are listed in the Object filtering tab for Azure SQL Databases
"Could not find a part of the path" error is encountered when any source control repository becomes unavailable
"Error in cleaning directory" error is encountered when the same database is unlinked and then linked in one SQL Server Management Studio session
"Credentials are not valid" message is shown when the Refresh collections button in the Source control setup window is clicked for Azure DevOps repository and the default Azure DevOps collection is offline
"The activation key invalid for this version" error is encountered when the eligible license key for ApexSQL Source Control 2018 versions is used for activation
The Action center tab is refreshed after label applying is canceled
The Show only different rows option is applied in the Project history window
SQL Server Management Studio stops working when the Show auto filter rows option from the Action center tab context menu is clicked
SQL Server Management Studio goes to not responding state when database objects are right-clicked in the Action center tab for a database with more than 18,000 objects
SQL Server Management Studio goes to not responding state when trying to change the action with a click on the action arrow under the Action column in the Action center tab for database with more than 18,000 objects
"Make sure correct username and password is specified" message is shown when linking to Git repository hosted on BitBucket.org over SSH authentication
Changes:
Object status icon color for the other user on a shared database is now purple
Known limitations:
"Make sure correct username and password is specified" message is shown when linking to Git repository hosted on GitLab over SSH authentication

New in ApexSQL Source Control 2018.10.1212 (Feb 21, 2019)

Fixes:
Changes made against object containing CTE are not recognized in the Action center tab
The Choose project window for the Mercurial repository is opened when the Test button is clicked in the Source control wizard
"SystemOutOfMemory exception" error is encountered when the database node in the Object Explorer panel is expanded if more than 20 databases are linked to source control
"The activation key invalid for this version" error is encountered when the eligible license key for 2018 add-in version is used for activation
"The Delete statement conflicted with the reference constraint" error is encountered when applying static data changes from a repository against a database
"Full-Text Search is not installed, or full-text component cannot be loaded" message is shown when changes are applied against a database even when the Full-Text Search feature is installed on SQL Server
Database with special characters in its name cannot be linked to source control
SQL Server Management Studio restarts when the Show objects command under the Global settings tab of the Options window is clicked on for databases with custom scripts folder linked
"Cannot create branch" error is encountered when click on the Create button in the Create branch window for the Git repository
"Make sure correct username and password are specified" message is shown when linking a database to the Git repository hosted on GitHub over SSH authentication
New SQL Server cannot be chosen in the Import connection tab of the Options window
The project in the Choose project window cannot be deleted for an Azure DevOps Server repository
"Object reference not set to an instance of an object" error is encountered when applying a label against a database
"The ApexSQL_SourceControl_DDL Trigger is missing" message is shown for SQL Server 2008 R2 databases linked in the shared development model
The add-in recognizes only default branch for the Mercurial repository
"Cannot create branch. One or more errors occurred" error is encountered when creating a new branch for the Azure DevOps Server repository
Branches are not listed in the Select branch window for the Azure DevOps Server repository
"The custom script folder is linked to source control" message is shown when the custom script folder is unlinked from source control
Deleted Azure DevOps Server team project is shown as string of random numbers in the Choose project window
"Make sure correct username and password are specified" message is shown when linking a database to Git or Subversion repository hosted on CloudForge
"Changes cannot be applied" message is shown when label is applied against a database with FullText index
"Changes were not applied" message is shown when applying changes against object with FullText index on SQL Server Express edition, if the Full-Text Search feature is not installed on SQL Server
The comment field in the Action center tab is disabled when commit comment contains only numbers

New in ApexSQL Source Control 2018.10.1199 (Feb 13, 2019)

"The Delete statement conflicted with the reference constraint" error is encountered when applying static data changes from a repository against a database
"Full-Text Search is not installed, or full-text component cannot be loaded" message is shown when changes are applied against a database even when the Full-Text Search feature is installed on SQL Server
Database with special characters in its name cannot be linked to source control
SQL Server Management Studio restarts when the Show objects command under the Global settings tab of the Options window is clicked on for databases with custom scripts folder linked
"Cannot create branch" error is encountered when click on the Create button in the Create branch window for the Git repository
"Make sure correct username and password are specified" message is shown when linking a database to the Git repository hosted on GitHub over SSH authentication
New SQL Server cannot be chosen in the Import connection tab of the Options window
The project in the Choose project window cannot be deleted for an Azure DevOps Server repository
"Object reference not set to an instance of an object" error is encountered when applying a label against a database
"The ApexSQL_SourceControl_DDL Trigger is missing" message is shown for SQL Server 2008 R2 databases linked in the shared development model
The add-in recognizes only default branch for the Mercurial repository
"Cannot create branch. One or more errors occurred" error is encountered when creating a new branch for the Azure DevOps Server repository
Branches are not listed in the Select branch window for the Azure DevOps Server repository
"The custom script folder is linked to source control" message is shown when the custom script folder is unlinked from source control
Deleted Azure DevOps Server team project is shown as string of random numbers in the Choose project window
"Make sure correct username and password are specified" message is shown when linking a database to Git or Subversion repository hosted on CloudForge
"Changes cannot be applied" message is shown when label is applied against a database with FullText index
"Changes were not applied" message is shown when applying changes against object with FullText index on SQL Server Express edition, if the Full-Text Search feature is not installed on SQL Server
The comment field in the Action center tab is disabled when commit comment contains only numbers
Known limitations:
Changes made against object containing CTE expressions are not recognized in the Action center tab
Test button in the Source control setup window opens the Choose project window for the Mercurial repository

New in ApexSQL Source Control 2018.08.1068 (Oct 22, 2018)

New in ApexSQL Source Control 2018.07.1059 (Oct 9, 2018)

New in ApexSQL Source Control 2018.06.1043 (Sep 27, 2018)

Enhancements:
Improved application installer with a dark theme
New application icon
High DPI and 4K resolution support
The whole changeset can be reverted from the history form
Fixes:
The option settings are not remembered when the Options dialog is closed
SSMS restarts when trying to link database with ''|'' in its name
"Some ApexSQL Source Control framework objects were not created successfully, attempt to relink the database to source control and inspect the add-in log for detailed information" message is shown when linking Azure database to Git repository hosted on GitLab via SSH authentication
"Make sure correct passphrase or key pair path is specified" error is encountered when try to link a database to Git repository hosted on GitLab via SSH authentication
Assemblies cannot be added to the migration script
"Could not find part of the path" error is encountered when linking database to Perforce source control system
"Error in localize options:Sequence contains no elements" error is encountered when trying to import connection for shared databases
"Make sure correct username and password are specified" message is shown when try to link a database to Git repository hosted on Team Foundation Server
The Source control setup window loses the theme after uninstalling ApexSQL Diff or ApexSQL Data Diff
"The specified folder doesn't have the appropriate structure" message is shown when linking to a repository created with older versions of the add-in
"Incorrect repository path is used for Git" message is shown when linking a database to Git repository hosted on Bitbucket.org
"Changes were not applied" error is encountered when applying a label against a database if Full-Text and Semantic Extraction for Search is not installed on SQL Server
The Labels window appears when the ‘’Check in’’ command is clicked on from the Object Explorer pane context menu
SSMS restarts when the Options dialog is closed on the Close (X) button
Initially committed modified objects under dbo schema are shown in the Action center tab like new objects that have never been committed
"Changes were not applied" error is encountered when applying label against a database
"Commit failed! check log files for more details" error is encountered when trying to perform initial commit to Subversion repository using the svn:// URL format
The "Check all" context menu command in the Action center tab should check only the visible objects from the list
The newly created labels containing special characters in names are not listed in the Show labels window
The second commit to TFS repository hosted on Team Foundation Server doesn't work
"Make sure that correct username and password are specified" message is shown when try to link a database to Git repository hosted on Team Foundation Server via SSH authentication
"Policy Warning. Internal error in 'policy name'" error is encountered when checking in changes without following the rule enforced with the Team Foundation Server policy
"The process was terminated due to an unhandled exception." error is encountered when ApexSQL Search 2016.07.0080 is installed as well
The Source control setup window closes when trying to choose another branch under the System login tab from the Git repository hosted on BitBucket.org
"Some ApexSQL Source Control framework objects were not created successfully" message is shown when linking database in the shared development model to Git public repository hosted on BitBucket.org
"The ApexSQL Source Control Trigger is disabled" message is shown when the Action center tab is started for shared databases after restarting SSMS
The changed option settings are remembered in the General tab of the Options dialog when the ECS keyboard key is pressed
The filtered object settings in the Object filtering tab of the Options dialog are remembered when the ECS keyboard key is pressed
All changes made in the Options dialog should be saved automatically when the OK button is clicked on
SSMS restarts when applying changes from the repository against a database
"At least one database must be linked to access the "Script options" tab" message is shown when the My defaults button is clicked on in the Options dialog
The "Owners in synchronization script" option settings are not remembered on closing the Options dialog
"The type initializer for 'ApexSQL.Common.Misc.ProductInfo' threw an exception." error is encountered when the "Send log" option is clicked on
"The chosen repository is not available" error is encountered when the Action center tab is started for a database linked to TFS repository hosted on VSTS if the password is not remembered in the Source control setup
"Object references not set to an instance of an object" error is encountered when trying to commit changes to Git repository hosted on BitBucket.org
"Could not connect to the server" error is encountered when linking a database to TFS repository hosted on VSTS
The Object explorer pane context menu commands do not work for database schemas
The Database dropdown list in the Administration tab of the Options dialog should not be disabled when SQL Server without linked databases is chosen
ExamDiffPro merging window starts empty when chosen as a default merging tool
The "Apply changes" option is saved on clicking the Cancel button in the Options dialog
The "Case" ignore comparison option does not work
Incorrect SQL migration script can be created in the Add migration script window
"Could not find file 'C:WindowsSystem32sc.txt'" error is encountered when click on a custom script in the Project history window
"Method not found" error is encountered when the Get updates command is clicked on
The Project history window closes when trying to apply changes against a database linked to Perforce source control system
The Object history window closes when trying to apply changes against a database linked to Perforce source control system
The Action center tab switches from offline to online mode after refreshing even when the option to go offline is not changed
"Could not find a part of the path < custom_scripts_location > " error is encountered when initiating the Action center tab after shared connections are imported for the shared database
"Database changes detected. Refresh the "Action center" tab" message is shown after closing the Project history window
The Browse for folder button for depot does not exist under the System login tab of the Source control setup window for Perforce source control system
SQL Server Management Studio must be restarted in order for the imported shared connections to take effect when working in the shared model
"Source control error: Failed commit!" error is encountered after specifying incorrect username when connecting to a public Git repository hosted on BitBucket.org
The projects under Git branches are not synchronized with branches state when we link a database to a non-master branch
Check state for listed objects in the Action center tab is not remembered after the Action center tab is refreshed
Excluded objects are shown in the Object status window
The "White space" ignore comparison option is checked on the start up
Commands in the Object Explorer pane context menu are duplicated
The label name containing spaces is deleted when the OK button is clicked on in the New label window
The newly added comments to the object script are not shown in the Script difference view
The object icon in the Object Explorer pane goes grey when the changes are reverted
"A secure connection could not be established" message is shown when linking for the first time to Git repository hosted on GitHub
All options are disabled in the Local settings tab of the Options dialog when two or more SQL Servers are connected in the Object Explorer pane
The action icon in the Action center tab changes direction when objects are checked
Static data change disappeared from the Action center tab once the table is renamed
"Database and source control are synchronized. Click to refresh" message is shown when committing changes to source control is stopped
"Exception caught during execution of push command" error is encountered when committing objects to a Git repository hosted on GitHub without specifying password under the System login tab of the Source control setup window
The Cancel button inside the progress bar is not working
"No source control labels found" message is shown when trying to commit change to a repository from the Object Explorer pane
The VSTS project created in root cannot be deleted from the Choose project window of the Source control setup window
Clicking the Apply button in case of committing changes takes 3 seconds to respond
Objects in the Local settings tab of the Options dialog become unchecked when the grouping is cleared
The information about creating a new database will be initiated in the Source control wizard even when clicking the Previous button in the Development model step
Database disappears from the database drop down list when trying to choose a database for storing framework objects in the Source control setup window in case a single database exists on a SQL Server
The Object Explorer pane become unresponsive when right click on a linked database
Tables without primary keys are shown in the Static data window
All options are disabled in the Global settings tab of the Options dialog when two or more Servers are connected in the Object Explorer pane
The add-in should be checking repository availability before the Action center tab is started
Selecting another database in the Object Explorer pane when the Action center tab is opened unchecks all listed objects in the Action center tab
All objects are unchecked after the Action center tab is restarted
Static data changes are not applied when label is applied against a database
The name of the user who modified table is missing from the Edited by column of the Action center tab
The Enter keyboard key should do the same action as left mouse click on the Apply button in the Action center tab
There is not any indication of initializing the Action center tab after refreshing it
The ApexSQL database disappears from the dropdown list of databases under the Development model tab for the shared model when the dropdown list is clicked on
The Alt keyboard key should not do the same action as left mouse click on the Next button in the Source control setup window
The add-in does not allow importing connections for databases that need different credentials from the ones specified first when importing connections for the shared model
The "Edit" option for uncommitted migration scripts is missing from the Action center tab context menu
The Migration scripts window does not have a script preview section
Additional objects linked after linking a database are not detected by the Action center tab

New in ApexSQL Source Control 2018.05.1006 (Aug 27, 2018)

New in ApexSQL Source Control 2018.04.0947 (Jun 28, 2018)

Enhancements:
Support for Team Foundation Server 2018 Update 2
Support for SQL Server Management Studio 17.8
Applied concepts of Visual Language Dictionary for Visual Studio for iconography, imagery, colors, menus, fonts, formatting and other GUI elements
Fixes:
The Action Center tab stays open after the Cancel button is clicked on in the connect to source control window
"Access denied. Make sure that username and password are correct" error is encountered when accessing the Git repository hosted on Team Services if it is accessed using the AD accounts
The Object Explorer tree collapses every time an object is unlinked from source control
The options under the Global object filtering tab are not being saved for SQL Server databases hosted on Azure virtual machine and linked to the Team Foundation Server repository
"There is nothing to sync between the source control version and the database" message is shown for the shared databases linked to the Subversion repository when the Get button is clicked on
The Schemas drop down list under the Object filtering tab of the Source control setup window is empty when skipping the Development model tab
Custom scripts are not shown in the Object filtering tabs of the Options dialog
"There is nothing to sync between the source control version and the database" message appears when applying changes from source control against a database related to custom scripts
Excluded custom scripts remain in the Action center tab
Loading the Action center tab takes too long in case of linking a database using the Working folder option
The Action center tab show differences after applying changes from the repository against a database
"There is nothing to sync between the source control version and the database" error is encountered when trying to delete the migration script through the Action center tab
The WITH NOCHECK part is added before every constraint in a database object script after reverting a static data change in the Action center tab
The user who renamed a column with the sp_rename procedure will not be listed under the Edited by column in the Action center tab
SQL Server Management Studio stops working after creating multiple branches one after another
The previously committed migration script appears in the Action center tab after re-linking a database
"There is nothing to sync between the source control version and the database" message appears when applying a custom script from source control against a database
SQL Server Management Studio stops working when filtering SQL schemas or object types under the Global settings tab of the Options dialog
Including objects under the Global settings tab of the Options dialog will not include the same objects under the Local settings tab of the Options dialog
The lasted used path for importing connection is not remembered under the Connections tab of the Options dialog
The add-in takes too much time when browsing the Project history for databases with large number of objects after a number of committed change sets
The Options dialog closes without any warning even when the Escape button (ESC) is pressed even if there are changes made
The add-in does not check if the selected default merging tool is installed or not
"Warn about pending changes on exit?" option does not work unless the Action center tab is opened
"Column ‘REFERENCE_VALUE’ does not allow nulls. " error is encountered when applying the static data from source control to database
Only the last linked shared database can be chosen under the Global settings tab of the Options dialog
The synchronization script is created when applying a label even if there are no differences between a database and created label
The migration script cannot be edited after it is saved
The Static data window closes if one of the selected tables does not containing the primary key
"An error occurred while updating the database object" error is encountered on attempt to undo changes made on a database linked in the dedicated model
The Action center tab goes online automatically after refreshing even if the ‘’Go offline’’ option is initiated before the refresh
"Make sure that correct username and password are specified" message appears when linking to a local folder that is not initialized as a Git repository
"Exception: Serialization failed for Production.ProductDocument [Data].xml" error is encountered when committing static data changes
The add-in checks credentials for Git public repository
The Team Foundation Server project cannot be deleted from the Source control setup when the alternate credentials are not used
Exported object selection cannot be imported unless the ‘’Show all objects’’ button is not initiated under the Object filtering step of the Source control setup
Only filtered SQL schemas will be shown in the Object filtering tab of the Source control setup after importing object selection with the specific schemas
The Options dialog cannot be initiated in case multiple ApexSQL tools are integrated in SQL Server Management Studio
The Action center tab can be initiated for a SQL database that was previously selected even after disconnecting a SQL Server instance from the Object Explorer pane
"Object reference is not set to an instance of an object" message appears when opening the Options dialog
"There is nothing to sync between the source control and the database" message is shown when try to get the migration script from the repository
"Failed to authenticate the Visual Studio Online account" error is encountered when linking a database to a Git repository hosted on Visual Studio Team Services using HTTPS protocol
The static data cannot be linked from the Action center tab
The migration script is not shown in the Action center tab
The Get button is disabled under the Object history window
The Connect to source control dialog appears each time when the Action center tab is initiated even if a connection to a Team Foundation Server is established using Windows credentials
"Save changes made against a database DatabaseName" dialog appears when switching between database in the Administration tab of the Options dialog
The Action center tab does not contain any information after linking a database to an empty repository
"Incorrect repository path is used for Subversion" message is shown when the "Browse for folder" button is clicked on when linking a database to the repository hosted on the Subversion
Linking a database to a Perforce repository is possible without entering username and password or even with wrong credentials
The Activation window is closed without warning when entering the wrong Activation key
A database cannot be linked to a Mercurial repository hosted on BitBucket.org
The static data stays in the Action center tab after commit to the repository is performed
All objects with schema changes stays in the Action center tab after the commit
The Apply button in the Action center tab does not work
"The process was terminated due to an unhandled exception." error is encountered when ApexSQL Search 2016.07.0080 is installed and the Analysis Services is clicked on
The "Send logs" option doesn't work
"Source control error: Push operation failed..." message is shown when try to link a database to the Mercurial repository hosted on Bitbucket.org
"Source control error: Push not permitted. Please check if you have write access to the repository" error is encountered when trying to create a new project on the Git repository hosted on BitBucket.org using SSH authentication
"Detected local offline commits. ApexSQL Source Control must synchronize repositories to go online" message is shown when trying to link to Git repository hosted on BitBucket.org using the SSH authentication
"File not found: < folder location >" Error is encountered when trying to link a database to the Mercurial repository hosted on BitBucket.org using the SSH authentication
The user created user and schema objects do not have the add-in context menu commands in the Object Explorer pane
Changes:
The creation of a new project through the add-in for the Team Foundation Services repository hosted on Visual Studio Team Services is deprecated
The creation of a new project through the add-in for the Team Foundation Services repository hosted on Team Foundation Services is deprecated
The application now requires Microsoft .NET Framework 4.7.1
Support for Windows Vista and Windows Server 2008 is deprecated

New in ApexSQL Source Control 2018.03.0788 (Mar 15, 2018)

New in ApexSQL Source Control 2018.02.0783 Patch (Mar 7, 2018)

New in ApexSQL Source Control 2018.02.0778 (Feb 20, 2018)

New in ApexSQL Source Control 2018.01.0777 Patch (Feb 9, 2018)

New in ApexSQL Source Control 2018.01.0768 Patch (Jan 14, 2018)

New in ApexSQL Source Control 2018.01.0766 (Dec 27, 2017)

New in ApexSQL Source Control 2017.07.0700 (Dec 13, 2017)

New in ApexSQL Source Control 2017.07.0697 (Dec 8, 2017)

New in ApexSQL Source Control 2017.06.0696 Patch (Nov 12, 2017)

New in ApexSQL Source Control 2017.06.0693 Patch (Nov 9, 2017)

New in ApexSQL Source Control 2017.06.0690 Patch (Oct 25, 2017)

New in ApexSQL Source Control 2017.06.0648 (Oct 12, 2017)

Enhancements:
Support for Team Foundation Server 2018 RC2
Fixes:
Changes cannot be committed to a separate Mercurial branch
The Action center tab shows incorrect scripts for a stored procedure after it is edited when an Azure SQL database is linked to source control using the Shared model
"Source control error: Cannot check-in pending changes. The array must contain at least one element. Parameter name: checkinParameters.PendingChanges" error is encountered on initial check-in to Team Foundation Server
Differences from the selected label are not applied against a database
Changesets are not shown in the Merge branches dialog when a database is linked to Subversion or Mercurial repository
"Cannot check-in pending changes 'Could not load file or assembly 'Microsoft.TeamFoundation.WorkItemTracking.Proxy, Version = 14.0.0.0''" error is encountered on an attempt to check-in changes to Team Foundation Server
"Make sure that correct username and password are specified" message is shown when linking a database to a Team Foundation Server repository hosted on a local machine
The Action center tab does not load the selected branch after it is picked from the Active branch drop-down list when working with Mercurial
Options in the update dialog are not saved after SQL Server Management Studio restart
"Could not load type 'Microsoft.VisualStudio.Services.WebApi.Utilities.Internal.UserAgentUtility" error is encountered when the Browse button under the System login tab of the Source control wizard is clicked for the Team Foundation Server repository
The add-in does not work with Amazon RDS
The Merge branches feature does not work for Subversion source control system
"The type initializer for 'ApexSQL.Common.UI.Forms.MetroMessageUpdater' threw an exception" error is encountered when the Get updates command under the Resources tab is clicked
Databases linked in the Dedicated model are shown under the Administration tab of the Options dialog
The Action center tab does not load in SQL Server Management Studio 17 when ApexSQL Generate is installed
SQL database structure is not committed to a Git local repository that is configured as bare
"Method not found: 'Void Microsoft.VisualStudio.Services.Common.VssPerformanceEventSource.RESTStart(System.String)'." error is encountered when creating a Team Foundation Server project in the repository root with alternate credentials specified
"Object reference not set to an instance of an object" error is encountered when trying to link a database to a Team Foundation Server project that does not exist
"Error while trying to format the server name from: IP_addressSQLServer_instance: No such host is known" error is encountered when connecting a SQL Server from a remote machine using the IP address
The Close button (X) saves the changes made under the Development tab when Shared model is used instead of just closing the modal dialog
"TF200016: The following project does not exist" error is encountered when creating a Team Foundation Server project using the add-in wizard while if alternate authentication credentials are not specified
"Object reference not set to an instance of an object" error is encountered when specifying a value that is not in the allowed range for the changeset ID under the Filter row in the Project history dialog
The add-in does not work on Git repository when using the Team Services account hosted by Azure
The action item in the Action center tab will be switched on right click
The White space ignore comparison option under the Script options tab of the Options dialog doesn’t work

New in ApexSQL Source Control 2017.05.0644 Patch (Sep 22, 2017)

New in ApexSQL Source Control 2017.05.0643 Patch (Sep 17, 2017)

New in ApexSQL Source Control 2017.05.0623 Patch (Sep 4, 2017)

New in ApexSQL Source Control 2017.05.0622 Patch (Aug 31, 2017)

New in ApexSQL Source Control 2017.05.0619 (Aug 23, 2017)

Enhancements:
Performance improved when working with databases connected over narrowband (less than 6Mbit/s):
The Object Explorer context menu opens up by up to 1,000% faster
The Source control setup wizard opens up by up to 500% faster
The Options dialog opens up by up to 1,185% faster
Filtering individual objects for shared databases has been sped up by up to 1,000%
Filtering schemas and object types for shared databases has been sped up by up to 200%
GUI themes:
Light
Blue
Fixes:
"Database and source control are synced. Click to refresh" message appears in the Action center tab even if there are changes in the Perforce depot
The add-in selects a random Team Foundation Server collection when linking a database if a collection is not already specified in the repository URL
The Object filtering selection can be exported even if a database is not selected in the Object filtering tab of the Options dialog
Team Foundation Server projects created from the add-in wizard are not visible in the Team Foundation Server
"Object_Filtering<server_name_database_name>.xml Path does not exist. Check the path and try again" error is encountered upon exporting object selection when the SQL server name contains a backslash character
"Passphrase is empty or invalid" error is encountered when linking a database to a Git repository using the SSH protocol
"Value does not fall within the expected range" error is encountered when linking a database to a Subversion repository when using the Windows integrated authentication or when the username is not specified
"URL 'local_path' non-existent in revision 2" error is encountered when trying to browse a Subversion repository from the System login step of the Source control wizard when the non-existent project is specified in the Project field
"Select a database in order to export/import object selection" message is shown in the Object filtering tab of the Source control wizard when linking a database
The Apply policies option of the Options dialog is not enabled when the Check-in policies active option of the Source control setup wizard is enabled
"Connection failed with message 'abort: no suitable response from remote hg'" error is encountered when linking a database to a Mercurial repository hosted on Bitbucket.org when using the SSH protocol
The "Apply policies" setting under the General tab of the Options dialog will not be saved after the Options dialog is closed
The "Check for updates on startup" and the "Show patches" options are missing in the ApexSQL Source Control available updates window
Get from repository action is not set by default in the Action center tab when the Apply all from source control command is used from the Object Explorer context menu
"Exception of type 'System.OutOfMemoryException' was thrown" error is encountered when committing static data for specific databases
"Failed commit! Error The executable did not complete within the allotted time" error is encountered when committing static data for more than 100 tables to a Mercurial repository
Pre-defined file format is missing for External options file under the Connections tab of the Options dialog
"Failed to connect to server" error is encountered when linking a database on a remote SQL Server instance using correct mixed mode authentication credentials in specific cases
Differences are shown in the Action center tab after applying all changes from source control repository to database if two or more databases with the same compatibility level but located on different versions of SQL Server are linked to the same source control repository in a dedicated development model
The Action center tab stuck on the third step when comparing objects between source control and database
"There is nothing to sync between the source control version and the database" error is encountered when applying changes from source control to a database for objects with previously created migration scripts
"Cannot create branch. Source control error: create branch operation failed with message Exception caught during execution of push command" error when trying to create a Git branch
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible" error is encountered when linking a database on a remote SQL Server instance connected using an IP address
"Parse error: [Incorrect syntax near ','] at [position: 223, line: 14, column: 44]" error is encountered when applying changes from source control to a database
Schema prefix is included in the synchronization script when applying changes from source control even if the Manage owners option under the Script options tab of the Options dialog is unchecked
"Unable to locate Mercurial version number in 'Mercurial Distributed SCM (version 4.2 + 4)'" error is encountered when linking a database to a Mercurial repository if the Mercurial client version on a local machine is 4.2
Static data remains in the Action center tab after it is committed
Changes:
Support for the CLI connection type has been deprecated
Pre-defined file format for External options file under the Connections tab of the Options dialog is added

New in ApexSQL Source Control 2017.04.0521 Patch (Jul 29, 2017)

New in ApexSQL Source Control 2017.04.0519 Patch (Jul 28, 2017)

New in ApexSQL Source Control 2017.04.0517 Patch (Jul 21, 2017)

New in ApexSQL Source Control 2017.04.0516 Patch (Jul 19, 2017)

New in ApexSQL Source Control 2017.04.0514 Patch (Jul 14, 2017)

New in ApexSQL Source Control 2017.04.0508 Patch (Jun 26, 2017)

New in ApexSQL Source Control 2017.04.0504 Patch (May 29, 2017)

New in ApexSQL Source Control 2017.03.0460 (Mar 31, 2017)

Enhancements:
Improved SSH implementation for Git source control system
Support for Git source control system hosted on Visual Studio Team Services under Azure subscription
Support for connecting to Bitbucket server using the Active Directory account
Improved differences highlighting in the “Differences” section, under the “Action center” tab
The following options are added in the context menu of the “Differences” section, under the “Action center” tab:
Search
Word wrapping
Difference highlighting color settings
Increase/Decrease font size
Fixes:
"Item 'item_name' is obsoleted. Root.Find() must be used to get actual item" error is encountered when creating a sub folder in Team Services repository where a database is already linked
SQL object types additionally included will not appear in the "Action center" tab, after being added from the add-in options
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 in case of using Team Foundation Server 2015
New Team Foundation Server project cannot be created through the add-in wizard in case of using Team Foundation Server 2017
The add-in can be uninstalled only from the file path where it was installed the last time
The information about SQL users are shown in the "Object status" form after applying changes against a database even when the status of an object is not changed
The CLI feature of the add-in does not work with pre-defined settings
Inappropriate error message when linking a database to a local folder, if the repository is not initialized
Inconsistency in change sets ordering in the "Project history" form
Warning message in the “System login” step of the source control wizard is not in focus when the non-existing project name is specified under the Git repository
Differences are not properly shown in the "Differences" section when a NOT NULL constraint is added for a SQL table
The add-in does not generate the same script in case of applying the same change through the "Action center" tab and through the "Project history" form
Differences are highlighted on one side only in the “Action center” tab, when a column is renamed
Missing informative message in the "Action center" tab that changes are detected, after including/excluding SQL schemas in the "Object filtering" tab from the add-in options
Inappropriate warning message when one of the additional database object that the add-in uses is missing
Inappropriate message when trying to connect to the Team Foundation Server repository in case the URL is not correctly specified
The filter row in the "Database change log" form filters only items that starts with the specified hint
Username and password fields are required in the “System login” step of the source control wizard, when working with local repository
The "Action center" toolbar command refreshes the "Action center" tab when clicked, if the "Action center" tab is active
Inappropriate differences highlighting in the “Action center” tab, when working with custom scripts
"Database changes detected" message appears in the "Action center" tab after closing the "Options" form, even if no changes were made
Inconsistent naming of the objects in the “Object filtering” tab and in the “Action filter” window
Incorrect icon and message are shown when creating a new project inside the Mercurial repository
Missing filter combo box for the Schema field in the “Database” section under the “Object filtering” tab
Inappropriate message when connecting to a Git repository if incorrect credentials are specified
Inappropriate message when linking a database to a Git repository and specifying incorrect repository address
Inappropriate message when connecting to a local Subversion repository when specifying incorrect password
Filtering for the "Key" column does not work in the "Static data" form
The filter row inside the "Static data" form works only for values that starts with the specified hint
The "Migration scripts" form is initiated even when there are no migration scripts specified
Missing progress bar when applying changes from source control to database
"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 from source control to 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 options
"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 appears when trying to commit a change made by another user in the shared model
Inappropriate message when undoing changes made against multiple objects at once in the “Action center” tab
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 shortcut for the "Object status", while a database in the "Object Explorer" pane is linked in 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" option will reset upon restarting SQL Server Management Studio
The “Project history” form does not work as expected when multiple databases are linked to the same Subversion repository
The “Object filtering” step in the source control wizard does not properly export/import settings object selection
Running instance of SQL Server Management Studio stopped working when installing the add-in
The add-in options from the Object Explorer context menu are disabled until clicking on another node and back
"Cannot drop database "ApexSQL_SourceControl" because it is currently in use." error is encountered when linking a database on SQL Server 2005
The add-in fails to apply static data changes if there are differences in the identity column
Script execution results cannot be copied from the “Script execution results” window
“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 column from NULL to NOT NULL will not be detected by the add-in
The "Initializing" progress bar will not disappear when applying changes using the alternative synchronization engine
The "Apply" button is disabled after filtering objects in the "Action center" tab
"Cannot open database requested by the login. The login failed" error is encountered after the add-in upgrade process
"Invalid object name 'information_schema.schemata'." error when linking a database on SQL Server 2005
Warning about uncommitted changes appears twice on SQL Server Management Studio exit
A conflict occurs in the shared model, in case of 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 SQL 2005 database
The process where the add-in is checking if a database is offline, before initiating the source control wizard, cannot be finished when the currently connected SQL user does not have sufficient permissions against a database
The information about minimal permissions required for the shared model in the source control wizard is not appropriate, in case there are no linked databases
Capitalization differences in SQL schema name cannot be 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 database on SQL Server 2008 R2
"Exception: Object creation failed: : Unclosed quotation mark after the character string '[ApexSQL]'." error is encountered when linking a database in the shared model
"Table 'table_name' not found" error is encountered when applying changes from source control to database, in case the synchronization script includes dependent objects that are not included in version control
"SELECT failed because the following SET options have incorrect settings: 'ANSI_PADDING'." error is encountered when the add-in DDL trigger exists on a 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 in the shared model
"Cannot access destination table 'table_name'." error is encountered when applying static data from the repository against a database
Custom scripts remain in the “Action center” tab after committing, although they are properly committed 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 "Refresh" button does not follow the resizing changes of the "Choose project" dialog, when linking to Team Foundation Server repository
The "Action center" tab will not be refreshed after switching between linked databases in the "Object Explorer" pane and using the "Action center" toolbar command
Migration script item will be replicated in the “Action center” tab, each time the user tries to apply only a migration script from source control to database
"Object Schema [guest] is ignored: object already exists." error is encountered when applying schema changes from source control to 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
Database cannot be linked in the shared model without the VIEW ANY DEFINITION permission on a server level
The “Migration scripts” feature is not working
SQL Server Management Studio is not responding after applying static data from source control to database
"Changes were not applied" error is encountered when applying source control label to database
"The user does not have sufficient permissions to link databases as shared" error when trying to use the “Import connections” feature for 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
"The ALTER TABLE statement conflicted with the FOREIGN KEY constraint" error is encountered when trying to apply static data changes from source control to database
"Test succeeded" message appears when testing the SSH connection with the URL that is generated for the HTTP connection, in case of linking a database to a Git repository
"Source control error: Failed commit! Error Exception caught during execution of push command" error when trying to commit changes to a Git repository in case the HTTP URL is specified instead of SSH
"Database is already linked in the dedicated model" message appears when trying to link a database in the shared model from the second machine, if it was already linked in the shared model
"Source control error: Provided local path doesn't exist" error is encountered when trying to get specific version of an object from history
The "Project history" form closes when trying to apply changes, in case the Subversion project is nested
Static data is not visible in the history, after it is committed to source control
Inappropriate message in the "Migration scripts" form
"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 on the same SQL Server instance on the same Team Foundation repository where another database is already linked
"Database could not be detected as it is linked. Make sure that the user has linked a database to source control" message is excessive in the add-in trigger script
Changes:
Support for SQL Server Management Studio 2008 and 2008R2 integration has been deprecated
The application now requires Microsoft .NET framework 4.5

New in ApexSQL Source Control 2017.02.0376 (Feb 7, 2017)

New in ApexSQL Source Control 2017.01.0366 (Feb 7, 2017)

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

New in ApexSQL Source Control 2016.04.0259 (Sep 23, 2016)

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:
Team Foundation Server projects cannot be created on the root repository if Team Foundation Server 2015 is used
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

New in ApexSQL Source Control 2016.03.0208 (Jun 7, 2016)

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

New in ApexSQL Source Control 2016.02.0190 (Apr 27, 2016)

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

New in ApexSQL Source Control 2016.01.0139 (Jan 7, 2016)

Enhancements:
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

New in ApexSQL Source Control 2015.10.0121 (Oct 20, 2015)

New in ApexSQL Source Control 2015.09.0112 (Aug 27, 2015)

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

New in ApexSQL Source Control 2015.08.0098 (Jul 7, 2015)

New in ApexSQL Source Control 2015.07.0093 (Jun 19, 2015)

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
Mapping static data from the “Manage static data” form is now 3,400% faster
Mapping 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 the 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)

New in ApexSQL Source Control 2015.06.0087 (May 9, 2015)

Enhancements:
The add-in now supports source controlling of static data
Export / import object change tracking settings is added
Performance improvements:
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

New in ApexSQL Source Control 2015.05.0076 (Apr 10, 2015)

New in ApexSQL Source Control 2015.04.0072 (Mar 26, 2015)

New in ApexSQL Source Control 2015.03.0065 (Feb 28, 2015)

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
Added option to prevent objects from being edited if locked\checked out
Added option for development policies
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
Added option to exclude objects from monitoring by type, schema and name
Added option for logging changes made to the database schema
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 crash 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 will crash if incorrect Perforce credentials were used during the database linking process
"Timeout Expired" error is thrown when linking large database to Subversion during object mapping 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 mapping database to a previously created workspace after un-mapping 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

New in ApexSQL Source Control 2015.02.0048 (Feb 28, 2015)

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

New in ApexSQL Source Control 2015.01.0039 (Jan 10, 2015)

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

New in ApexSQL Source Control 2014.01.0031 (Jan 10, 2015)

New in ApexSQL Source Control 2014.01.0030 (Jun 6, 2014)

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
Fixes:
The add-in cannot add and map all selected objects to a source control while leaving a database in non-linked state
The "Check out" feature works very slow and brings SQL Server Management Studio occasionally in non-responding state while the "Progress info" dialog disappears from the screen occasionally
The "Default" button from the "Options" dialog must be named as "ApexSQL default"
The "System.OutOfMemoryException" error is encountered in SQL Server Management Studio when mapping objects of a large database to a 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 a source control
The SQL foreign keys are lost when a table connected to a source control is edited
Objects connected to a 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 " dialog and an object will stay in the checked out state
The add-in will check in an object to a 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 the 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 \Options.xml because it is being used by another process." error is encountered when multiple SQL Server Management Studio instances are opened
The "Check in", "Check out" and "Edit changes" options will not be committed on Apache Subversion server
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

New in ApexSQL Source Control 2013.01.0022 (Jun 29, 2013)

Enhancements:
Add-in now supports TFS 2012
Add-in now supports Vault 6.1
Fixes:
"Database vs Source Control" and "Database Mapping 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 mapping status report" is shown when using the 'Mapping 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 mapping 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 " 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

New in ApexSQL Source Control 2012.02.0019 (Apr 18, 2013)

New in ApexSQL Source Control 2012.02.0018 (Apr 10, 2013)

New in ApexSQL Source Control 2012.02.0016 (Mar 13, 2013)

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 mapping 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 mappings" 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 mapped 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 mapping" 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 mapped 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 mapped to its appropriate subfolder
The "access to the path 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 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 mappings" 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