Local Database#

Storage Location#

Colectica Designer’s local database is stored in a file named %appdata%\Algenta\Colectica\designer.s3db. This file can be copied to create a backup of the local database.

Manage Local Database#

To manage the local database, use the File - Manage Local Database menu item.

Clean up all items#

  • Description: Deletes all items from the local database if they are not part of a checkout.

  • Use Case: Use this option to remove unneeded local data while preserving checked-out items.

Clean up changed items#

  • Description: Deletes modified items from the local database if they are not part of a checkout.

  • Use Case: Use this option to discard changes to local items that are not in a checkout. This can be used to revert local changes.

Repair Local Database#

  • Description: Ensures all items have a most recent version indicated in the database.

  • Use Case: This is only necessary after upgrades from prior to version 6.1.

Delete all items#

  • Description: Deletes all items from the local database.

  • Use Case: Use this option when you need to completely clear all locally stored items.

Reset Synchronization Status#

  • Description: Manually marks all local items as unchanged and synchronized with the repository.

  • Use Case: Use this option if synchronization issues arise, ensuring local items are treated as up-to-date.

Notes#

  • Actions that delete items will only affect local copies; repository items remain untouched.

  • Ensure that you have backed up important data before performing any cleanup or deletion operations.