SQL Compare 15

Which objects can be compared?

SQL Compare supports comparison and deployment of database-level objects.  This includes the following object types:

  • Assembly

  • Asymmetric Key

  • Certificate (Comparison only, see Understanding the comparison results
  • Contract
  • DDL Trigger
  • Default
  • Extended Property
  • Event Notification
  • Full Text Catalog
  • Full Text Stoplist
  • Function
  • Message Type
  • Partition Function
  • Partition Scheme
  • Queue
  • Role
  • Route
  • Rule
  • Schema
  • Search Property List
  • Security Policy
  • Sequence
  • Service
  • Service Binding
  • Stored Procedure
  • Symmetric Key
  • Synonym
  • Table (including indexes, constraints, and filegroups)
  • User
  • User Defined Type
  • View
  • XML Schema Collection
  • External File Format
  • External Data Source
  • External Table



Didn't find what you were looking for?