Pages

29/04/2020

Extract SQLite Database from Android Application




I have developed an Android Application for the demo purpose and I have installed it on My Android Mobile.

In Android Device:
STEP 1:


Now, I am pressing the "Register" button.

STEP 2:


   

Then, I am registering a User with Username as "Software", Password as "1234", Name as "AKarthikSoft", Phone Number as "0123456789" and EMail Address as "a.karthiksoftware@gmail.com". Then, I am pressing the "Register" button.

STEP 3:


Now, I am giving the Username as "Software", Password as "1234". Then, I am pressing the "Login" button.

STEP 4:
After Login, It will show the Last Login Time.


In Android Studio:
STEP 1:
I am opening Android Studio with same or any project.


STEP 2:
Now, I am connecting My Android Mobile in which that Android Application is installed.


STEP 3:
I am clicking on the "Device Explorer" option on the bottom right corner.


STEP 4:
Now, I am choosing the device in which that Android Application is available.


STEP 5:
I am navigating to the path "data/data". Then, I am choosing the application with its package name. Now, I am navigating to the "databases" folder. From that, I am right clicking on the database file and choosing the "Save as" option.


STEP 6:
Then, I am choosing the path in which that Database file have to be saved with the Name for the Database File and then, clicking on the "OK" button.


STEP 7:
Then, the Database File is saved to the specified path and specified name.




STEP 8:
I am opening this Database file with "DB Browser for SQLite" Software. You can download this "DB Browser for SQLite" from Here.


I am clicking on the "Browse Data" tab.

STEP 9:
Now, It will show all the data provided by me in the Android Application.






NOTE:
1) This Video is for Developers only.
2) This method will only work with the Android Applications installed from Android Studio or Eclipse.
3) This method can also works fine to extract the Realm Database also.
4) This method will work with both the Emulator and USB Debugging enabled Android Devices.

Other Related Links