compare tables

andraandradaandraandrada Posts: 2
edited May 9, 2014 10:21AM in MySQL Compare
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.

Comments

  • Eddie DEddie D Posts: 1,733 Rose Gold 5
    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
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.