MS SQL Import of XML -- 2

Tweak a little code - I need to request the XML from PubMed like

[login to view URL],28322247,26158412&retmode=xml

The example has 3 IDs but the request can be as much as 200 at a time. The request is being done by a VB.NET web service. I am looking for the most efficient way to process the XML files. I know that the the term "best" or "efficient" is very subjective and dependent upon many things but I'm not sure if it is better to send the entire string to the SQL Server database (if it is even possible because of length or possible nesting levels) and let it parse the document and save it to the database or is it better to parse the document in the web service using a XMLTextReader or XML Document Object and send each document or XML Bulk import? Each document needs to be saved as a separate record XML record with the PMID(ID). 2 Columns one for the XML document and one for the PMID(ID). I want expert input on this little project because I can do all import methods myself but I want clean efficient code. All I want is code you do not need to set up an entire environment but I want vb.net code for the webservice and MS SQL code for the server. I've include my current code in the attached files, so before you bid look at it and only bid if you can make it more efficient with maybe a bulk copy?

Evner: C# Programmering, SQL, VB.NET, XML

Se mere: export sql xml import sql server, google spreadsheet xml import sql, import xml file sql server vb net, sql, import sql database reside asp net project, import data ms access excel net, xml import sql amok php, import xml directory sql, automate sql xml import, import xml pages sql server, import xml web sql 2005 job, xml import sql server, sql xml import, xml import sql server 2005, net insert xml data sql, xml import 2005 sql, xml import sql 2008, xml import sql, import xml data sql 2005, sql server xml import

Om arbejdsgiveren:
( 136 bedømmelser ) Charleston, United States

Projekt ID: #13569138

Tildelt til:


I'm a really serious professional with wide experience in .Net development including all sorts of ETL, XML/Sql Server processes as the one you're describing here. Not so long ago I've done this very same thing to proce Flere

$10 USD på 1 dag
(4 bedømmelser)

6 freelancere byder i gennemsnit $38 på dette job

$29 USD på 1 dag
(227 bedømmelser)

Hi, I would like to take up this project. I gone through the requirement and would like to discuss more about the project. I do have good experience in Web and Windows application development with Database techn Flere

$25 USD på 1 dag
(19 bedømmelser)

Hello! I have great experience with C# and SQL Server. In addition I'm very efficient analyzing processes and propose improvement in all the process. There is no attached file

$100 USD in 2 dage
(1 bedømmelse)
$25 USD på 1 dag
(0 bedømmelser)

A proposal has not yet been provided

$40 USD in 3 dage
(0 bedømmelser)