Hi All,
I have a question on which approach to follow for Migration of data from one database to another.
The scenario is something like this.
The source & target databases are from differnt vendors.
We have created an exact replica of the table & column structure in the Target database similar to the source database.
I am thinkin of writing a
java utility to pull data (resultset) from the source database & then dump it into the target database. I will be using plain
JDBC approach for the same.
I will have to load the drivers for each of the databases , create separate connections & all the usual JDBC stuff for both databases.Since this is just one utility when I retrieve the resultset from the source database then i will close the connection to the source & connect to the target database.
So my resultset object will not be available.
Can some one throw some light on what would be an elegant solution to the above problem
Regards