question

askmlx121 avatar image
askmlx121 asked

Query/scripts comare in SQL

Hi, We have a two server live and dev Every day i have to **compare the scripts are same or not in live and dev server**. Is their any tools to **dictate the changes of scripts of two scripts** available in SQL ??
tsqlscript
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
eghetto avatar image
eghetto answered

- https://www.red-gate.com/products/sql-development/sql-compare/

- Compare and Synchronize Database Schemas (Visual Studio)

- http://opendbiff.codeplex.com/

- http://www.wintestgear.com/products/MSSQLSchemaDiff/MSSQLSchemaDiff.html

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Lukasz8519 avatar image
Lukasz8519 answered

if you have visual studio you can check if 2 scripts on different servers are equal, or you can use kdiff, which check if this 2 files are binary equal

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.