| SyncSchema |
This tool calculates the difference between two database schemas
This is an example of how it can be used
try {
SyncSchema s = new SyncSchema();
s.setSourceDriverString("oracle.jdbc.driver.OracleDriver");
s.setSourceConnection("jdbc:oracle:thin:@xxx.com:1521:source");
s.setSourceUser("source");
s.setSourcePassword("test");
s.setSourceSchema("MySchema");
s.setTargetDriverString("oracle.jdbc.driver.OracleDriver");
s.setTargetConnection("jdbc:oracle:thin:@xxx.com:1521:target");
s.setTargetUser("target");
s.setTargetPassword("test");
s.setTargetSchema("MySchema");
s.setTableFilter("A%");
s.process();
Collection l = s.getTables();
for(Iterator i = l.iterator(); i.hasNext(); ) {
SyncSchema.Table t = (SyncSchema.Table) i.next();
System.out.println("Schema:" + t.getSchema() + ", Table:" + t.getName() + " (" + t.getType() + ") [" + SyncSchema.getSyncName(t.getSyncStatus()) + "]");
if(t.getFields() ! |