Export and Import SQLite data from LC Project?

Warren Samples 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 
by SQLite:

"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 
for sharing.

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 
database files."

You don't need to do anything other than copy the database file.

Warren




More information about the Use-livecode mailing list