I am trying to run a Data Pump from SQLite to MS SQL Server.


Error message

Could not open database: D:\xxxx\DB.sqlite. [FireDAC][Phys][SQLite] ERROR: Cipher DB is not encrypted.


Resolution

If you have not created the SystemWeaver tables for use with the target MS SQL server then you will receive this error. See Creating SystemWeaver Tables in How to Copy SQLite Database to MS SQL Database. This must be done with the swDatabaseManager before you pump the data over.