Howto: SQLite Scripts

1. Install SQLite (i.e sqlitestudio-3.1.1)

2. Open sqlitestudio\SQLiteStudio.exe

3. Database, Add a database (source)

   1. Type: SQLite3
   2. File: Select PIM database file (i.e companionlink20180605.db )
   3. Name: Write a name without extended characters (i.e companionlink)

4. Database, Add a database (target)

   1. Type: SQLite3
   2. File: Select PIM database file (i.e omni-notes ) (by default it only display files with extension .db, change to ALL files)
   3. Name: Write a name without extended characters (i.e omninotes)

5. Tools, Open SQL Editor (or Alt-E), Paste code in window, Query tab

6. Execute Query (or F9)