Merge data from xml to sql server
-
Hello. In my project i have parsed my database into xml files. I done this by using typed dataset's writexml feature. After doing this and transfering these files to a remote machine that has the same database schema i need to merge that data from the xml to the machine's database. In every row of every table there is a filed called last changed which i want to use to determin if the row is more current than the one on the machine's database. How can the merging from the xml to the sql server be done? any ideas guys
-
Hello. In my project i have parsed my database into xml files. I done this by using typed dataset's writexml feature. After doing this and transfering these files to a remote machine that has the same database schema i need to merge that data from the xml to the machine's database. In every row of every table there is a filed called last changed which i want to use to determin if the row is more current than the one on the machine's database. How can the merging from the xml to the sql server be done? any ideas guys
Code. That's about it, really. Read the XML, write code to do the inserts.
Christian Graus Driven to the arms of OSX by Vista.
-
Hello. In my project i have parsed my database into xml files. I done this by using typed dataset's writexml feature. After doing this and transfering these files to a remote machine that has the same database schema i need to merge that data from the xml to the machine's database. In every row of every table there is a filed called last changed which i want to use to determin if the row is more current than the one on the machine's database. How can the merging from the xml to the sql server be done? any ideas guys
-
If this is a full-blown SQL Server box, you probably want to look at using SSIS to do this.