Can TOYS correctly synchronize all Oracle databases?
The fundamental principle that TOYS (and other synchronization tools) are based on is that the data model is “static” [or mostly so]. This means that objects are constructed “as designed”. Some applications allow end users to “configure the system” recording this configuration in meta tables and then generate objects from this meta-data. These “dynamic” schemas will never agree with any reference model. Futhermore, there is no standard for recording this user defined meta-data thus making it very difficult [if not impossible] to compare the “dynamic” parts of these schema with anything. The best that can be hoped for, is to “filter out” these dynamic objects and compare the static parts. Currently, TOYS does not facilitate any form of “filtering” of objects. The generated synchronization script will attempt to drop all these generated objects. As an interim work-around you could remove these drop commands [manually] from the script but we would not recommend that you use TOYS to attemp
