CODEWITHSUNDEEP
databasesqliteimportdb-schemadbimport
Anirudh
Anirudh

Reputation: 147

How to create a DB file in sqlite3 using a .schema file

Our client has provided us with a file named db.schema. Now is there a command which I can use to run this file to create a .db file in sqlite3? Can I do this without having to type in all the queries mentioned in the db.schema file?

Please help! Thanks!

Upvotes: 11

Views: 17415

Answers (2)

Super Kai - Kazuya Ito
Super Kai - Kazuya Ito

Reputation: 1

For example, you can import db.schema into orange.db with these ways as shown below. *orange.sql is created if it doesn't exist and my answer explains it more:

sqlite3 orange.db < db.schema

Or:

sqlite3 orange.db
...
sqlite> .read db.schema

Upvotes: 0

CL.
CL.

Reputation: 180010

If that file contains only SQL commands in the correct format, get the sqlite3 command-line tool, and run it like this:

sqlite3 mydatabase.db < db.schema

Many SQLite administration tools also have functions to import such a file.

Upvotes: 23

Related Questions