Creating a Database to Contain the Repository

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

1. Select Start > Programs > SQL Anywhere 12 > Admin Tools > Sybase Central to open Sybase Central.
2. Select Tools > SQL Anywhere 12 > Create Database 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 Creating a Data Source to Access Your Database).
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 Creating a Data Source to Access Your Database).
8. Deselect the Connect to the new database option, and then click Finish to create the database.