Can we compare two DataBase Schema? [Resolved]

Posted by Amatya under Others on 2/16/2016 | Points: 10 | Views : 584 | Status : [Member] | Replies : 3
How to compare two different database schemas?

Feel free to share informations 9731764134
mail Id ' adityagupta200@gmail.com
Thanks



Responses

Posted by: Rajnilari2015 on: 2/16/2016 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
@Amatya Sir,

SQL Server Data Tools (SSDT) includes a Schema Compare utility. Please check out this link ( http://blog.dbi-services.com/sql-server-2012-sql-server-data-tools-ssdt-schema-and-data-comparison/ ) for a step by step guidance.

Alternatively, for 3rd parties, you can try with

a) DBComparer ( http://dbcomparer.com/ ) (Free)

b) SQL Admin Studio (http://www.simego.com/Products/SQL-Admin-Studio ) (Free).[ Allows to SQL Compare and Synchronise, Data Compare and Synchronise ]

c) Open Diff (http://www.ginktage.com/2012/04/open-dbdiff-for-sql-server-2008/ ) (free)

Not free

d) Red-Gate's SQL tool ( http://www.red-gate.com/products/sql-development/sql-compare/ ) and ( http://www.red-gate.com/products/sql-development/sql-data-compare/ )

Hope this helps

--
Thanks & Regards,
RNA Team

Amatya, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Amatya on: 2/17/2016 [Member] Silver | Points: 25

Up
0
Down
I should wait for a weekend to come to go through it.. I just saw the links it has lot of information to explore
Thanks Buddy Rajnilari2015 :)

Feel free to share informations 9731764134
mail Id ' adityagupta200@gmail.com
Thanks

Amatya, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nathan4 on: 2/2/2017 [Member] Starter | Points: 25

Up
0
Down
The post is resolved already but I'd like to share the tool I use - https://www.devart.com/dbforge/sql/schemacompare/
It allows to work with live SQL Server databases, snapshots, and backups fast and easily!

Amatya, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response