EN FR
Sign in Get Fic2All

Convert HFSQL to SQLite

Turn HFSQL Classic data into a single SQLite file you can open anywhere, with no server to install, and get a report proving every table was copied.

Last reviewed: November 2, 2026

Why move HFSQL data to SQLite

SQLite stores an entire database in one file. There is no server to set up, which makes it a convenient format for archiving a legacy database, handing a dataset to someone else, building a test copy, or embedding data in a desktop or mobile application.

Almost every language and many data tools can open a SQLite file. Fic2All reads your HFSQL tables through the driver and writes them to that file, then reports rows read versus rows written for each table.

SQLite is a good fit if…

  • you want a portable archive of your HFSQL data that stays readable for years.
  • you need a quick local copy for analysis, testing or a prototype.
  • your next application embeds its database instead of calling a server.

How the conversion works

  1. Choose your data folder. Fic2All lists the tables it finds, each with a clear status: Ready, Protected or Error.
  2. Unlock protected files. If a file is protected, Fic2All asks for its password. It is used for that file only and is never stored.
  3. Connect to SQLite. Enter the connection details and test them before you start. You can save the connection as a profile for the next project.
  4. Convert. Each table is processed on its own, with progress per table. A problem on one table does not stop the others.
  5. Read the report. For every table, rows read versus rows written. Rejected rows are listed with the row, the column and the database error.

Before you start

  • Windows 10 or 11 (Fic2All is a desktop app that runs on your machine).
  • The HFSQL ODBC driver published by PC SOFT, installed once from their official site.
  • Your HFSQL Classic data (.FIC and .MMO files) and, next to them, the project analysis (.wdd) that describes the tables.
  • The destination path for the SQLite file that Fic2All will create or fill.
  • The password of any protected file, if there is one.

The HFSQL ODBC driver, explained

Proof, not hope: the verification report

A migration is only finished when you can show nothing was lost. Fic2All ends every run with a report that compares, table by table, the rows read from your HFSQL files with the rows written to SQLite. If rows were rejected, the gap is visible and each rejected row is listed, so nothing disappears silently.

How to verify an HFSQL migration

Questions

Do I need a database server for SQLite?

No. You choose a destination file and Fic2All writes the tables into it. There is nothing to install or configure on a server.

Does it change my source files?

No. Fic2All only reads your source files. Nothing is ever written to them.

Do I need WinDev or HFSQL installed?

You do not need WinDev. Fic2All reads your files through the HFSQL ODBC driver published by PC SOFT, which you install once from their official site. If the driver is missing, Fic2All explains it and points you to the download; the rest of the work is unaffected.

What if some rows cannot be written?

Rejected rows are counted and listed with the row, the column and the database's error message. The report shows the gap for that table, so nothing disappears silently.

Ready to move your HFSQL data?

Pick a plan, install Fic2All and let the verification report do the checking.

See plans and pricing

Keep reading