How to diff data between 2 tables (in different schemas) which have identical structure with the CART functionality?
Now both database diff and CART diff functionality shows only differences between the DDL.
Also is it possible to generate script to replicate changes so that after executing the changes to destination table, it is identical with the source?
I am using
| Java(TM) Platform | 1.7.0_55 |
| Oracle IDE | 4.0.2.15.21 |
I am already able to use cart to generate script which drops, ddl + sqlldr table from scratch, but this is pretty heavy operation and I would like to see script which e.g. updates only and inserts so that optionally sequence is momentarily disabled (sort of identity insert on).
This type of functionality would be good because it is very time consuming to make update-sql by hand and keep that updated when the ddls change.
/rgrds Paavo