From owner-freebsd-questions@FreeBSD.ORG Tue Dec 5 14:37:20 2006 Return-Path: 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 ; 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 ; 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 ; 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" To: "Brian J. McGovern" MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Cc: FreeBSD Questions 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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