Is anybody usingAPexSQL Data diff 2008 and ApexSQL diff 2010

Posted on 2011-04-20
Last Modified: 2012-05-11
i need help in comparing the two databases
Question by:Cha1tu
    LVL 28

    Accepted Solution

    What, specifically, do you need help with when comparing the databases - just a walk-through of how to do it? If you need some general assistance, the demo video on their site shows a walk-through of the product (it's a marketing video, so it's under the guise of "how easy it is to use", bu the effect is the same - they show you how to do a basic comparison), and that video can be found here:

    If you have some more specific questions, please elaborate and we can do our best to help you.

    I've used this tool before, and though I generally prefer RedGate's tool for the same purpose, they're remarkably similar in functionality and interface.
    LVL 9

    Assisted Solution

    Using ApexSQL is your requirement?

    To compare two database tables and to sync that, I always use "tablediff.exe", An inbuilt tool by sql server.

    It compate two tables from two different databases and writes the Insert/Update and Delete sql queries.

    When you execute those SQLs, thats it....... Your database will be in SYNC.

    An elegant tool from MS SQL Server.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    737 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

    18 Experts available now in Live!

    Get 1:1 Help Now