I have made .dump for each database, original and clone, and saved into separated files. Than compare them. Differences are in INSERT INTO entries, in the clone database those entries are missing which I did not copy from the original. But the CREATE TABLE, CREATE INDEX, CREATE TRIGGER Commands are the same 100%
Derrell Lipman wrote: > > On Tue, Aug 5, 2008 at 10:31 AM, csabi81 <[EMAIL PROTECTED]> wrote: > >> >> I have made the test with following results: >> Useing "SELECT ALL * FROM <tablename> WHERE... order by id;" on the >> original >> database and >> "SELECT ALL * FROM <tablename> order by id;" on the cloned database give >> me >> the same results. >> outputing the results from SELECT in different files give me two 100% >> identical files. > > > You might also try doing ".dump" on each database from the sqlite shell > and > compare the CREATE entries for tables, triggers, etc. to ensure that they > were created identically. > > Derrell > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/Clone-SQLite-databases-tp18827472p18846161.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
