Project

General

Profile

« Previous | Next » 

Revision 7530

Added by Aaron Marcuse-Kubitza almost 12 years ago

README.TXT: Datasource setup: Added instructions for MS Access databases

View differences:

README.TXT
150 150 
        Edit _MySQL/*.make for the DB connection
151 151 
            For a .sql export, use your local MySQL DB
152 152 
        Skip the Add input data for each table section
153 
    For MS Access databases:
154 
        Place the .mdb or .accdb file in _src/
155 
        Download and install Access To PostgreSQL from
156 
            http://www.bullzip.com/download.php
157 
        Use Access To PostgreSQL to export the database:
158 
            Export just the tables/indexes to inputs/<datasrc>/<file>.schema.sql
159 
            Export just the data to inputs/<datasrc>/<file>.data.sql
160 
        In <file>.schema.sql, make the following changes:
161 
            Replace text "BOOLEAN" with "/*BOOLEAN*/INTEGER"
162 
            Replace text "DOUBLE PRECISION NULL" with "DOUBLE PRECISION"
163 
        Skip the Add input data for each table section
153 164 
    Add input data for each table present in the datasource:
154 165 
        For .sql exports, you must use the name of the table in the DB export
155 166 
        For CSV files, you can use any name. It's recommended to use a table

Also available in: Unified diff