compare_schemas
Compare schemas between two SQL Server databases to identify differences in tables, columns, and indexes, supporting dev vs prod analysis.
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 |
|---|---|---|---|
| source_database | Yes | Source database name (e.g. 'DevDB') | |
| target_database | Yes | Target database name (e.g. 'ProdDB') | |
| schema | No | Schema filter (default: compare all schemas) | |
| server | No | Target server name (uses default if omitted) |