Encerrado

DB conversion - XSD, XML & MySQL

This is a three part project:

1. Conversion of XSD schema (XML) to MySQL

2. A script for converting exported MySQL data to an XML file based on the schema.

3. A script for importing an XML file based on the schema into the MySQL database.

* **You can bid on Part 1 without bidding on Parts 2 and 3.**

* You can also bid on Parts 2 and 3 without bidding on Part 1. However, Part 1 will have to be delivered and available before work can proceed on Parts 2 and 3.

## Deliverables

1. Conversion of XSD schema (XML) to MySQL

Convert the attached XSD schema (XML) to MySQL. The conversion must maintain the database relationships and constraints for table like Unique, Not null, combination Key, etc. The deliverable is an empty MySQL database, a table with a simple map of the conversion (XML Field Name - MySQL Table Name - MySQL Field Name), a description of how the conversion was accomplished and the name of any semi-automated or automated tool used to accomplish the conversion.

2. A script for converting exported MySQL data to an XML file based on the schema.

The script will use data exported from the MySQL database. The export requests will have multiple sources including a web interface, and these exports will occur in real time. The scope of this project is limited to the conversion script from MySQL to XML and does not include the web interface or MySQL export. The deliverable is the conversion script, documentation of the script and a usage guide for the script.

3. A script for importing an XML file based on the schema into the MySQL database.

One source of imports will be files uploaded through a web interface. These files will be converted in real time. The other source is files sitting on our server (usually received via FTP) and the script to perform the import will be set off by a chron job. The scope of this project is limited to the conversion script and does not include the web interface or chron job. The deliverable is the conversion script, documentation of the script and a usage guide for the script.

The XSD file for part 1 is attached. A sample of the imported and exported xml for parts 2 and 3 is also attached. To provide perspective on the nature of the data, an HTML file based on the XML is also attached. The operating environment is Linux/PHP.

Your bid should include:

1. The technologies and/or methods that you would use to create the empty MySQL database to whatever extent it will not compromise your bid. (Part 1)

2. A description of the method(s) to implement the import and export to whatever extent it will not compromise your bid. (Parts 2 & 3)

3. Any other information that you think is relevant.

4. A detailed quote for each part of the project.

5. The amount of time required to deliver each part of the project. Please be sure to break this down by part.

If you are the successful bidder for all three parts, we will require delivery and acceptance of Part 1 before proceeding with Part 2, and then delivery and acceptance of Part 2 before proceeding with Part 3. Progress payments will be released upon acceptance of each part. Feel free to contact me know if any other info or input is required.

1) I require complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased.

3b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the seller's Seller Legal Agreement.

## Platform

Linux/CentOS Apache PHP5 MySQL5

Habilidades: Administração de Bancos de Dados, Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, SQL, XML, XSLT

Ver mais: convert xsd mysql database, convert xsd mysql, create mysql script xsd, convert xsd database schema php, convert xsd database, xsd mysql database, sample received form, php script null, mysql php free source code project, mysql gpl, mysql documentation, mysql database for free, how to null php script, how to null a script, how to null a php script, gpl mysql, free mysql server, db import export, php create mysql xsd, mysql data files, xml export, xml conversion, mysql linux php, export mysql, centos ftp

Acerca do Empregador:
( 0 comentários )

ID do Projeto: #3043487

2 freelancers estão ofertando em média $340 para este trabalho

radudami

See private message.

$170 USD in 14 dias
(144 Comentários)
5.8
binhxe

See private message.

$510 USD in 14 dias
(1 Comentário)
0.0