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 [url removed, login to view] with Contact.ID.
For convenience, attached are scripts for db tables creation.
10 freelancers are bidding on average $14/hour for this job
I will make a application to reading data from xml file to insert into sql database according to your requirement. this application can be run automatically by windows scheduler.