Re: Migrate Lotus Notes to Oracle3

In article <37b0abf7.4573856_at_news.mindspring.com>, crd1_at_mindspring.com (Craig Duncan) wrote:
>Hello again...
>
>I was approached by a co-worker today who was seeking
>information about migrating a database from Lotus Notes
>to Oracle8.
>
>Are there tools that might help perform this task?
>
>I no nothing about Lotus Notes. My co-worker thinks
>that Lotus Notes can be migrated to Access (therefore
>Lotus Notes --> Access --> Oracle8). He also thinks
>that a Lotus Notes database can be handily output to
>a text file (therefore perhaps sqlldr).
>
>Anybody got any no-how, ideas, or experience with
>this?
>
>Thanks, and may the Schwarz be with you...
>
>Craig Duncan

G'day,

Well, first, analyse the Notes database in order to get all input for your tables and columns. Create your Oracle database and then create an ODBC entry on your workstation for your Oracle database. Ok, so far so good. Now you will have to write a small agent using LotusScript which is using the LS:DO (LotusScript:DataObject) extension. Create a connection using ODBConnection() continuing with ODBCQuery() and so on.
And if you don't want to use LotusScript, you could use the formula language and @DBCommand(). Unfortunately I haven't got a good example at moment (I'm at home), but have a look in the Notes online documentation, there are some really good examples for this kind of stuff.
And, you don't have to go through Access to get the job done...

Just my $0.25,
Andreas Almroth Received on Tue Aug 10 1999 - 22:49:33 CDT