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の比較、同期、バックアップ、分析などを行うためのツールコレクション

見積もりの依頼 購入

ご質問がありますか？

今すぐ Redgate Software ライセンススペシャリストとライブ チャット。