Export and Import SQLite data from LC Project?
warren at warrensweb.us
Tue Oct 25 16:44:50 EDT 2011
On 10/25/2011 02:34 PM, Mark Schonewille wrote:
> Hi John,
> Can't you transfer the entire database file? If not, you can just do a dump and import the resulting file or do a query and save the data to a text file, which you import the usual way.
> Best regards,
> Mark Schonewille
Mark is correct. This is from the "Distinctive Features" page provided
"Single Database File
An SQLite database is a single ordinary disk file that can be located
anywhere in the directory hierarchy. If SQLite can read the disk file
then it can read anything in the database. If the disk file and its
directory are writable, then SQLite can change anything in the database.
Database files can easily be copied onto a USB memory stick or emailed
Stable Cross-Platform Database File
The SQLite file format is cross-platform. A database file written on
one machine can be copied to and used on a different machine with a
different architecture. Big-endian or little-endian, 32-bit or 64-bit
does not matter. All machines use the same file format. Furthermore, the
developers have pledged to keep the file format stable and backwards
compatible, so newer versions of SQLite can read and write older
You don't need to do anything other than copy the database file.
More information about the Use-livecode