Toad World® Forums

Avoiding "Extract Schema" while using Data Compare option


#1

I am doing a Data compare between tables of 2 different Database. While doing this using ',Compare Data" option , the process takes a lot of time in EXTRACT SCHEMA step ( screen print attached ).

Is there any way we can avoid this step or any other way to improve the performance


#2

Extract schema is scanning database to get objects detail and do preparation for the next step of comparing data.

How big are your two databases? we would like to get more data like the number of tables, views, are there many of foreign keys and the rough time toad take for Exact Schema? those information could help us to evaluate the possibility to improve performance.

Thanks,

Cindy


#3

In both source and target i have more that 1000 tables. But if i need to compare the data only for 1 table , the extract schema still scans though all the 1000 tables. Is there a way where in i can specify the name of the table before extract schema step so that it only extract the details of that single table and not all 1000 tables.

Thanks

Nikhil P


#4

Now We don’t support that.


#5

Could I suggest an option?

I have a similar annoyance, especially when ‘fine-tuning’ my comparisons (TDP version 4.3, comparing ~400 tables, Oracle to Postgres). If there were a check box to ‘Reuse Schema Cache’ (the statistics that are repeatedly pulled from the data dictionaries) on the second and subsequent accesses, the customer could control when the schema statistics are reused. This checkbox would be greyed-out during the initial schema stats query.

Regards,

David


#6

I have created a enhancement case QAT-13293 to follow it.