Phoenix - Your AI AssistantConvert XML to SQL related tables
- Posted:
- Proposals: 13
- Remote
- #1568672
- Awarded
Scarborough 
Description
Experience Level: Intermediate
General information for the business: Maps
Database management system (DBMS): Microsoft SQL Server
Description of requirements/functionality: Convert XML file into MS SQL Server tables or CSV files that can easily be imported into SQL.
Only specified nodes in the XML need to be extracted and saved as data that can be imported into SQL Server database.
Ideally two files will be created from the XML data to create relational tables in SQL.
1. Master - containing object ID and description
2. Details - containing parent ID from master and sub-set data lines
Specific technologies required: XML, CSV, SQL
Extra notes:
Database management system (DBMS): Microsoft SQL Server
Description of requirements/functionality: Convert XML file into MS SQL Server tables or CSV files that can easily be imported into SQL.
Only specified nodes in the XML need to be extracted and saved as data that can be imported into SQL Server database.
Ideally two files will be created from the XML data to create relational tables in SQL.
1. Master - containing object ID and description
2. Details - containing parent ID from master and sub-set data lines
Specific technologies required: XML, CSV, SQL
Extra notes:
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Charles,
Please provide withe complete file and let us know which fields needs to be extracted.
Regards
Dhiraj