• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • Last Modified:

Compare Tables/Procedures

Is there a good you would recommend as a SQL Server tool that will help to compare for exactness between tables and procs of same name between 2 servers.

For example:
Server1.Database1.Table1 Vs Server2.Database1.Table1
Server1.Database1.Proc1  Vs Server2.Database1.Proc1  

etc

thanks
0
anushahanna
Asked:
anushahanna
2 Solutions
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Yes.. Few tools below

1. Apex SQL Diff (http://www.apexsql.com/sql_tools_diff.asp)
2. Red Gate Compare ( http://www.red-gate.com/products/SQL_Compare/index.htm)
0
 
chapmandewCommented:
SQL Compare from Red Gate is a great, great tool.  Give it a shot.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now