projects / migration-tools.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 8f3eec5) | patch
New tool: dump_oracle_query_output
authorGalen Charlton <gmc@esilibrary.com>
Tue, 16 Apr 2013 22:42:30 +0000 (18:42 -0400)
committerGalen Charlton <gmc@esilibrary.com>
Tue, 16 Apr 2013 22:42:30 +0000 (18:42 -0400)
commitd51d641465825bba6e8cb64b5f4ff2014347258a
tree623135cb9179cdcdbbc4d8f06088a2819b96ae80tree | snapshot
parent8f3eec5b9155b53c3b570fe6184ab7d82075ecfbcommit | diff
New tool: dump_oracle_query_output

Dumps results of query on Oracle database to file for loading into PostgreSQL

Usage: ./dump_oracle_query_output \
    [--sid oracle_sid] [--host oracle_host] --user oracle_user --pw oracle_password \
    --query sql_query \
    --out output_tsv_file [--help]

This exists because sqlplus lacks an easy way to dump arbitrary
query output to TSV or CSV.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
dump_oracle_query_output [new file with mode: 0755] blob
Library data migration tools