Options

Any method to find Compare databases are identical

ArifRamzanArifRamzan Posts: 3
edited July 5, 2007 6:39AM in SQL Compare Previous Versions
Hi,

I want to know that, is there any method in Sql Compare 6 in which I will get the information that the databases which I am comparing is identical or not.

I want this answer as soon as possible.

Thanks in Advance.[/b]

Comments

  • Options
    Eddie DEddie D Posts: 1,782 Rose Gold 5
    Thank you for your post.

    After selecting the two databases you wish to compare, you click on the 'compare now' button. SQL Compare performs the comparison.

    Once the comparison is successfully completed SQL Compare will give you the following results:

    1. Objects that are identical in both databases.
    2. Objects that exist only in data source 1.
    3. Objects that exist only in data source 2.
    4. Objects that exist in both databases but they are different.

    Therefore if you are comparing two databases that are identical, you should see results that informs that all objects are identical.

    Many Thanks
    Eddie

    Eddie Davis
    Red Gate Software Ltd
    Technical Support
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Options
    Hi there,

    If you are refering to the API, then I am afraid that there is no one method to do this. You will have to loop through the differences object and test each database object's DifferenceType in turn to detect where the differences in the database is.

    Regards,

    Jonathan
    Jonathan Watts

    -Project Manager
    -Red Gate Software Ltd
  • Options
    Hi Jonathan,

    Can you provide me the sample application in which you have check that differences and identified that the specified databases are identical.

    Thanks for your quick response.

    Thanks & Best Regards,
    Arif Ramzan Ali
  • Options
    Hi there,

    You can find the SQL Compare API samples at http://www.red-gate.com/support/samples.htm

    Regards,

    Jonathan
    Jonathan Watts

    -Project Manager
    -Red Gate Software Ltd
Sign In or Register to comment.