By default, CafeTran creates a database file for Total Recall inside CafeTran's installation directory (or inside CafeTran application package on Mac OS X). You can easily change this location as follows:

  1. Go to Edit > Preferences > General tab.
  2. Click the "Database connection:" button.
  3. Change the default path in the Connection URL field to your preferences.
  4. Click the OK button and restart CafeTran.

The definition of the URL location path for the SQLite database is jdbc:sqlite:database_file_path. Here are a few examples:
  1. jdbc:sqlite:C:/work/mydatabase.db (for Windows operating systems).
  2. jdbc:sqlite:/Users/igor/work/mydatabase.db (for Mac operating systems).