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

SQL Anywhere 17 » SQL Anywhere Server - Database Administration

Database creation

To create a database, you define the tables it will have (entities), the columns in each table (attributes), and the relationships between tables (keys and constraints).

You can use SQL Central, the initialization utility (dbinit), and the CREATE DATABASE statement to create or initialize a database. After creating the database, you can connect to it and add tables and other objects.

Transaction log

When you create a database, you must decide where to place the transaction log. This log stores all changes made to a database, in the order in which they are made. In the event of a media failure on a database file, the transaction log is essential for database recovery. It also makes your work more efficient. By default, it is placed in the same directory as the database file, but this configuration is not recommended for production use.

Database file compatibility

Database files are compatible among all operating systems, except where file system file size limitations or support for large files apply.

A database created on any operating system can be used on another operating system by copying the database file(s). Similarly, a database created with a personal database server (dbeng17) can be used with a network database server (dbsrv17). Database servers can manage databases created with earlier versions of the software, but old servers cannot manage newer databases..