Re: [sqlite] Clone SQLite databases

use Sqlite3_Prepare_v2, it has a parameter Stmt:pointer; but I dont know how to work with this and obtain for example: PRAGMA page_size; ---> 26 Again, thanks to everyone for help, and if someone can help me in this final problem I will appreciate. csabi81 wrote: > > I have done aga

Re: [sqlite] Clone SQLite databases

PRAGMAs? this is the only thing I can imagine that can affect the cloned database file. :( Thanks to all csabi81 wrote: > > Thanks Steve, I think I am on the right way. > It is a difference between the page sizes of the two databases. I have > opened each database with Firefox SQ

Re: [sqlite] Clone SQLite databases

ck with "PRAGMA page_size;" or sqlite3_analyzer program. > > Thanks >Steve > > csabi81 wrote: >> 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

Re: [sqlite] Clone SQLite databases

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 WHERE... order by id;" on the >> original &

Re: [sqlite] Clone SQLite databases

ndexes and > the data is there. > > How about triggers? Views etc? > > > > --- On Tue, 8/5/08, csabi81 <[EMAIL PROTECTED]> wrote: > From: csabi81 <[EMAIL PROTECTED]> > Subject: Re: [sqlite] Clone SQLite databases > To: sqlite-users@sqlite.org > Dat

Re: [sqlite] Clone SQLite databases

Yes I have Indexes in original database, but I create them in the clone, useing the SQL obtained from mastertable, as well as the TRIGGERS. Stephen Woodbridge wrote: > > csabi81 wrote: >> Hi everyone >> >> I want to clone a database: copy all data from original databa

Re: [sqlite] Clone SQLite databases

t;   > You could use the .output command selecting the data to different files > (use an order by clause) then compare the two files. >   > HTH > > --- On Tue, 8/5/08, csabi81 <[EMAIL PROTECTED]> wrote: > > From: csabi81 <[EMAIL PROTECTED]> > Subject: R

Re: [sqlite] Clone SQLite databases

Thanks for Reply. I have tried VACUUM, nothing happens. The original database file remains the same size as before. What I create in the new database are Tables, Indexes and Triggers as well. I dont know if anything escapes from me. Mihai Limbasan wrote: > > csabi81 wrote: >>

[sqlite] Clone SQLite databases

Hi everyone I want to clone a database: copy all data from original database to the destination database with a condition, so not all the entries need to be copied. I have tried the following: Obtain SQL from mastertable and create the tables in the new database, and using INSERT to copy all