Any compare object tools for two database comparison

Posted on 2006-04-24
Last Modified: 2008-02-01
Hello all.  I am looking for a way to compare all procs in once database to all procs in another.  Is there an easy way or tool out there to handle this?  Specifically I want to check for any missing procs on one database to another but there are many.  Thanks all
Question by:sbornstein2
    LVL 75

    Accepted Solution

    I'd suggest using a 3rd party tool like RedGate's SQL Data Compare -
    Apex db compare etc

    freeware tools
    Compare SQL Server Databases with sp_CompareDB
    database_comparison_sp.asp" target="_blank" onclick="return openNew(this.href);">
    LVL 27

    Expert Comment

    There is also Starinix software

    Free database compare

    Author Comment

    Thanks guys

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    746 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

    19 Experts available now in Live!

    Get 1:1 Help Now