compare tables
andraandrada
Posts: 2
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.
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.
Comments
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com