Automating the creation of a SQLite database from a batch file

Question

On a windows platform I have the following:

• schema.sql (contains the sql scripts)
• sqlite3.exe (command shell for sqlite -> downloaded from sqlite.org)
• build.bat : A batch file with the line : sqlite3.exe -init schema.sql default.db3

When I run build.bat, the database is created as expected, however, the sqlite shell doesn't automatically terminate. So how would I get the batch file to run and terminate the sqlite command shell automatically?

E.g. output:

  C:\Work\X\Database>sqlite3.exe -init schema.sql default.db3  
  -- Loading resources from schema.sql  
  SQLite version 3.7.4  
  Enter ".help" for instructions  
  Enter SQL statements terminated with a ";"  
  sqlite>  

Answer 1

Try to call it like that:

echo .quit | sqlite3.exe 

Or put .quit in the end of your file.

Answer 2

It seems (since you haven't shown its contents) that the bat file is missing the exit statement. You can add it yourself:

sqlite3.exe -init schema.sql default.db3 .exit