Ray Kiddy <[EMAIL PROTECTED]> wrote: > Hello - > > I tried to use an older version of the sqlite3 executable on Mac OS X > with a data file from a newer version. No joy resulted. > > Looking at http://www.sqlite.org/changes.html, I do not see any notes > about whether any version breaks binary compatibility with any older > version. > > Should it just be assumed that any version change breaks all binary > compatibility with earlier versions? Is this done deliberately? Or is > there somewhere else that issues relating to binary compatibility of > data files between versions is documented? >
The database file for all versions of SQLite are backwards compatible for all versions of SQLite going bach through version 3.0.0. Any newer version of SQLite can read and write database written by older versions of SQLite. For the most part this works in the opposite direction too - older versions of SQLite can read and write databases created by newer versions of SQLite. The exception is if the newer version of SQLite created database that uses some feature that was added after the older version of SQLite was released. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
