how to compare table definations only?

light_wtlight_wt Posts: 4
edited September 26, 2008 4:57AM in SQL Compare Previous Versions
Hi, :)

i am comparing two databases with tables that has different def, i.e. one column is a smallint and the other database has that column as an int.

can the tool show only the difference on columns in tables? :?: i.e., i am not concern about the ownership, or grant statement, and etc. i am focused on the difference of the columns of tables from the two different db.

thanks.

Comments

  • is there another product or script out there which will do that? to compare only the datatype on columns of two tables from two database...

    thanks.
  • SQL Compare will compare all the differences between two tables - the columns, constraints, foreign keys, triggers...

    There are various options that let you ignore parts of the table (eg ignore triggers, or ignore indexes), but it will always compare the core table definition - the columns and datatypes
  • what is the option to set to limit the comparison down to only the columns between tables? :?
    i.e. i don't care about the trigger, owner, and etc.

    Thanks! :D
  • Most of them turn off various properties of objects. The ignore options you probably want on are:
    indexes
    permissions
    dml triggers
    full-text indexing
    statistics
    foreign keys
    bindings
    filegroups, partition schemes, partition functions
    authorization on schema objects

    You may want some of the others, as well (eg check constraints or constraint and index names) depending on your needs.
Sign In or Register to comment.