On Jul 24, 2009, at 8:37 AM, CityDev wrote: > > I'm new to SQLite. I would assume you would dump the tables to an > external > format and then load them into the new database. I can't however see > where > the documentation is for this kind of database management function. > Anyone > know where I should look, or do you have to download the SQLite3 > application > to see it?
SQLite database files are cross-platform. All you have to do is copy the file to the new machine. There is no separate "external format". The same database file format work on all platforms. I think the OP was asking what changes need to be made to SQLite in order to get it to compile and run on a platform other than the ones that are supported out of the box (unix, win32, os/2). Here is a quick summary: (1) Write a VFS implementation for the target platform. Use the os_unix.c, os_win.c, and os_os2.c files as a guide, if you like. See also the documentation on the sqlite3_vfs object. (2) Compile the amalgamation using -DSQLITE_OS_OTHER. This disables the built-in OS interface layer. (3) Before using SQLite in your application, call sqlite3_vfs_register() to install your alternative OS driver. D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users