In this case, Toad can sync the tables with just two SQL statements per table per table - a DELETE and a MERGE. Obviously, this will only be possible if they are in the same database. Fastest - Use the same connection to access the source and target schemas if you can.And which technique Toad will use all hinges on what you do on this first tab. I've optimized both of them as much as I can, but one is much faster than the other. There are two different techniques of comparison that this window can perform. There are some options on the other tabs, but they default to what I think are the most useful settings.īefore we just blaze on though, here are some things that you should know.

To sync data in all (compatible) tables in a pair of schemas, all you really need to do is pick the schemas and click the green triangle at the top. If you want that, then go Database -> Compare -> Data. There is not an option to review the differences first. We're going to synchronize the data in your tables (or at least create a script to do that). The 'Syncronization' group box is here on the first tab, next to the schema selection, so you won't have to go to any of the other tabs to see what will happen when you click the green triangle to run it.

I've made this window as simple as I can. Wouldn't it be nice if you could just point Toad at a couple of schemas and have in sync all (or some) of the data in the tables of those two schemas? Well, now you can! That's fine and good, but if you have lots of tables to compare, you have to set it up for each table, and run each table individually. Toad Expert Edition or DB Admin Module is requiredįor a long time, Toad has had a window that lets you compare table/view/mview data, and Sync it if you have the Toad Professional Edition or DB Admin Module.

Toad for oracle 12.12 download