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

how to compare table definations only?

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

Comments

4 comments

Sort by
  • light_wt
    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.
    light_wt
    0
  • Simon C
    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
    Simon C
    0
  • light_wt
    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
    light_wt
    0
  • Simon C
    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.
    Simon C
    0

Add comment

Please sign in to leave a comment.