If you don't have copies of SPs you submitted earlier for similar project, I can provide those. If yuo need the xml file I can also make it available to you.
I need this by Sunday even. Will pay $50 for this. Pls let me know if you can do this.
Current xml population process :
1/ For each new XML file the logic is -If tables exists, drop the tables, recreate the tables and populate the tables on the local DB server ('Bulk' authority)
2/ Drop and recreate table structure on Prod DB (SQL script)
3/ Using import/export utility, import data from local DB to Prod DB
New xml population process (proposed)
1/ We need to add a new flag "xmlFlag" (may be each table)
a/ Mark "xmlFlag=1" if the records are populated by XML
b/ Mark "xmlflag=0" if the records are populated by online forms
2/Create the tables (on dev and prod) with new flag "xmlFlag"
3/ For each new XML file
a/ On local DB, delete all the existing records, populate the tables with xml file, mark these records as "xmlFlag=1"
b/ On Prod DB, delete all the records marked as "xmlFlag=1" (keep the one marked as "xmlFlag=0" )
c/ Using (import/export utility) update Prod DB from local DB. This time Prod DB will have nonxml entries(records marked as "xmlFlag=0")
Points to note :
Local DB will always have all the records marked as "xmlFlag=1" (populated from xml xml)
Prod DB will have records marked as "xmlFlag=1" and "xmlFlag=0"