Released: Aug 26, 2016

Updates in this release

Updates in SQL Source Control 5.2.3

• Additional logging for errors during get latest when your repository contains migration scripts.
• SOC-7874, SOC-7878: SQL Source Control will clean-up temporary tables used when registering a database.
• Improved error handling and logging when generating a deployment script in Get Latest.
• SC-8854: Prevented a crash that could occur when registering a scripts folder containing a function with a complex series of aliases.
• SC-8042: Add check to avoid putting default permission for user defined types twice in the permission list.
• SOC-8098: An error when getting the last cached date no longer causes commit/get latest to fail.
• SQL Source Control better handles errors when committing migration scripts.
• SC-8722: SQL Source Control now registers permissions on sequence objects.
• SC-8668: SQL Source Control no longer generates incorrect creation script for objects using WITH ENCRYPTION option when AS keyword not specified.
• SC-8421: Dependencies now correctly calculated from ALTER SCHEMA statements.
• SC-8777: Data compression differences now picked up when Ignore filegroup, partition scheme and partition function option used.
• SC-8735: Default values for parameters of type BINARY can now be registered from live databases.
• SOC-7590: Fixed an error generating a deployment script during get latest when your repository contains migration scripts.
• SOC-7590: Linking to a folder without permission no longer causes an error.
• SOC-8162: SQL Source Control supports the use of Beyond Compare v4 as a merge tool.
• SOC-8142: SQL Source Control no longer errors when working with databases using Turkish collations
• SOC-7590: SQL Source Control no longer fails to generate a deployment script for new migration scripts.
• SC-8831: SQL Source Control no longer fails to parse stored procedures containing the undocumented 'LINENO' keyword
• SC-8099: The ignore whitespace option now correctly ignores non-breaking space characters.

Notes before you update:

• The new migrations solution replaces all previous versions.
  • Migration scripts created using previous versions of SQL Source Control won't be compatible with SQL Source Control 5.
  • To make sure any existing migration scripts aren't lost, see product documentation before you update to SQL Source Control 5.
  • To deploy SQL Source Control 5 migration scripts using SQL Compare, you'll need SQL Compare version 11.6 or greater.
• The following version control systems are no longer supported:
  • Vault Standard or Vault Professional 5 or 6.
  • Team Foundation Server 2005.
• SQL Server 2005 (RTM, SP1, SP2, SP3 and SP4) are no longer supported.
• SQL Source Control no longer works with SQL Server 2000 databases.