Specify tables to compare up front
We frequently bring data from production databases to staging and development environments, it involves around 120 tables , but to start with we want to pick 3 or 4 huge tables(rows ~ 3 million) and see how much time it will take to do data comparison and deploy differences, instead of copying down entire tables.Also please see if you can develop the functionality of selecting a list of tables for comparison before registering entire databases.
Cliff Clapham-Steele commented
I believe this feature to be an important one for those users where the number of tables i the schema is significant e.g. applications such as PeopleSoft, e-Business etc.
How this filtering/selection is actually specified by the user is very important given that the schemas we are talking about may contain 60,000+ tables.
In my view the most flexible approach to this would be to allow a user specified WHERE clause. I would certainly like the ability to include/exclude tables based on a variety of criteria e.g.
1. Table name prefix/suffix or substring (REGEXP match)
2. Tablespace i.e. I would like to include/exclude all tables in a given set of tablespace(s)
And many others .... :-)
I edited your idea with information from your forum post to give others some context and allow them to more easily add support for it. Do let me know if this doesn't quite capture any part of your idea.