Search code examples
databasesqlitewindows-mobilecab

Extract cab file and use the database

I found an old windows mobile dictionary application and I want to get the database. I extract it but I don't know how to convert it to csv or sql file. Have anybody idea about it ?

You can download the file from here http://www.mediafire.com/download/z32xgmc9fia3nr2/OGD.Akilli.Sozluk.CAB

And I use Ubuntu.

Solution

  • SQLite makes available the C source code to compile a shell program which can be used to do this. It's apparently also included by Ubuntu. Here is the man page for the sqlite shell included with Ubuntu. Please review the documentation as there are a few ways to convert to CSV or get the schema of a table.

    Alternatively, you can use a 3rd party tool to view the database in a GUI. I can't speak for Linux solutions, but Firefox has a 3rd party plugin called "SQLite Manager" that will let you use SQLite files in a GUI if you prefer it that way.