Hi all
My requirement is that I need to transfer huge amounts of data at one shot (> 100 million) from a data source and put it into my tool database.. I need to do this using my application ( and not using bcp, bulk upload, or SSIS, etc...)
I am planning to use ADO.net for this purpose.
So what are the strategies to transfer such large amounts of data from one server to another...
I thought of bringing data in the form of pages (i.e) divide the data into smaller portions (lets say 1 million data 100 times).. But how do we implement paging of this sort...
is there any other alternate strategy to achieve this ??
Regards
Rajaraman R