I am using the data compare functionality on hundreds of tables in a database. Toad is showing many tables where I need to define the comparison keys. All the destination tables are empty so I really see no reason I have to spend many minutes clicking continuously defining those keys. Toad doesn’t need to really compare any data. Just copy the data from the source tables to the destination tables. If I don’t define the keys, it seems Toad will skip those tables.
Is there a way to not go through the process of defining the keys and just go ahead and copy the data?