Red Gate forums :: View topic - compare tables
Return to RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
MySQL Compare
MySQL Compare forum

compare tables

Search in MySQL Compare forum
Post new topic   Reply to topic
Jump to:  
Author Message

Joined: 07 May 2014
Posts: 1

PostPosted: Wed May 07, 2014 12:21 pm    Post subject: compare tables Reply with quote

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
Back to top
View user's profile Send private message
eddie davis

Joined: 14 Jun 2006
Posts: 940
Location: Red Gate Software

PostPosted: Fri May 09, 2014 3:21 pm    Post subject: Reply with quote

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 Davis
Technical Support Engineer
Red Gate Software Ltd
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2005 phpBB Group