Show TOC

Creating a Database to Contain the RepositoryLocate this document in the navigation structure

Once you have installed SQL Anywhere, you must create an authenticated database on the repository server to which you will deploy the repository.

Procedure

  1. Select Start of the navigation path Start Next navigation step Programs Next navigation step SQL Anywhere 16 Next navigation step Admin Tools Next navigation step Sybase Central End of the navigation path to open Sybase Central.
  2. Select Start of the navigation path Tools Next navigation step SQL Anywhere 16 Next navigation step Create Database End of the navigation path to open the Create Database Wizard.
  3. Click Next to go to the Select a Location page. The Create a database on this computer option is automatically selected. Click Next to go to the Specify a Database File page.
  4. Enter an appropriate name and location for the database, and then click Next to go to the Specify the Transaction Log File page.
    Note You will need to specify this file when you create a data source to allow PowerDesigner to connect to the database (see Installing a Local Test Repository).
  5. Make sure the Maintain the Following Transaction Log File check box is selected, accept or specify an alternate log file name and location, and then click Next.
  6. Continue clicking Next and accepting the default settings until you arrive at the Specify DBA User and Password page.
  7. By default, the database is created with an administrator account called DBA, and with a password sql. Select these defaults or enter your own, and then click Next to go to the Connect to the Database page.
    Note You will need to enter this username and password in the repository definition (see Installing the Repository to the Server) and data source (see Installing a Local Test Repository).
  8. Deselect the Connect to the new database option, and then click Finish to create the database.