compare tables

Compares and synchronizes MySQL database schemas.

Moderators: Chris Auckland, eddie davis, Michael Christofides

compare tables

Postby andraandrada » Wed May 07, 2014 12:21 pm

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.
Last edited by andraandrada on Mon May 12, 2014 11:52 am, edited 1 time in total.
andraandrada
 
Posts: 1
Joined: Wed May 07, 2014 12:15 pm

Postby eddie davis » Fri May 09, 2014 3:21 pm

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
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to MySQL Compare

Who is online

Users browsing this forum: No registered users and 0 guests