MySQL Forums :: Workbench - Schema Compare, Diff, Synch :: need help with data sync
need help with data sync
Posted by: satya dixit ()
Date: June 05, 2012 12:45AM
Hi
Need help urgently.
I tried to generate the diff sql script between two databases but what i see is the script file contains only the create statements even if the table exits in the other db and there is a schema diff.
i want a create statement only when the table is absent
and want a statement such as..
"alter table a.t1 add column c1 int(1)"
where t1 exists in database b but just misses the column c1
i need it so that just by looking i shld understand that there is a diff at that level..
Need help urgently.
I tried to generate the diff sql script between two databases but what i see is the script file contains only the create statements even if the table exits in the other db and there is a schema diff.
i want a create statement only when the table is absent
and want a statement such as..
"alter table a.t1 add column c1 int(1)"
where t1 exists in database b but just misses the column c1
i need it so that just by looking i shld understand that there is a diff at that level..
| Subject | Views | Written By | Posted |
|---|---|---|---|
| need help with data sync | 867 | satya dixit | 06/05/2012 12:45AM |
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
© 2013, Oracle Corporation and/or its affiliates