compare tables

andraandrada

Hi,
I want to compare both tables and give me result from Database1 that does not exist in the Database2 with a specific timestamp query. What I have and tried yet query takes too long to search. How can I do this? Can someone help me?
Thank you.

Eddie D

Thank you for your forum post.

Sadly you cannot filter tables on a specific timestamp.

All objects are compared so that the dependencies between objects can be identified.

Once the comparison results load, the comparison results group the compared objects as follows:

Objects that exist only in database 1 or source database
Objects that exist only in database 2 or target database
Objects that exist in both but are different
Object that are identical

As you only wish to review the tables in database 1, expand the group - 'Objects that exist only in xxxxx'.

You can select a filter down the left hand side to select just the tables but you cannot filter on a specific timestamp.

If you would like to change this behaviour and submit a feature request, please use this LINK to the MySQL Tools User Voice forum.

The user voice forum is actively monitored by the redgate Product Managers. The more votes and comments a topic receives will increase the chances of it being included in a future versions of the product.

Many Thanks
Eddie