Song Database Migrations

Jump to: navigation, search

Please note: this page is obsolete and should not be referenced any more.

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.

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

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