Setting up the repository server

Chapter 2 Getting Started with the Repository

The repository server hosts the repository database. The repository administrator will set up this server for use by the team.

To create a repository on the server:

Choose a server on which to install the repository. The server must be accessible to all those who will need to work with the repository.

Install or obtain access to a DBMS suitable to store the repository tables. For this step, you have two options:
- Install the authenticated version of Sybase SQL Anywhere 10 provided with PowerDesigner. For detailed instructions, see the Installation Guide .
- Use your own DBMS

Create an empty database to host the repository, with an administrator user who has full rights on all the tables. For instructions on performing this step with SQL Anywhere, see the Installation Guide .

On a client machine, with PowerDesigner installed, create a direct repository definition to connect to the new database (see Setting up a client for direct access). Note that you cannot create a repository via the repository proxy.

Connect to the repository using this definition (see Connecting to a Repository). A message box is displayed inviting you to install the repository. This will involve running a SQL script to create the necessary tables. Click Yes to continue.

The read-only Repository Installation Script window opens. Click Execute to run the script and create the repository tables:

When the repository has been successfully installed, a final message "Repository installation completed" is displayed in the Output window. In the repository Browser, the root of the repository tree now displays the repository name, the repository user and the current branch (MyBase::ADMIN::<Default>), and is ready for use.

Notes:

By default, database tables are owned by the user who creates them. Each repository user should either use the same database user name and password to access the repository, or have an account that gives them full rights over all the tables
Although you cannot edit the script in the Repository Installation Script dialog, you can, nonetheless, modify the statements (for example, to add physical options). To do this, you would need to copy the script to an external SQL editor, make the appropriate edits, and then connect to the database to execute the script outside of PowerDesigner. The Separator list in the dialog lets you select the separator appropriate to your interpreter.
Rarely, repository installation may fail due to network problems, insufficient disk space, or permission problems. In this situation, you can choose whether to ignore the errors or abort the installation. We recommend that, if you are unsure, you abort the installation, and recommence.
Repository models are stored as efficiently as possible, with only changed objects being re-saved. If a design team works on a 5-MB model for one year with, on average, eight consolidations per week, there are around 400 versions in the repository. The size of the original baseline version will be around 10 MB. Each version will be about 5% of the total size of the model, so that total volume of versions is around 200 MB, and you will need around 210 MB of space in total.