How to create db file with SQLiteStudio

Question

I have created the database for my Android app using SQLiteStudio 3.0.5 and now I need to save/export the one as .db file, but i found only the export to .sql-file. So, what should I do to make such procedure?

score 3 · Accepted Answer · edited May 18 '17 at 23:58

3

When you create database in SQLiteStudio it already is a proper sqlite database file. If you need to name it with .db extension, just rename the file in any file manager.

edited May 18 '17 at 23:58

OneCricketeer

179,855
19
132
245

answered Sep 07 '16 at 09:09

Googie

5,742
2
19
31

@Kitwradr I didn't write this answer – OneCricketeer Nov 11 '18 at 17:30

score 1 · Answer 2 · answered May 18 '17 at 23:56

1

It sounds like you are trying to export the SQL command, and not the database itself.

Right-click on the database, and select "Export the database".

answered May 18 '17 at 23:56

Adam Howell

415
1
11
24

How to create db file with SQLiteStudio

2 Answers2