Copy Data From Xml To table in database in sql server avoiding duplications

Question

1.00/5 (1 vote)

See more:

i am trying to copy data from xml to my database table but i get one approach as best i.e:

using SqlBulkCopy

but i am not able to achieve my task. I need to copy data from xml to sql database avoiding duplication's in table. and if same data exists dont copy it , if new insert it and updated then make updations in table.

Any help is appreciated.

Posted 25-May-13 3:43am

goofy229@gmail.com

Add a Solution

Comments

[no name] 25-May-13 9:48am

Delete the data in the database before you do your copy and then then won't be any duplicate data.

Maciej Los 25-May-13 14:13pm

Please, be more specific and provide more details. We can't read in your mind and we can't help you without knowing the structure of xml and table. Use "Improve question" widget to update question.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RichardInToronto · Answer 1 · 2013-05-25T04:38:00

If this is something you would like to automate, and to implement in C#, you could:
- Use XmlTextReader to process the XML
- Write a stored procedure in MS SQL Server that stores the data coming from XML, with some logic for duplicate data

If this is a one time only process, you could:
- Import the XML data into Excel, and save it as a .csv
- Use SSIS/DTS to import the .csv data into a new table in your database
- Write a query that selects only the non-duplicates from the new table, and inserts them into the table you want.

I could do either approach if you need additional help.

Cheers,

Richard Rogers
http://www.RichardRogers.ca/[^]