Announcement

Collapse
No announcement yet.

Howto compare SQL Server schemas and database table ?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Howto compare SQL Server schemas and database table ?

    Hi All,

    I need to compare database table in my current production DB to see which one is different in order to generate delta (upgrade script)

    Is it possible to create or do it from SSMS to compare two different schema ?

    Thanks.

  • #2
    Re: Howto compare SQL Server schemas and database table ?

    So do you wish to compare just data in two different tables or table definitions? For the former, use except and intersect. For the latter, use a tool like RedGate Sql Compare.

    -vP

    Comment

    Working...
    X