Convert REALSQLDatabase to SQLite Database

Databases
1

I have an older application that uses a REALSQLDatabase I would like to upgrade to SQLite Database. The older database file when I do a DB.LibraryVersion on the REALSQLDatabase it is 3.7.14.1 while the current version of SQLite is 3.8.5 and any new DBs I create are also 3.8.5.

What is the most efficient method to convert this old DB file to a newer SQLite version?

I am a bit confused… Moving forward with SQLite should the DB File need to be updated when the new library is released?

2

There is nothing to convert from a DB perspective. Both are SQLite v3 file formats.

You may need to update some Xojo code to use transaction differently. More information can be found in the Upgrade Guide (Help->Upgrade Guide).