Which objects can be compared?
Published 06 January 2023
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