Tables missing in list of tables

terry sandersonterry sanderson Posts: 3
edited February 9, 2005 5:20AM in SQL Data Compare Previous Versions
Both SQL servers/databases have been synchronized using SQL Compare but when running SQL Data Compare there are tables missing from the list of tables to synchronize.

Am I doing something wrong, or is this a SERIOUS bug?
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Terry,

    This could happen if you are either ignoring indexes in SQL Compare, or ignoring the names on constraints and indexes. Data Compare actually tries to match the constraints and indexes by name when verifying that an eligible comparison key index exists in both databases.

    Changing the 'ignore indexes' and/or 'ignore the names of constraints and indexes' settings in SQL Compare and synchronizing the schema will fix the problem.
    · Share on Twitter
  • terry sandersonterry sanderson Posts: 3
    I found that the problem was there was no primary key (Access programmers :o) )

    Thanks!
    · Share on Twitter
This discussion has been closed.