CODEWITHSUNDEEP
sqlsql-servercompare
Mickey Les
Mickey Les

Reputation: 13

Compare 2 Database all rows - different rows = output

i need a little bit help. I have a developer DB (dev_home), in this db are many tables. I need a compare to another DB (real_home).

The Tables are the same, but the table_names not! For example i develop @ dev_home, in the table personal. In this table i've created new field, which are not exist in @real_home DB.

Upvotes: 1

Views: 132

Answers (1)

WorksOnMyLocal
WorksOnMyLocal

Reputation: 1689

There are tools that do this i.e. compare two different instances of a database or two different databases etc .. Such as

Red-Gate's SQL data comparison tool

or

You can also use Microsoft Visual Studio 2015 Community Edition (Free)

Upvotes: 2

Related Questions