Re: Lotus Notes replication to other databases??

Essentially this is a reader/writer problem and not to hard to solve using a good odbc/jdbc/DBI driver for both the source and target data base. Here is the basic architecture:

db_handle_source = db_connect(source_dbms, driver_name, user_name/pw); db_handle_target = db_connect(target_dbms, driver_name, user_name/pw);

#prepare to loop through the source table: source_statement_handle = db_handle_source.prepare("select seq_nbr, foo, bar from tweedle_dee");
while ((v_seq_nbr, v_foo, v_bar) = source_statement_handle.fetchrow(){

    #having got the source data, update the target data (might need an insert if new row!):

    db_handle_target.do("update tweedle_dum set foo = v_foo, v_bar=v_bar where seq_nbr = v_seq_nbr");
}
db_handle_source.disconnect();
db_handle_target.disconnect();

>PLEASE<, I wrote this as an aid. It is past my bedtime. As psuedo code,
it will give you a level of confidence as to the nature of the problem.

-L

NationsBank Staff Support wrote:

> We have a project where we want to take data from Lotus Notes and
> replicate it to other databases such as Oracle, Sybase, Access, etc..
> We
> also want to pull information in from those databases as well.
> Basocally a replication effort from time to time.
>
> Any good tools out there? Things to watch out for? Success stories?
> Horror stories, etc??
>
> An email reply to peter.cumming_at_nationsbank.com is much appreciated.
>
> Peter

--
Lane Sharman
Pour chasser le chagrin,
il faut du vin.