compare_schemas
Compare database schemas between two SQL Server databases to identify differences in tables, columns, and indexes. Pinpoint schema drift for dev vs prod alignment.
Instructions
Compare schemas between two databases — shows tables, columns, and indexes that differ (useful for dev vs prod comparison)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Schema filter (default: compare all schemas) | |
| server | No | Target server name (uses default if omitted) | |
| source_database | Yes | Source database name (e.g. 'DevDB') | |
| target_database | Yes | Target database name (e.g. 'ProdDB') |