Create script from existing database in SQLite 3

Question

Do you know any way to create sql script from existing database in SQLite 3?

What kind of script? Also note that tool recommendations are off-topic on stack overflow but this question probably can be edited to be not about tools but rather methods. — laalto, Oct 08 '14 at 06:44
Have you tried reading the [documentation](http://www.sqlite.org/cli.html)? — CL., Oct 08 '14 at 06:49
http://stackoverflow.com/questions/75675/how-do-i-dump-the-data-of-some-sqlite3-tables — Ian Kenney, Oct 08 '14 at 07:24

score 8 · Accepted Answer · answered Oct 08 '14 at 06:57

8

I need to create tables and insert script.

You can use the sqlite3 command line tool and use .dump to output the SQL that creates the database schema and inserts the data there.

answered Oct 08 '14 at 06:57

laalto

1 Answers1