There are lots of database (including Oracle, Sybase, and all the SQL Servers etc) running on Windows platform, and there are a lots of DBA tools wrote in Perl language. To use them on Windows, you need to have Perl environment installed first. You can install the cygwin for Windows, however I prefer to use ActivePerl.
First step is to download the ActivePerl install binary, and double click the binary file to start the installation. The default Perl home directory is C:\Perl.
The next step is to install the DBI, Perl define some database call interface in this layer, and then different DBD (Database Driver) implement the call interface. Please start the Perl Package Manager (ppm.bat) program.
ppm> install DBI
====================
Install 'DBI' version 1.53 in ActivePerl 5.8.0.806.
====================
Downloaded 597997 bytes.
Extracting 82/82: blib/arch/auto/DBI/Driver_xst.h
......
Installing C:\Perl\bin\dbiproxy.bat
Successfully installed DBI version 1.53 in ActivePerl 5.8.0.806.
The last step is to install the DBD for different databases, just type the following command in Perl Package Manager. For Oracle driver, you can install it from ActivePerl site.
ppm> install DBD::Oracle
====================
Install 'DBD-Oracle' version 1.17 in ActivePerl 5.8.0.806.
====================
Downloaded 213415 bytes.
Extracting 31/31: blib/script/ora_explain.bat
Installing C:\Perl\site\lib\auto\DBD\Oracle\Oracle.dll
......
Do you accept the terms of this license ? (y/n) : n
Successfully installed DBD-Oracle version 1.17 in ActivePerl 5.8.0.806.
For other databases or ODBC, you may install it from CPAN, by run the following commands.
perl -MCPAN -e shell
cpan> install DBD::ODBC
cpan> install DBD::Sybase #Sybase Client Required
cpan> install DBD::DB2 #DB2 Client Required
To use the Perl array DML interface for better performance, I download the latest DBD-Oracle v1.19 source code and compile it, you can download it, just extract it to the Perl home directory.
Comments (1)
very good!
Posted by cyco | November 11, 2007 1:42 PM