In Progress

Project for Thorius or mantislin - XML to SQL

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"

Skills: SQL, XML

See more: process data structure, mark may, data structure note, online sql, online xml, xml export, sql script , sps, mantislin, bulk mark, authority records, export import project, bulk data project, update sql file, sql create script, sql server script import, xml online, xml quot, project using sql, need authority, xml structure, script xml file sql, script process xml file, create flag sql, update sql table xml

About the Employer:
( 12 reviews ) Toronto, Canada

Project ID: #568672