[geek1011]

If you just want annotations, I suggest you copy your books into the exact same structure on your new Kobo, let them import, copy just the bookmark table to the new database. Note that I've only tested this with kepub books, so I don't know how this will interact with other formats.

If you want reading stats, you can also copy rows from the event table with type 46 from the old DB, and they should work fine (the checksum doesn't include other data except for the row itself).

If you want collections, the best way to do so is to log in to your Kobo account (this will restore them as empty collections), then copy rows from the ShelfContent table with a ContentId starting with file:/// (this also depends on the directory structure remaining the same).

If you want read/unread states, copy the ReadStatus column where set for rows of the content table with a NULL BookId and a ContentId starting with file://.

If you want reading settings (font, last dictionary, search history, etc), copy rows from the content_settings table with a ContentId starting with file://.

If you want My Words, copy the wordlist table.

This covers most of the possible things you can copy from the DB (even between versions) without causing issues.