What are the challenges you face when working across database platforms? Take the survey

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

dschaeffdschaeff Posts: 12
edited April 16, 2009 11:40AM in SQL Compare Previous Versions
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.


  • Options
    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
  • Options
    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...
Sign In or Register to comment.