Schema's SQL 2005

tobitobi Posts: 4
edited June 14, 2007 8:57AM in SQL Data Compare Previous Versions
Hi,

I have sync 2 DB's that have schemas dbo, Time & Approval. When doing a data diff the tables in the Time and Approval Schemas do not map properly and cannot be compared.

please can you help?

regards

toby
· Share on Twitter

Comments

  • Daniel HandleyDaniel Handley Posts: 214
    Hi Toby

    If the schemas are identical then the mappings should be fine.
    i have tried to replicate your problem but can only do so if the schemas are differant.

    Can you try to use SQL compare to check the schemas?

    Regadrs
    Dan
    Daniel Handley
    Red Gate Software Ltd
    · Share on Twitter
Sign In or Register to comment.