source

How to export/backup Room Db and View all the tables using sqlite viewer.

When you are playing with Room, you need to view the schema and data in the tables. For that you need to export the db.

String currentDBPath = getDatabasePath("your_db_name").getAbsolutePath();

The above code will give you the path to db. you can programmatically export it or you can do it via command line.

These are the step to export db from command line.

adb -d shell "run-as <your_package_name> cat /data/data/<your_package_name>/databases/your_db_name" > <your_db_name>.db

remove -d if you are pulling from emulator.

Then you need a tool to view the db.

1. https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/
2. http://sqlitebrowser.org/
3. http://sqliteviewer.flowsoft7.com/

that’s all … Done !!