Re: Redbrick to Oracle 8.1.5 migration?

tmaddenNOtmSPAM_at_sachs.com.invalid (Thos. Madden) wrote in <03793b48.a36a6df6_at_usw-ex0109-070.remarq.com>:

>Anyone have any exerience migrating a Redbrick data
>warehouse to
>Oracle? Any pointers on how to do this intelligently and
>efficiently?

i used rb_tmu to unload tables, compress the output, ftp to other box, uncompress, and feed to sqlload. one table at a time, like you.

i recommend piping the output of rb_tmu to a compress utility, then the reverse back to sqlload, to save a PILE of time and disk space. see below.

also: red brick uses ODBC as its standard connection, so you can also make an odbc connection from oracle to red brick, then use the sql*plus COPY command to fetch the data directly -- no control files for sqlload needed.

if you want to try that, you must install the OCA (oracle client adapter) and ODBC drivers from a developer (formerly dev 2000) cd on the oracle machine. i doubt that it will be faster than unloading, since red brick idiotically stores char datatype will all the trailing spaces, and sends them over the wire that way.
--
dave mausner Received on Wed Jan 26 2000 - 20:10:11 CST