Compare

Compare-DbaAgReplicaSync

the dbatools team + Claude

Compare-DbaAgReplicaSync View Source the dbatools team + Claude Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Compares server-level objects across Availability Group replicas to identify synchronization differences. Description Compares server-level objects across all replicas in an Availability Group to identify differences that would prevent seamless failover. Availability groups only synchronize databases, not the server-level dependencies that applications need to function properly after failover.

Compare-DbaDbSchema

the dbatools team + Claude

Compare-DbaDbSchema View Source the dbatools team + Claude Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Compares the schema of a DACPAC file against a target database or DACPAC file using sqlpackage. Description Uses sqlpackage’s DeployReport action to compare a source DACPAC against a target (live database or DACPAC file) and returns a structured list of schema differences. The source must be a DACPAC file.

Compare-DbaLogin

the dbatools team + Claude

Compare-DbaLogin View Source the dbatools team + Claude Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Compares SQL Server logins between a source and one or more destination instances. Description Compares SQL Server logins between a source instance and one or more destination instances to identify which logins exist only on the source, only on the destination, or on both.