Sign up ×  Is there any way to programatically copy across
schema (i.e. tables,functions,views) etc from one database over
to another one. Assuming both are running same versions of DB2.
I found a few utilities like i) db2move -- i could not find a
way to access it via jdbc. So is ruled out. ii)
admin_copy_schema -- copies across schemas in same database.
iii)db2look -- again a utility. no way to call it from jdbc.
Even if we find a way to run those utilites db2move or db2look
produces files which then have to be copied over to the target
machine - making it highly complicated to automate the whole
thing.  Is there a simple way to clone over a database through
jdbn  share|improve this question  1 Answer 1  JDBC is not
really going to answer your problem directly. It is a generic
programming API for working with any database. So it can't
possibly know about utilities that are specific to an
implementation, be it DB2, Oracle, MySQL, etc.  I would look at
using one of the utilities you mentioned above. That is