Skip to main content

Convert Legacy Database

Overview​

The Convert Database tool converts legacy iPool databases from Microsoft Access format (.mdb or .accdb) to the SQLite format (.db) used by iPool Suite. For the full reference, see Convert Database.

What It Is​

The tool offers three conversion modes:

  • Single file — (Desktop and Web) converts one .mdb or .accdb to one .db.
  • Multiple files (Whole folder) — (Desktop app only) batch conversion of a folder of .mdb or .accdb files.
  • Regional to Zonal — (Desktop app only) restructures an existing regional SQLite .db into zonal format.

You do not need to have a database open to run a conversion. For full details on each mode, see Convert Database.

When to Use It​

Use Convert Database when you receive a legacy iPool database in Microsoft Access format that needs to be opened in iPool Suite, or when you need a zonal-format database from an existing regional .db file. After conversion, open the resulting .db file with Open Database in the Database Editor tab.

Command-Line Interface (CLI)​

The iPoolSuite.exe CLI supports MDB-to-DB conversion and Regional to Zonal conversion via the -updatedb flag.

Mode 4 — Regional to Zonal:

iPoolSuite.exe -updatedb -setzones -o <input-database.db>
iPoolSuite.exe -updatedb -setzones -o <input-database.db> -s

-o specifies the input database. The output path is auto-derived (for example, SysWESM2606.db → SysWESM2606Z.db). Without -s: dry run. With -s: performs the conversion.

Mode 5 — MDB to DB (single file):

"C:\Program Files\iPool\iPoolSuite.exe" -updatedb -conv -o <file.mdb>

Mode 5 — MDB to DB (all files in DirDB):

"C:\Program Files\iPool\iPoolSuite.exe" -updatedb -conv

The .mdb source files are kept; an existing .db of the same name is replaced. For the complete move from an earlier iPool, see Migrating to iPool Suite.

For full flag descriptions, see iPool Suite Commandline Options.