Script folder comparison doesn't work for non-dbo schema

dschaeff

Tables and stored procedures in a non-dbo schema are not being categorized as either different or identical when comparing a script folder to a database. Instead they show as both existing only in the script folder and existing only in the database.

Simon C

Have you got schema objects corresponding to the non-dbo schemas in the script folder? SQL Compare can only match up schemas if there is also a corresponding schema object. You can also check the schema mappings are ok (Edit Project -> Mapping tab)

Simon C

dschaeff

Thanks Simon for your reply. After scripting the schema into a file into my scripts folder SQL Compare worked like a charm. This allows me to determine what source code as maintained in our source control system (Team Systems) is out of whack with our database. The answer is an alarming amount. Now to reconcile these differences...