I have a need to move data from sybase to db2 for the purpose of combining it with other data to extract to a delimited file. The strategy I started with was to put the data into a table in db2 and select the rows thru a query connecting to sybase and building an insert query to execute thru a db2 connection. There are 200,000 rows and this sounds inefficient.
I don't see how to employ a bulkcopy but I have done it for sql server?
I'm beginning to think that I could populate a dataset in vb.net and possibly bulk copy on the db2 side from the dataset in vb.net to an existing table in db2?
I'm looking for good way to do it, not too complicated and sample code showing it?
This is a lot to ask but really appreciate the help.