Can we compare two DataBase Schema? [Resolved]

Posted by Amatya under Others on 2/16/2016 | Points: 10 | Views : 2032 | Status : [Member] | Replies : 3

How to compare two different database schemas?

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

[Resolved]

Reply | Reply with Attachment

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

0	@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

@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

0	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. 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

0	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

Latest Posts