Date: Tue, 5 Dec 2006 09:37:17 -0500 From: "David Robillard" <david.robillard@gmail.com> To: "Brian J. McGovern" <mcgovern@beta.com> Cc: FreeBSD Questions <freebsd-questions@freebsd.org> Subject: Re: Looking for a cookbook on Oracle clients... Message-ID: <226ae0c60612050637t9c69eddv22af82855e717ed1@mail.gmail.com>
next in thread | raw e-mail | index | archive | help
> I have a task that requires I extract a data set from a MySQL server, and push it on to an Oracle (9i) server. Hi Brian, If you're familiar with perl (or have a perl programmer handy) you can choose from a whole bunch of perl modules which interact with MySQL and Oracle databases. For example, in the FreeBSD ports tree you will find databases/p5-DBD-Oracle and databases/p5-DBD-mysql ports. Once you have both of these, it should be quite easy to write your perl script to pump data from the MySQL database with databases/p5-DBD-mysql port, perform the data manipulation your business requires and the dump the results into the Oracle instance with databases/p5-DBD-Oracle. Now, if your objective is to migrate all of your data from MySQL into Oracle, then you can check out the "Oracle Migration Workbench". More info on this at http://www.oracle.com/technology/tech/migration/workbench/index.html Good luck, David -- David Robillard UNIX systems administrator & Oracle DBA CISSP, RHCE & Sun Certified Security Administrator Montreal: +1 514 966 0122
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?226ae0c60612050637t9c69eddv22af82855e717ed1>