Windows安装Ora2pg
1.首先下载最新的安装包，https://ora2pg.darold.net
2.在windows上安装perl
Since version 5.32 this Perl distribution include pre-compiled driver of DBD::Oracle and DBD::Pg.
安装32位Pperl
https://strawberryperl.com/
3.解压缩
cd C:\ora2pg
unzip C:\Users\User\Downloads\ora2pg-23.1.zip
4.在cmd中切换到解压目录
cd ora2pg-23.1
5.执行perl Makefile.PL
perl Makefile.PL
6.安装完后会有提示执行命令dmake && dmake install
gmake.exe && gmake.exe install
cd C:\ora2pg
#copy ora2pg_conf.dist ora2pg.conf.dist
#mkdir C:\ora2pg\migtest
#ora2pg --project_base C:\ora2pg\migtest --init_project test_project
C:\ora2pg\ora2pg.conf
ORACLE_HOME D:\oracle\ora11.2
ORACLE_DSN dbi:Oracle:host=127.0.0.1;sid=nt11g;port=1521
ORACLE_USER test
ORACLE_PWD test
SCHEMA GP01_NDM_ALL
TYPE SEQUENCE TABLE VIEW PACKAGE SYNONYM
EXPORT_SCHEMA 1
CREATE_SCHEMA 1
PG_VERSION 9.6
PG_DSN dbi:Pg:dbname=testdb;host=192.168.200.28;port=11000
PG_USER gpadmin
PG_PWD gpadmin
PG_NUMERIC_TYPE 0
PG_INTEGER_TYPE 1
DEFAULT_NUMERIC NUMERIC
PG_SCHEMA GP01_NDM_ALL
NLS_LANG AMERICAN_AMERICA.UTF8
OUTPUT_DIR D:\Temp\out2
OUTPUT GP01_NDM_ALL.sql
测试：
ora2pg -t COPY -n test -a TEMP_TAB03 -c C:\ora2pg\ora2pg.conf
