Comparing Tables of two databases in MS SqL server

Posted on 2006-03-20
Last Modified: 2008-01-09
I have two different databases on same   MS SQL Server 2000 machine how can i compare the tables and fields on these tables. Kindly suggest me if there is a software to compare the tables as well as the fields of the database.
Question by:Kamran Arshad
    LVL 75

    Accepted Solution

    These are Some tools

    Red Gate -SQL Data Compare
    AdeptSQL Diff
    Best SoftTool -SQLDB Compare
    LVL 9

    Assisted Solution

    And both Redgate and AdeptSQL have free trial versions (non-crippled).
    LVL 7

    Assisted Solution

    You can take a look to:

    If you prefer to do it by your seft try to script the tables and compare the script with some text-file compare software which you can find a lot free.
    LVL 11

    Expert Comment

    sounds great

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Suggested Solutions

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    759 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

    11 Experts available now in Live!

    Get 1:1 Help Now