Comparing Columns in SQL Server

Asked

Viewed 206 times

4

Good afternoon!

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

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

sql sql-server comparison

1 answer

1


You can use a tool to compare databases.

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

Or Sqldbdiff

This tool is available in two versions:

  1. freeware version: Completely free without any trial period

  2. Shareware version with 30-day free trial period, which includes more features.

Sqldbdiff Shareware version is the only tool on the market that includes the possibility to compare multiple databases to the same master database, all in a single 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 safe and will not alter or create any objects (even temporary) in your databases.

Microsoft . Net Framework 3.5 is required.

  • I downloaded that Sqldbdiff you said. Perfect guy, that was it! Thanks for the help.

Browser other questions tagged sql sql-server comparison

You are not signed in. Login or sign up in order to post.