Any method to find Compare databases are identical

ArifRamzan · July 3, 2007 10:46AM

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]

Eddie D · July 3, 2007 11:04AM

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

JonathanWatts · July 3, 2007 11:19AM

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

ArifRamzan · July 4, 2007 9:49AM

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

JonathanWatts · July 5, 2007 6:39AM

Hi there,

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

Regards,

Jonathan

Any method to find Compare databases are identical

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk