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
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
