Go Premium for a chance to win a PS4. Enter to Win


Database design.

Posted on 2001-06-20
Medium Priority
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 200 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


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

972 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