SQL script is needed that will periodicaly (on total_applications field change?) import data to SQL server 2005 database from attached xml file to db tables. File Web address will be provided.
After inserting Project and contact records, update field Project.ContactPerson with Contact.ID.
For convenience, attached are scripts for db tables creation.