Script to translate CVS to MySQL .sql script
$30-100 USD
Thanh toán khi bàn giao
The goal of this project is to create a script (or tool) that is capable of reading a CSV source file containing roughly 800,000 records and creating a MySQL sql script containing several thousand INSERT statements. The resulting sql script will, when executed, populate a target MySQL database. This script will be repeatedly executed once every 1-2 months in order to reload the target database with newly updated source data.
The source CSV file and the target database (create table script) will be provided to contrator for full testing.
Please see the attached document (in OpenOffice format) for a detailed description of the project specifications.
In addition to this current project, we will also have several additional projects. The additional projects will be more focused on J2EE application development tasks within an architecture based on Struts, Hibernate, JBoss, and MySql.
## Deliverables
Deliver a working script that can be maintained and futher enhanced if needed.
## Platform
In terms of OS, we use Windows and Linux. The main requirement is that the script must be built with open-source or freely available language and/or tools (e.g., Java, Python, Perl).
ID dự án: #3484925