Re: [sqlite] Best way to compare two databases

2006-09-06 Thread Juan Perez
Thanks to all for the answers. I will analize then and work in it... 2006/9/5, John Stanton <[EMAIL PROTECTED]>: You could use brute force and ignorance. Keep a master copy of your database in SQL form and do a diff on the SQL form of the new DB, then export the changes as SQL to update the

Re: [sqlite] Best way to compare two databases

2006-09-05 Thread drh
"Juan Perez" <[EMAIL PROTECTED]> wrote: > > I have developed a program that uses a sqlite database. > Until now the users downloaded an entire new version of the > database weekly from the FTP server. > But now the database is too big (about 500.000 records) and i want > to make a database

RE: [sqlite] Best way to compare two databases

2006-09-05 Thread Denis Povshedny
nt to see how big your diffile will be. Hope it helps! WBR, Denis. -Original Message- From: Juan Perez [mailto:[EMAIL PROTECTED] Sent: Monday, September 04, 2006 9:17 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Best way to compare two databases (excuse me for the other mail, i clicked a

Re: [sqlite] Best way to compare two databases

2006-09-05 Thread Juan Perez
2006/9/5, JP <[EMAIL PROTECTED]>: Assumming that the clients will NOT change the original database, I can think of 2 methods: 1. Whole DB: drop all indices, then vacuum, then zip, then propagate. On the clients (suscribers), unzip, re-create all indices. 2. Incremental, add a field to stamp

Re: [sqlite] Best way to compare two databases

2006-09-04 Thread JP
Assumming that the clients will NOT change the original database, I can think of 2 methods: 1. Whole DB: drop all indices, then vacuum, then zip, then propagate. On the clients (suscribers), unzip, re-create all indices. 2. Incremental, add a field to stamp the date on all your records, then

Re: [sqlite] Best way to compare two databases

2006-09-04 Thread Juan Perez
(excuse me for the other mail, i clicked accidentally the button...) Hi: I think that i explained me bad. In my work i do next until now: Phase 1: I generate automatically a database from a CRM Phase 2: I put the database in the FTP for the commercials of the enterprise. They are located in

Re: [sqlite] Best way to compare two databases

2006-09-04 Thread Juan Perez
Hi: I think that i explained me bad. In my work i do next work: I generate automatically a database from a CRM 2006/9/4, Paul Smith <[EMAIL PROTECTED]>: At 16:48 04/09/2006, you wrote: >Hi all: > > I have developed a program that uses a sqlite database. > Until now the users downloaded

Re: [sqlite] Best way to compare two databases

2006-09-04 Thread Paul Smith
At 16:48 04/09/2006, you wrote: Hi all: I have developed a program that uses a sqlite database. Until now the users downloaded an entire new version of the database weekly from the FTP server. But now the database is too big (about 500.000 records) and i want to make a database