See the database section of the installation guide for guidance on the difference between the supported backends.
In 1.4 a script has been provided to enable users to migrate between the supported backends for a given version of OpenDNSSEC. The script is located here:
enforcer/utils/convert_database.pl
In 1.4 the supported backends are SQLite and MySQL.
You must create the MySQL database and database user manually before converting to MySQL.
If users wish to convert to another OpenDNSSEC version you need to migrate existing database to that version first - see Migrating from earlier versions of OpenDNSSEC.
enforcer/utils/convert_database.pl --from dbi:SQLite:dbname=/var/opendnssec/kasp.db --to dbi:mysql:database=kasp;host=localhost --to-username <username> --to-password <password>
enforcer/utils/convert_database.pl --from dbi:mysql:database=kasp;host=localhost --from-username <username> --from-password <password> --to dbi:SQLite:dbname=/var/opendnssec/kasp.db
Also see the MIGRATION file in the source code.
