Song Database Migrations

Introduction
This page details the steps required to convert a version 1.x openlp songs database to the new openlp 2.x version.

The process involves dumping the sqlite database, converting the encoding, loading it into a sqlite3 database and then adjusting the schema.

Windows prerequisites
On Windows it is first necessary to download and install sqliteodbc.exe: Sqlite ODBC Driver

Conversion
The rest of the steps are all handled in a single python script.

jonathan@crumble:~ $ openlpcnv.pyw

On Linux, this will take the v1 database from: ~/.local/share/openlp/songs/songs.olp and create the v2 database: ~/.local/share/openlp/songs/songs.sqlite

On Windows, this will use the v1 database from it's installed location: C:\Documents and Settings\All Users\Application Data\openlp.org\data\songs.olp and create a new v2 database in: C:\Documents and Settings\you\Application Data\openlp\data\songs\songs.sqlite