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

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Introduction » Overview of Data Management Technologies » Inside SQL Anywhere

Inside the database server Next Page

Database files

The following sections provide an overview of the type of files, including database, transaction, and temporary files, that comprise a database. The differences between the implementation of these files in SQL Anywhere and UltraLite is also discussed.

SQL Anywhere database files

All the information in a SQL Anywhere database is usually stored in a single database file, which can be copied from one computer to another. It is possible have a database made up of several files, but this is generally only required for very large databases.

In addition to the database file, SQL Anywhere uses two other files when running a database: the transaction log and the temporary file.

Inside the UltraLite database

UltraLite databases contain the same features as described above with the following exceptions:

See UltraLite transaction and state management.