Greetings!
I need to be able to create a database with a known schema from inside a program. I used sqlite3.exe's .schema command to export the SQL needed to create the schema for my new database. I can create the database by the following steps: C:\: sqlite3 newdatabase.db Sqlite3> .read schemafile.txt At that point, my database is ready to go. But, sqlite3 is supposed to be able to accept commands on its command line. For example, the schema file was generated using this command: C:\: sqlite3 existingdatabase.db .schema > schemafile.txt So, I thought I could just issue the following command from inside my program: Sqlite3 newdatabase.db .read schemafile.txt But, when I issue this command from the DOS prompt, it gives me an error message saying that there is no command named "read". (Note the lack of a leading period.) If this won't work from a DOS prompt, I'm sure it won't work from my program. So, what is the recommended way to create a new database and its schema from inside a program? In case it matters, I'll be using Visual C# 2005 and the SQLite.net.dll file from SourceForge. Thank you very much! Rob Richardson RAD-CON INC.