In a project I have to transfer data from one DB to another DB through webMethods. Some of the tables have over 9 lac records that are to be transferred everyday. Now I don’t want to select all of these at a stretch as it causes memory shortage. I am thinking of selecting a bunch of records at a time based on a selection criteria (Which depends on the table field types). But I feel there can a better solution to this.
I would like to know if any of you had handled such cases. Please share your ideas, views or implementation plans.
Source & Target Dbs: MS SQL Servers.
JDBC Adapter Ver: 184.108.40.206