Compare Tables/Procedures

Posted on 2009-12-28
Last Modified: 2012-05-08
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  


Question by:anushahanna
    LVL 57

    Accepted Solution

    Yes.. Few tools below

    1. Apex SQL Diff (
    2. Red Gate Compare (
    LVL 60

    Assisted Solution

    SQL Compare from Red Gate is a great, great tool.  Give it a shot.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now