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

SQL Anywhere 12.0.0 » UltraLite - Database Management and Reference » Introducing UltraLite » UltraLite storage and file name conventions


UltraLite temporary files

In addition to the database file, UltraLite creates and maintains a temporary file during database operation. You do not need to work with or maintain the file in any way.

By default, UltraLite maintains its temporary file in the same folder (if one exists) as the UltraLite database itself. The temporary file has the same file name as the database, but has a few differences.

For file-based platforms the tilde is included in the extension of the file. For example, if you run the CustDB.udb sample database, the temporary file called CustDB.~db is maintained in the same directory as this file.

For record-based platforms you can setup UltraLite to save the temporary file in another location by supplying the TEMP_DIR connections parameter. See UltraLite TEMP_DIR connection parameter