SQL Toolbelt - 包括 SQL Change Automation v4.1

从 Microsoft SQL Server Management Studio 开发静态数据更改。
1月 9, 2020
新版本

特性

Updates in SQL Change Automation SSMS 4.1 (available as part of Redgate SQL Toolbelt)

  • SQL Change Automation in SSMS now supports configuring and generating migrations for static data.
  • Added support for SQL Compare option IgnoreDynamicDataMasking via configuration SyncOptionIgnoreDynamicDataMasking in project file.
  • Added the ability to use a SQL Source Control project as a development source. SQL Change Automation will compare the contents of your SQL Change Automation project against the SQL Source Control project in order to generate new migration scripts.
  • Can now raise an error during build for unnamed primary key constraints in addition to existing unnamed constraint scenarios to produce deterministic comparison behavior.
  • Creating a new database is no longer an option when setting up a baseline.
  • Added the ability to specify which columns in static data tables should be tracked.
  • Redesigned connection dialog.
  • The default operation timeout is now increased to 5 minutes.
  • Updated SQL Compare Engine to 14.1.8.14375.
  • Added support for SQL Compare option OnlineIndexBuild.

修补程序

Fixes in SQL Change Automation SSMS 4.1 (available as part of Redgate SQL Toolbelt)

  • SCA-2654: You can now generate migrations with over 1000 changes and baseline from databases with more than 1000 programmable objects.
  • Fix for some circumstances where the out of process component of SQL Change Automation in SSMS could not be communicated with without running SSMS as an administrator due to permissions with certificates.
  • The out of process component of SQL Change Automation will now attempt to re-create its certificate if it could not be read.
  • Fixed a performance issue on the static data page when repeatedly opening and closing the add tables panel.
  • SCA-2656 - Apply action no longer executes baseline scripts against a populated development database.
  • SCA-2653 - The default Filter.scpf filter file now gets picked up immediately if added to the project root, if no custom filter file is specified.
  • SCA-2667 - The baseline script now includes partition schemas and functions when the SyncOptionIgnoreDataspaces is turned off.
  • SCA-2655 - The generate migrations page is now responsive when there are large amounts of changes.
  • Refresh no longer fails with an error if a baseline script is generated and then deleted - this validation will still produce an error on verify.
SQL Toolbelt - 包括 SQL Change Automation v4.1
Column-level control of static data tracking.

SQL Toolbelt

进行比较、同步、备份、分析等功能的 SQL Server 各种工具的集合。

索取报价 立即购买

有任何疑问吗?

透过Live Chat与我们的Redgate Software 专家联络!