Filters for the "Tables & Views" tab
Filters for the "Tables & Views" tab
When working with databases that contain thousands of table, it takes so long to generate the list of tables and views that data compare is practically useless. It would be great if when you click the "Tables and Views" tab, it would not automatically try to retrieve the entire schema list, but rather give you the option to specify a filter for schema and/or object name and then click a button to build the list on demand. So when you only nee to sync one, or a few tables, it could retrieve the filtered list of objects very quickly.
Michael Psencik
shared this idea
Thanks for all the feedback on this suggestion. The team will take the item under review and we’ll update here with next steps.
-
Anonymous
commented
Im surprised that this is even in here because I would suspect big corporations will struggle without this and that must be a decent revenue earner
-
Mike Richards
commented
this is a must requirement for any compare tool!!!
-
Shawn Reed
commented
Will this ever be addressed? Is there any other mechanism other than voting for the improvement here that might help to make this happen soon? The product has real potential but wont even be considered at my employer because of the amount of time wasted waiting on the product to respond which would be totally eliminated if only this improvement would be made.
-
Anonymous
commented
I agree. I have the same problem. Our ERP has 8000 tables and 36,000 clrs and other objects. DC just grinds and goes no where. If i want to compare 1 table i have export it to another db before i can use DC. I just spent 2 hours on what should have been A 5 minute job.
-
Shawn Reed
commented
PLEASE add this feature !!! As Michael stated the product is practically useless in environments with thousands of tables in a database.
-
Robert Myers
commented
I agree something similar to a TABLEDIFF utility with the option of filtering the data. The point would be to only compare one object to another. If I could effectively filter data or add criteria to the TABLEDIFF utility, I would never have a need for the tool at all. It takes too much time and always errors out when trying to read through the tables in our main database, so the Red Gate data compare tool is really ineffective for us at this point.