Re: Looking for a cookbook on Oracle clients...

[David Robillard]

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
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]

Looking for a cookbook on Oracle clients...

[Brian J. McGovern]

All,
I have a task that requires I extract a data set from a MySQL server,
and push it on to an Oracle (9i) server. I figured I'd go the ODBC route, 
and installed unix_odbc_driver and its dependencies. 

However, its pretty clear that I don't fully understand what I'm doing,
and each step forward is costing me half a day of debugging, reading code,
and banging my head against the wall. From the documents I can find on the
web, it seems all I should have to do is install, configure my odbc.ini and
odbcinst.ini files, and go.

So, the questions:

1.) Is anyone using unixODBC and oracle_driver_odbc against a 9i
server?
2.) If so, can someone send me their .ini files and any other 
environment and oracle settings they needed to do to make it work (mine
are below)?

3.) Have people moved over to the instantclient in ports? If so, does
anyone have some sample code to test the basic ability to connect?

-Brian

[Oracle]
Description = Oracle Configuration
Driver  = Oracle
Trace   = Yes
TraceFile   = /var/log/odbc.log
Database= eengstg
Servername  = oracle_server
UserName= 
Password= 
Port= 1521

[Oracle]
Description = Oracle driver for FreeBSD
Driver  = /usr/local/lib/liboraodbc.so
Setup   = /usr/local/lib/liboradbS.so
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]