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

List of missing tables

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.
rosborn
0

Comments

3 comments

Sort by
  • Brian Donahue
    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')
    Brian Donahue
    0
  • rosborn
    Excellent. Thanks very much. I love the product.
    rosborn
    0
  • Brian Donahue
    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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.