SQL Compare Pro

Comparez et synchronisez des schémas de bases de données SQL Server.

Publié par Redgate Software
Distribué par ComponentSource depuis 2005

Version : 14.9.x Mise à jour : Aug 10, 2022

Capture d'écran de SQL Compare Pro
i

SQL Compare Pro and SQL Compare Standard are no longer available. Instead Redgate offer a single offering; SQL Compare now available as a subscription license.

Lancements de SQL Compare Pro

Released: May 7, 2019

Mises à jour de 13.7.12

Updates in 13.7.12

  • Fixed - Local objects that share the same name as a dependent object in another database are no longer seen as a dependency.
  • Fixed - SC-10496: Object existence checks no longer appear in the diff view when the "Add object existence checks" deployment option is enabled.
  • Fixed - Issues when running SQL Compare in a non-English locale, including SC-10487 where FILLFACTOR was ignored in scripts folders when running in a Turkish locale.

Released: Apr 29, 2019

Mises à jour de 13.7.11

Updates in 13.7.11

  • Fixed - Error handling statements now in place between assembly drops to ensure we stop as soon as an error is encountered.
  • Fixed - SC-10477: We now deploy changes to partition schemes that are required by partition function changes, even if they would otherwise be ignored because the ConsiderNextFilegroup option is turned off.

Released: Apr 23, 2019

Mises à jour de 13.7.10

Fonctionnalités

  • Role and user modifications will now usually be done within the transaction rather than beforehand (unless they must be done beforehand because of limitations of SQL 2005/8 or full text objects depending on them).
  • Partition Schemes now select their dependencies if Include Dependencies is specified and Ignore Filegroups is turned off. Table drops will generate a High warning if generated.

Released: Feb 4, 2019

Mises à jour de 13.6.14

Fonctionnalités

  • Adds a new option to ignore sensitivity classifications on fields.
  • Additional logging of .NET assembly loading to help investigate SDC-2906.

Correctifs

  • SC-10397: SQL Compare now sets the correct value for NATIVE_COMPILATION when reading from a scripts folder.
  • SC-10398: Fixed a snapshot deserialization crash for case differences in column names between temporal and history tables.
  • SC-10402: Dropping temporal tables with columns that depend on a user defined type no longer throw an...
Lire la suite

Released: Oct 15, 2018

Mises à jour de 13.6

Fonctionnalités

  • SQL Compare now supports comparison and deployment of sensitivity classifications
  • SQL Data Compare options can now be specified with the /datacompareoptions switch when deploying static data through the SQL Compare command line.

Correctifs

  • SC-10264: User defined types that are dependencies will no longer be deployed if the option to include dependencies is not set.
  • The DataFileSet node of the RedGateDatabaseInfo.xml file in a scripts folder has been deprecated and no longer...
Lire la suite

Released: Sep 17, 2018

Mises à jour de 13.5

Fonctionnalités

  • Added support for using SQL Change Automation projects as a data source in SQL Compare.

Correctifs

  • A create index statement with a string literal as a filegroup name will no longer cause a parser error.
  • Fixed the sca2 command-line parameter not being recognised.
  • SQL Compare no longer explicitly deploys default data spaces.
  • SQL Compare command line no longer normalises all line endings to CRLF when adding static data.

Released: Jun 25, 2018

Mises à jour de 13.4

Fonctionnalités

  • Adds an "Ignore Change Tracking" option
  • The "Ignore authorization on schema objects" option now also includes schemas themselves.

Correctifs

  • SQL Compare no longer creates SET statements in the context of creating a scripts folder, when filtered indexes are included.
  • Parse error on AT TIME ZONE with bracketed string literal fixed.
  • Deploying a varchar(4096) column or wider onto a varchar(MAX) no longer gives spurious warning about truncation. Deploying in the other direction gives...
Lire la suite

Released: Jun 4, 2018

Mises à jour de 13.3

Fonctionnalités

  • Supports external language event types, which are now available on Azure.
  • Now handles ADD_SENSITIVITY_CLASSIFICATION and DROP_SENSITIVITY_CLASSIFICATION event types.
  • Command line now includes switches /activedirectory1 and /activedirectory2 to specify the use of Azure Active Directory authentication.

Correctifs

  • "Ignore whitespace" option is no longer applied to string literals.
  • CLR triggers will now be deployed if an assembly they require is rebuilt and Include Dependencies is on...
Lire la suite

Released: Jan 30, 2018

Mises à jour de 13.1.10

Fonctionnalités

  • Handles filegroups defined on a fulltext index.
  • Handles user defined and customized history tables for temporal tables, and will store all history tables in scripts folders.
  • Integrates the Redgate bulk uninstaller.
  • SQL Compare Command Line now runs in 64-bit mode by default.

Correctifs

  • SQL Compare no longer displays a blank warning dialog when asking to overwrite the existing comparison report
  • SQL Compare doesn't duplicate index creation on history tables.
  • SQL Compare can deploy...
Lire la suite

Released: Oct 30, 2017

Mises à jour de 13.1.x

Fonctionnalités

  • Improved logging capabilities
  • SQL Compare now generates a new style of HTML report, to match the reports produced by other Redgate products.

Correctifs

  • SC-9781: SQL Compare can deploy temporal tables from a scripts folder to a live database.
  • SC-8880: Scripts folders can now be in the root of a drive (as long as it is otherwise empty)
  • SC-9775: On the command-line, in the absence of a -reporttype switch, SQL Compare now correctly uses the -report switch to infer the report type...
Lire la suite