DATA_MIGRATION

Binary, CSV, JSON, SQL, and XML data migration scripts in Java, PHP, Python, R, SAS, and VBA (MS Access and MS Excel).

Using Craigslist Missed Connections NYC/CHI/LA August 2015 posts as example data, scripts include 12 data migration processes in attached folders. Each folder contains examples in above programming language/software types.

---

1. BINARY

   • BIN to SQL Each script migrates binary data to CSV format. See BuildBINs for data source.
   • BIN to JSON Each script migrates binary data to JSON format. See BuildBINs for data source.
   • BIN to SQL Each script migrates binary data to SQL database table. See BuildBINs for data source.
   • BIN to XML Each script migrates binary data to XML format. See BuildBINs for data source.

2. CSV

   • CSV to JSON Each script migrates CSV data into JSON format. Attached CSV file is included.
   • CSV to SQL Each script migrates CSV data into SQL database table. Attached CSV file is included.
   • CSV to XML Each script migrates CSV data into XML format. Attached CSV file is included.

3. JSON

   • JSON to CSV Each script migrates JSON data into CSV format. Attached JSON file is included.
   • JSON to SQL Each script migrates JSON data into SQL database table. Attached JSON file is included.
   • JSON to XML Each script migrates JSON file into XML format. Attached JSON file is included.

4. SQL

   • SQL to CSV Each script migrates SQL database table into CSV format. Attached SQLite table schema and database included.
   • SQL to JSON Each script migrates SQL database table into JSON format. Attached SQLite table schema and database included.
   • SQL to XML Each script migrates SQL database table into XML format. Attached SQLite table schema and database included.

5. XML

   • XML to CSV Each script migrates XML data into CSV format. Attached XML file is included.
   • XML to JSON Each script migrates XML data into JSON format. Attached XML file is included.
   • XML to SQL Each script migrates XML data into SQL database tables. Attached XML file is included.

---

REQUIREMENT: Sscripts require various non-standard modules:

• JSON scripts: Java - gson 2.2.2 jar file; R - jsonlite, VBA - VBA-JSON w/ MS Script Runtime library reference;
• XML scripts: Python - lxml, R - XML, SAS - proc xsl;
• SQL scripts: Java - SQLite jdbc jar file; PHP - PDO extension; R - RSQLite; SAS - ODBC; VBA - SQLite ODBC driver;