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: yuo yuo yuo, xml to xml online, process data structure, online dev c++, mark may, db import export, data structure note, t-sql with, online sql, online xml, xml export, t-sql;, sql, sql script , sql project , sql import, sps, mantislin, import XML, import sql, bulk mark, authority records, export import project, bulk data project, update sql file

About the Employer:
( 12 reviews ) Toronto, Canada

Project ID: #568672