I'm working with a system where each customer has their own database.
This amounts to ~4000 databases (approximately 150 tables each database) spread over 8 instances of Microsoft SQL server 2012.
The database scheme for all these databases is supposed to be identical, but recent events has shown that there are minor deviations in data types, indexes, keys and nullable/default value settings in some of the databases.
My goal is to synchronize all database schemas so they all have identical tables, columns, indexes, keys and nullable/default value settings
I have a single database that I'm certain has the 100% correct database schema.
How could I compare this database scheme to others, in an attempt to find variations in keys, indexes, tables, columns and nullable/default value settings?
I've read this question which is similar to mine, but the suggestions (like right clicking the database object in SSMS to generate a script or generating and comparing a .dacpac file with the Visual Studio extension SSDT) seems to be oriented towards comparing only two databases, and is not practical for comparing 4000 database schemas.
