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

Tables missing in list of tables

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?
terry sanderson
0

Comments

2 comments

Sort by
  • Brian Donahue
    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.
    Brian Donahue
    0
  • terry sanderson
    I found that the problem was there was no primary key (Access programmers :o) )

    Thanks!
    terry sanderson
    0

Add comment

Please sign in to leave a comment.