Toad World® Forums

Can you send data compare result sets to a view?

I am comparing an Oracle table to a similar SQL Server table. The data compare is successful and includes ‘different records’ in the results.

I would like to continue with data profiling activities, validations, and examine the data closely. Can I send the data compare results to a view?

The only output besides synchronizing the data, is to export the compare to excel. You can examine the differences there.

You can now automate a data compare in TDA 3.0, but the export here is only the summary table and not the detail.

Debbie