I've created a winform c# application that connects to an oracle database and loads a datatable with all the data in the oracle table then exports it out to a delimited file, which will then get imported to a local mysql database. This works just
fine when the oracle table isn't so large. However I keep getting an out of memory exception when I populate my datatable with a large oracle table. I can't manually export data from oracle then manually load to mysql because this has to be seamless
to the user. I'm having difficulties grasping how to solve this problem. Is there a better solution then what I have to get from oracle to mysql?
View Complete Post