Data Paging ????????

raja raman

16y15.1k

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs16y ago
See your other thread that you created with this question.
0
Suthish Nair16y ago
I dont know why not using bcp, bulk upload, or SSIS, etc...?

better create a console application, schedule it on a separate server/machine because of performance issue.
0
16y ago
http://msdn.microsoft.com/en-us/library/87z0hy49.aspx
http://msdn.microsoft.com/en-us/magazine/cc163709.aspx
0