Comparing Columns in SQL Server

Posted on

Question :

Good afternoon!

I wonder if you can help me. I have the following case, we have a client that has the version of our system VERY outdated, with this is missing several columns in SQL tables. I was wondering if there is any way I can see all the columns you have in one bank that do not exist in the other to be able to make the necessary changes. I tried searching google but I think it was not being very clear in the search.

If anyone knows how to facilitate this task without having to be in the eye, he would be very happy!
Hugs to all.


Answer :

You can use a tool to compare the databases.

A good one from Red-Gate has a trial version that has 14 days of free license.


This tool is available in two versions:

  • freeware version: Completely free, without any trial period

  • Shareware version with 30 days free trial period, which includes more features.

  • SQLDBDiff version Shareware is the only tool on the market that includes the ability to compare multiple databases to the same master database, all in one operation.

    SQLDBDiff is available in English and French and supports SQL Server 2014, 2012, 2008, 2005, 2000 and SQL Azure.

    All tools on this site are developed with C #, ADO .Net and SMO. These tools are very secure and will not change or create any objects (even temporary) in their databases.

    Microsoft .Net Framework 3.5 is required.


    Leave a Reply

    Your email address will not be published. Required fields are marked *