Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » Tutorial: Creating a SQL Anywhere database

 

Lesson 1: Creating a database file

Create a database file to hold your data. The database file contains system tables and other system objects that are common to all databases.

Prérequis

This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Creating a SQL Anywhere database.

 Task
  1. Start Sybase Central. Click Start » Programs » SQL Anywhere 16 » Administration Tools » Sybase Central.

  2. Start the Create Database Wizard. Click Tools » SQL Anywhere 16 » Create Database.

    1. On the Welcome page, click Next.

    2. Click Create a database on this computer, and then click Next.

    3. In the Save the main database file to the following file field, type c:\temp\mysample.db.

      If your temporary directory is somewhere other than c:\temp, specify the appropriate path.

    4. On the Specify DBA user and Password page, specify the DBA user ID and password. By default, the user ID is DBA and the password is sql. However, it is recommended that you change these settings to ensure that your database is secure.

    5. Click Finish and then click Close.

      You are automatically connected to the database as the DBA user.

Résultat

You have created and connected to a database.

 See also