How can we help you today? How can we help you today?

Most of the tables are missing during compare

Hi:

I dont' know what would cause such problem, 9 out of 10 tables in the database I'm comparing are not showing up for comparison. Only the dt_property table shows up. I tried to do a comparison between the same database and it's not showing anything else. Any ideas? I even downloaded the newest version of the SQLBundle today and still did not do anything.

Thanx.

David
dchow7
0

Comments

3 comments

Sort by
  • Brian Donahue
    Hello,

    The only reason that the tables would not appear is if they're marked as System-type tables. Can you check Enterprise Manager and see if your tables have been given a system type as the result of some kind of error?

    Converselt, all of the dt_* tables (exc dtproperties for some reason) should be marked as system tables and NOT show up in SQL Compare. It sounds like the tables are marked backwards: system tables marked as user tables and vice versa.
    Brian Donahue
    0
  • dchow7
    HI Brian:

    I checked all the tables and all the ones created by us are under "user-type". dtproperties is actually marked as "system-type" along w/ all other sys..... tables.

    Any ideas? I can send you some screen shots, but I don't know how to attach files to this message board.

    Thanx.

    David
    dchow7
    0
  • dchow7
    I meant to post this into the Sql Data Compare section. Is this ok?
    dchow7
    0

Add comment

Please sign in to leave a comment.