From owner-freebsd-questions@FreeBSD.ORG  Tue Dec  5 14:37:20 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id 04F3416A403
	for <freebsd-questions@freebsd.org>;
	Tue,  5 Dec 2006 14:37:20 +0000 (UTC)
	(envelope-from david.robillard@gmail.com)
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.172])
	by mx1.FreeBSD.org (Postfix) with ESMTP id A8F2943CAD
	for <freebsd-questions@freebsd.org>;
	Tue,  5 Dec 2006 14:36:39 +0000 (GMT)
	(envelope-from david.robillard@gmail.com)
Received: by ug-out-1314.google.com with SMTP id o2so2976375uge
	for <freebsd-questions@freebsd.org>;
	Tue, 05 Dec 2006 06:37:17 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:mime-version:content-type:content-transfer-encoding:content-disposition;
	b=GivmoeDWizGZ9L0znyG/E5yaWkv/8ScOX8CSVDkBVEqT2ZoW3QvkRSaFAVd38kbPQFg0lBt+mjj7OtCOWvvhKlzJvQAj3IxpcnP8ljDhhl6ObJsLYUO/OKUKGMaNnq4RRdghpqFZ8zXUlTrdaHzZAEO4mi9+RVCLWhTHsXwXt+A=
Received: by 10.67.97.7 with SMTP id z7mr13755385ugl.1165329437415;
	Tue, 05 Dec 2006 06:37:17 -0800 (PST)
Received: by 10.67.106.17 with HTTP; Tue, 5 Dec 2006 06:37:17 -0800 (PST)
Message-ID: <226ae0c60612050637t9c69eddv22af82855e717ed1@mail.gmail.com>
Date: Tue, 5 Dec 2006 09:37:17 -0500
From: "David Robillard" <david.robillard@gmail.com>
To: "Brian J. McGovern" <mcgovern@beta.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Cc: FreeBSD Questions <freebsd-questions@freebsd.org>
Subject: Re: Looking for a cookbook on Oracle clients...
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 05 Dec 2006 14:37:20 -0000

> 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