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.
Anonymous
shared this idea
You can now use Ignore Rules to specify what tables to include/exclude in your comparison – https://documentation.red-gate.com/dco5/setting-up-the-comparison/using-ignore-rules.
You also have the ability to specify what tables and WHERE clauses, if needed:
- https://documentation.red-gate.com/dco5/setting-up-the-comparison/selecting-tables-to-compare
and
- https://documentation.red-gate.com/dco5/setting-up-the-comparison/filtering-the-comparison-with-a-where-clause
Please let me know if you have any questions. Thank you!
-
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 .... :-)
-
Anonymous
commented