Manage Learn to apply best practices and optimize your operations.

Programmatically replace the design of Lotus Notes databases

Trying to programmatically replace the design of several Lotus Notes databases, but can't find an out-of-the box solution? This LotusScript code can help.

Lotus Notes Domino lacks the out-of-the-box capabilities needed to perform certain functions, such as dynamically updating rich-text fields from the back-end without closing a document. This lack of functionality can send administrators on a quest for an easier solution.

Related resources from
Add a program doc to compact Lotus Notes databases

Top 10 LotusScript tips

LotusScript Reference Center

A similar situation arises when trying to programmatically replace the design of a Lotus Notes database. IBM doesn't provide a LotusScript method or C-API function to accomplish this task. In fact, the only way to replace a database design is by manually choosing File -> Database -> Design Replace for each specific database. However, this manual method doesn't make much sense when replacing the design of several databases.

The following LotusScript code can be used to replace the design of multiple databases. The script actually deletes all design notes from the target database and copies them from the source database.

LotusScript to programmatically replace the design of a database
(Click on code for enlarged view and script download.)

Note: The author would like to thank Mr. Ramesh Chand Beniwal and Ms. Neha Agarwal for their help in developing this LotusScript code.

Do you have comments on this tip? Let us know.

This tip was submitted to the tip library by member Amith Narera. Please let others know how useful it is via the rating scale below. Do you have a useful Lotus Notes, Domino, Workplace or WebSphere tip or code snippet to share? Submit it to our monthly tip contest and you could win a prize.

Dig Deeper on LotusScript

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.



  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...