Duplicating notes data to other database

How will u duplicate data from notesdatabase to an oracle database?
Will there be any change in the structure after duplication?
Need of detailed answer.

by
expertKD.
expertKDAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ArunkumarCommented:
Use DECS !!!

(20 points Answer ?)

:)
Arun
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ArunkumarCommented:
Hi ExpertKD !

The DECS mirrors the data from Oracle to Notes and vice-versa.  When you install DECS,  you can actually configure a document that will map the related data.

At the start of this configuration you will be asked what data source you are using.  If you say Oracle you will be connected to Oracle.  Its that easy.
And you will be prompted with a list of tables in Oracle actually picked from the Oracle.  You will be prompted with a list of Notes Forms.

Map - Notes Form to Oracle Table
Map - Notes Field to Oracle Field

When you run the activity the data in oracle is transpatent in notes in the view.  You can open the document and make modifications to it which actually modifies the record in the Oracle.  

You can also add document as records into Oracle from Notes.

Obviously you can also delete records from notes.

Internally - notes keeps only the key field of Oracle in the notes Db.  Whenever the DECS task is running it picks up all the data passing this key and shows in notes.  When the activity stops then all other fields except the key fields are removed from notes to conserve the diskspace.

Good Luck !

:)
Arun










0
FaustCommented:
let me know if you don't want to use DECS you can do it with Lotus Scipt and SQL
0
HemanthaKumarCommented:
Hi expertKD.

I think you solved this by yourself.

~Hemanth
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.