Tips & Troubleshooting — Compare
Current Limitations
- Schema sync for tables / columns / indexes / FKs is comment-guided today — module objects get CREATE/ALTER T-SQL
- Security principals, permissions, synonyms, sequences, CLR, partition schemes, and filegroups are not compared yet
- Data compare does not remap differently named tables; pairs must share
schema.table - Scripts are generated for review — Compare does not execute them against the target automatically
System Requirements
| Component | Requirement |
|---|---|
| OS | Windows 10/11 or Windows Server 2016+ |
| Runtime | .NET 8.0 (or self-contained package) |
| SQL Server | SQL Server 2016+ |
| Azure | Azure SQL Database, Azure SQL Managed Instance |
| Permissions | Read access to sys catalogs / INFORMATION_SCHEMA / sys.sql_modules; data compare needs SELECT on compared tables |
| Installation | None — single portable .exe |