Compare two table schemas in SQL Server database

1124190 pts.
Tags:
Schema
SQL Server
SQL Server database
Throughout my week, I have to do random checks between a SQL Server development and release database. Usually - this is a manual process but it's quite slow now. Would I be able to compare my different table schemas automatically? Thank you very much.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Check out Microsoft’s solution here.

LINK

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • CharlieBrowne
    You can write a script the will to EXCEPTION JOINS between the 2 DBs.  If there are no exceptions, they are no differences.
    62,385 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: