List of missing tables

rosbornrosborn Posts: 5
edited January 3, 2006 12:23PM in SQL Data Compare Previous Versions
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.
· Share on Twitter

Comments

  • 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')
    · Share on Twitter
  • rosbornrosborn Posts: 5
    Excellent. Thanks very much. I love the product.
    · Share on Twitter
  • 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.
    · Share on Twitter
This discussion has been closed.