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.
From the initial request it seems as if you want to compare a few tables only, You can do that in the project wizard “Tables&Views” tabs.
For more advances where clause based selections that is a new feature.
Which did you mean?
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 .... :-)