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.
-- Loading resources from script.sql then Error: incomplete SQL: |- (| beeing a rectangle), while sqlite3.exe shell for the same command gives me just a new line ...> Either way not much of an error message, no line number, no nothing. Is that typical?
script.sql must be valid - it clearly isn't. I'd suggest to debug your script line by line. In windows, you should install SQLite Expert Personal and use this GUI to carefully debug your script - there is something wrong in it.
Put sqlite3.exe wherever you want, as long as you remember that place and you're able to start sqlite3 from there.
Applying a script to a database (maybe a newly-created one), in command prompt:
sqlite3.exe my-new-db.somesuffix < myscript.sql
Executing a script within interactive sqlite3 session:
sqlite3.exe my-new-db.somesuffix
....
.read myscript.sql
....
Both variants are valid and usable at times. (Note: if your .sql was generated for non-sqlite database, I'd expect that it will require some changes to work in sqlite3. And things like stored procedures and user-defined functions will be definitely lost).
Error: incomplete SQL: |-, and from sqlite3 shell it just gives more ....> lines when hitting enter, no message. In neither way any database file was created. Is that all I can expect for error message?
incomplete SQL is probably caused by syntax differences between sqlite and your source database, we can't solve it without looking at the code. As of the ....> prompt in sqlite shell, I think you omitted the leading dot before read. It should be .read and not just read. (Why everyone asking questions feels so confident when it comes to editing commands provided in the answers?)select 1 as result -- but then it can be a file of size 0). You can work with an existing empty database if you prefer, but it's better to start from scratch each time while you're debugging your script (otherwise you'll have to solve problems with objects already existing from previous attempts: add DROP TABLE IF EXISTS... before each CREATE TABLE, etc).Although the thread is years old but I have not seen anywhere the option I propose:
set "database=example.db"
%~dp0sqlite3.exe -cmd ".read script.sql" %database%.
This option after executing the script leaves open a command window with sqlite running and the database open.
