A handful of my tables are missing during the data compare

EngTanEngTan Posts: 3
Hi,
I am using your 14-day trial version of "SQL Data Compare" and am having issues with not being able to see all the tables.

I have checked out the forum for possible solutions and have done the suggestions that I have seen on:
--> checking OFF the "Ignore constraints and index names
--> checking ON the "Treat items as case sensitive"
during my SQL Compare sync up. And tables which are missing are identical as far as:
--> primary key or unique index
--> the table names match and have the same owner
--> the column names that the unique constraint is applied to have the same case-sensitive name

I checked the version on SQL Data Compare and it is 3.3.9.14

Can you please let me know where else I should look to pass this issue?

Comments

  • Hi

    The most common reasons for not being able to see all the tables is that the tables do not have a unique index (usually a primary key), or the columns with an index have different names.

    Can you check this please and let us know how you get on.

    Regards
    Dan
    Daniel Handley
    Red Gate Software Ltd
  • Thanks for the quick reply.

    I checked thhose tables and they DO NOT have a primary key or Unique Index. This was strictly by design to meet our application performance level at max. Is there a way in the option to compare the data in those tabel as well???

    Thanks,
  • HI

    Unfortunately there is no way to do this at the moment directly with the tables. You could create an indexed view instead and work with that.

    Regards
    Dan
    Daniel Handley
    Red Gate Software Ltd
This discussion has been closed.