UPDATE A DATABASE TABLE WITH AN XML FILE... NEWBIE HELP!
Posted on 2004-09-16
I have an XML file named "categories.xml".
Its structure is something like this:
<cat CatId="1" CatDesc="Something" Active="1" Path="whatever">
This file is constantly being edited throughout the day (edits, additions etc). I need to update a SQL Server database table with these changes nightly.
The fields in the database table match up perfectly to the XML file with the exception that the database table has two extra fields: PrimaryKey and ForeignKey. I'm most familiar with VB .NET if you can show me a way to do this programmatically. The goal is to write a console application that will be scheduled to run nightly. Any help will be greatly appreciated. I'll raise the point values if it proves to be more difficult than anticipated. Thanks!
How do I go out about doing this? Is it something with XDR? XLST? What are these?