Bulk insert into DB using ADO.net 1.1

  • Thread starter Thread starter utanka
  • Start date Start date
U

utanka

Hi all,
I have a requirement where in I have to insert high volume records into
a master-detail pair of tables (2000 rows into master & 100000 into
detail). This is going to be a user initiated weekly task. Since there
is processing logic to be applied to the records before i do the
inserts, I was taking them into a typed dataset (I am hesitant to put
the logic in a stored proc as that would cause extensibility problems
as well as Database porting problems in future, currently i use
Sybase). Now problem arises when i come to know that ado.net 1.1
doesn't support bulk inserts and my organisation is yet to buy a .net
2.0 license. So, if I decide to do a dataset.update() with ado.net 1.1,
it means one round trip to the DB Server for each row to be inserted.
Detailed suggestions would be most welcome on any possible workaround
for this problem.
Thanks,
Utanka.
 
BCP and DTS have been around for quite awhile--both can be executed from any
application and you don't need ADO to do it (for all of the approaches). SQL
Server has TSQL bulk functionality, you can execute bulk copy operations via
SQL DMO or SMO or create a DTS package interactively that can be executed
from code (or manually).

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top