Installing the Repository to the Server

The repository administrator must set up the repository on a database server running one of the supported DBMSs.

1. On the repository administrator's workstation, start PowerDesigner and select  Repository  Repository Definitions  to open the List of Repository Definitions.
2. Click the Add a Row tool to create a new definition, and click the Properties tool to open its property sheet.
3. Enter the following properties:

   Property	Value
   Repository name	Enter an appropriate name to identify the repository.
   Data source name	Click the Select a Data Source tool to the right of the field and select or create the data source that you want to use to connect to the repository database. To create an ODBC machine data source for a SQL Anywhere database, see Creating a Data Source to Access the Database. For detailed information about creating, configuring, and using connection profiles for other DBMSs, see Core Features Guide > Modeling with PowerDesigner > Getting Started with PowerDesigner > Connecting to a Database.
   User name	Enter the administrator name you chose when creating the database.
   Password	Enter the administrator password you chose when creating the database
   Bytes per char	For non-Oracle unicode or multi-byte character set databases, specify the bytes per character used by the database: 1-byte - For SBCS (Single-Byte Character Set) 2-byte - [default] For DBCS (Double-Byte Character Set) 3-byte - For Unicode or MBCS (Multi-Byte Character Set)

4. Click Test to test the connection and, in the event of an error, double-check your connection parameters. Then click OK to return to your repository definition, and click OK to complete its creation.
5. Select  Repository  Connect  to open the Connect dialog. Select the name of the repository definition you just created and click OK to connect.
   A message box is displayed inviting you to install the repository. This will involve running a SQL script to create the necessary tables.
6. Click Yes to continue. The read-only Repository Installation Script window opens.
   
   
   

   Note You cannot edit the script in this dialog, but you can, if necessary, modify the statements (for example, to add physical options) by copying the script to an external SQL editor, making the appropriate edits, and then connecting 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.
7. Click Execute to run the script and create the repository tables. This may take several minutes.
   Note If the installation fails due to network problems, insufficient disk space, or permission problems, we recommend that you do not choose to ignore the errors, but rather abort the installation and start again.
8. When the repository has been installed, the Change Password dialog will open, prompting you to change the administrator password. Enter a password that complies with the default repository password policy as listed in the dialog, and then click OK to complete the creation of the repository.

   In the repository Browser, the root of the repository tree displays the repository name and the connected user and is ready for use.