Shred XML files into MSSQL

Closed

I need a stored procedure developed for MSSQL 2012 which will quickly and efficiently shred XML files into normalized tables. All XML files will adhere to the same schema. The XML files will be loaded into 17 tables which mirror the structure of the schema. The XML files may be as large as 15MB (~300000 rows), but performance is critical. I have read online where developers say that, by loading an XSD schema and creating an XML Index, they were able to shred a [url removed, login to view] file in less than a second. I will provide the XSD and several sample XML files, as well as the script to generate the MSSQL tables. The milestone payment will only be awarded if the largest of the files can be successfully shredded in less than 60 seconds (using an m1 instance on Amazon EC2).

Skills: SQL, XML

See more: shred, 5mb file, sql less than, xsd to xml online, mssql, m1, c# MSSQL, amazon xml, amazon xml sample, mssql stored, large xml file sample, schema sql, amazon performance, xml structure, shredded, script xml file sql, xsd sql, xsd xml, amazon xml files, sql developers, xsd generate, mssql procedure, amazon xsd, generate xsd, xml files

Project ID: #4685066

Awarded to:

siberiangirl

Hello. Please, check PM.

$277 USD in 7 days
(104 Reviews)
5.7

13 freelancers are bidding on average $225 for this job

samitXI

Please check your inbox. Thanks

$242 USD in 3 days
(3 Reviews)
4.5
expertcoder1vw

I can develop a a Windows desktop application to do this (instead of using SP). Its less error prone and faster. I can do this for you. Regards, Larry

$210 USD in 3 days
(10 Reviews)
4.5
riskypathak

Hie Yes i can create a optimum shredder for you in store procedure. Just a question why dont you use a c# tool. I think that will be fast

$250 USD in 10 days
(13 Reviews)
3.5
mneo

Hi, I can do this as per your requirements, please contact me via PMB so that we can discuss this further. Regards,

$210 USD in 5 days
(6 Reviews)
3.1
thedee

Hi, I'm experience wtih .NET and MS SQL Server 2008. My last project is to use XML for data aggregation between server using FTP as its transport. And also my last project is to setup a Domino Server on Amazon EC2 a More

$244 USD in 6 days
(1 Review)
2.7
ima9ine

I did the same project before. Let have a look on my profile about the project that working with ICEcat import data.

$222 USD in 3 days
(2 Reviews)
1.9
ultrasonicsoft

Hi, Please check your inbox. Thanks!

$222 USD in 10 days
(1 Review)
1.5
biscuitwizard

Hello! I have a lot of experience with C# and MySQL and after looking at the sample files, I'm extremely confident I can complete this task.

$155 USD in 6 days
(0 Reviews)
0.0
alisher32

Hi. Check your PM. Thanks

$190 USD in 4 days
(0 Reviews)
0.0
devrajroy

Expertised in SQL server development like SSIS development and Oracle Export developement.I have 4 years experience in this project in Capgemini as a Database developer.

$222 USD in 3 days
(0 Reviews)
0.0
igotmail9

Dear Sponsor, I have 14 years of software development experience. Extensively worked on Linux/Debian/Solaris/IRIX/ and Windows platforms. Software application knowledge in Visual C++, Java/EJB/ Tomcat/Apache webse More

$263 USD in 3 days
(0 Reviews)
0.0
sabinweb

I worked with MsSql and XML

$200 USD in 7 days
(0 Reviews)
0.0
ghanchiasif

I can do that.

$222 USD in 7 days
(0 Reviews)
0.0