Database design.

Posted on 2001-06-20
Last Modified: 2013-12-18
Hi all,

I have been working on one database for a few months now, but would rather work on a local copy, then replicate the design only (excluding my test documents etc.)
I am able to create a new copy of the database (design only) but I'm not sure how to create a design template.

I'd like to use the "inherit design from template" function to make sure the database always has the latest design.

Can anyone explain (step-by-step) how to go about this?

Question by:ANDREAG
  • 2
  • 2

Accepted Solution

sloeber earned 50 total points
ID: 6210812
You go to your local database.
Then you go to the database properties (File - Database -Properties)
There you choose the fourth tab, and select database is a template, and you wright the template name down.
Then you go to the other database who must inherit his design from the local database.
You go again to the database properties, and here you select Inherit design from template.
Here you wright down the same name as above.

That's all.
You go to your database on the server.
Now you can say File Database refresh/replace design, and you choose your local server.
He goes then automatically to your local database.

You can do it also complete automatically,but then you must be an administrator.
In the administrator, there's a task "Designer", and here you can say that he must every day refresh the design from your database on the server with your local one (remember maildatabase)

LVL 24

Expert Comment

ID: 6210820
To create a design template follow these steps.

1. Goto Design tab of the database
2. Check the option, database is a template and give a name (say testTemplate)

To inherit the design

Select the db to inherit design and goto file..database..replace design menu. This will bring up the deisgn template dbs from local. Choose the appropriate server where you have the source template (i.e testTemplate). Then click OK and follow the prompts.

From now the template is bound to the database and whenever you have done any changes to template you just refresh the design by going to file..database..refresh design. THis is from clien for server you can use "load design" to update design

Check the help documentation for more info on design templates,


Expert Comment

ID: 6210861
you where just 2 minutes to late ;-)
LVL 24

Expert Comment

ID: 6211197
Yes my net connection screwed up , you are getting luckier day by day ;-)

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an old article, please see an updated version of this article, located here:
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now