On 6 Jul 2010, at 10:42pm, Peng Yu wrote: > I could create tables in database B to select all the data from > database A and insert them in B. I don't find any simpler way to copy > all tables from A to B. But I may miss something. > > I'm wondering if there is a very simple single command that can just > copy all the tables from database A to database B. Could you please > let me know?
If you are not worried about other users who may be using the database at the same time, then you can simply use file commands to copy the database file as a normal file on disk. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
