NAME

migrate-to-sqlite.pl - One-time migration from BerkeleyDB to SQLite storage

SYNOPSIS

migrate-to-sqlite.pl [--dry-run] [--suite SUITE] [--verbose] [--delete-old]

DESCRIPTION

Migrates ApTest Manager data from BerkeleyDB (.dbm) files to SQLite (.sqlite) files for all authoritative data classes. Pure cache classes (CacheFile, CacheDB, ReportCache) are NOT migrated — they rebuild automatically on first access after the migration.

This script is designed to be run once during upgrade to ATM v3. It is safe to run multiple times (idempotent): keys already present in SQLite are overwritten with the BerkeleyDB values to ensure consistency.

Original .dbm files are preserved unless --delete-old is specified.

OPTIONS

--dry-run

Report what would be migrated without writing any SQLite files or modifying any data.

--suite NAME

Migrate only the named suite (default: all suites are migrated).

--verbose

Print per-key progress during migration.

--delete-old

Remove .dbm and .set flat files after successful migration of each file. Opt-in only. Validate migration results before using this flag.

Copyright © 2000-2013 Applied Testing and Technology, Inc. All rights reserved.