How do I create a sqlite 3 (.sl3) database file?

I have a *.sqlite file... but I need the database in *.sl3 format? What software/tool can I us to create that?

What are the steps?

This is to be used in an iPhone app. Original developer used an .sl3 file, now that I have updated the DB - I can't seem to export/generate a .sl3 file

I have tried just changing th开发者_开发技巧e extension - all the way to inserting the *.sqlite file in XCode and pointing the app delegates to the new DB file format... doesn't work.

Thanks in advance...

---

If you open sqlite3 database with SQLITE_OPEN_CREATE you create the database if it does not exists (Documentation of sqlite3_open). You can dump database from CLI by dump command.

---

Just rename the file. SQLite doesn't care about file extensions. You could call it "mydatabase.froggy" if you want.

Update: Reading more closely, I see you've tried renaming it. That should work, as I mentioned above. What kind of error are you seeing?