Trying to convert an SqlCe database to SQLite, I export it to a .sql
file. Now how would I use sqlite.exe
to create a database from this .sql
file?
Where to put the sql3.exe
file?
What command syntax to use, in cmd prompt or in the sqlite.exe
shell?
Use following command line:
sqlite3 -init dump.sql newsqlite.db ""
It will create new SQLite database file newsqlite.db
by executing statements from dump.sql
. Empty string ""
is needed for sqlite3 to quit automatically.
If newsqlite.db
file already existed with some data, import may fail unless you use IF NOT EXISTS
for all table and index creation statements.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With