Hi All,

Given a database created from catalog.xml below. What's the best way to update & add records received daily as in file daily-update.xml ?

Coming from relational DBs & new to this. I ultimately need to script/automate this. Hoping there's some magic command I'm missing & looking for best way to approach the problem. 

Thanks,

-Dave

catalog.xml

<?xml version="1.0" encoding="UTF-8"?>

<CATALOG>

   <ENTRIES>

      <ENTRY>

         <SKU>1</SKU>

         <TITLE>Empire Burlesque</TITLE>

         <ARTIST>Dylan</ARTIST>

         <PRICE>10.90</PRICE>

      </ENTRY>

      <ENTRY>

         <SKU>2</SKU>

         <TITLE>Hide your heart</TITLE>

         <ARTIST>Bonnie Tyler</ARTIST>

         <PRICE>9.90</PRICE>

      </ENTRY>

   </ENTRIES>

</CATALOG>

daily-update.xml

<?xml version="1.0" encoding="UTF-8"?>

<CATALOG>

   <ENTRIES>

      <ENTRY>

         <SKU>1</SKU>

         <PRICE>19.90</PRICE>

         <NEWTHING>I wasn't here before the update</NEWTHING>

      </ENTRY>

      <ENTRY>

         <SKU>1971</SKU>

         <TITLE>Tupelo Honey</TITLE>

         <ARTIST>Van Morrison</ARTIST>

         <PRICE>8.20</PRICE>

      </ENTRY>

   </ENTRIES>

</CATALOG>