Options

List of missing tables

rosbornrosborn Posts: 5
I have discovered, as many others apparently have, that some tables are not included in data comparisons (those without primary keys). Is there a way to get a list of the tables that were not included? If not, that would be a great new feature.

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello,

    Yes, we should be handling this much more gracefully in a future version.
    In the meantime, you can find out at least which tables in a database do not have a primary key using a SQL query...
    select name from sysobjects where xtype='U' AND id NOT IN (select b.id from sysobjects a INNER JOIN sysobjects  b on a.parent_obj=b.id WHERE a.xtype='PK')
    
  • Options
    Excellent. Thanks very much. I love the product.
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi,

    We are working on this for a future version. We will show tables that couldn't be selected, but they will not do anything when you select them and bear a caption saying that they could not be compared.
This discussion has been closed.