Re: [sqlite] Best way to compare two databases

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 rem

Re: [sqlite] Best way to compare two databases

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 remote DBs. You may have deletions and update and would need to take them into account when you are doing the diff

Re: [sqlite] Best way to compare two databases

"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

I think it is important 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 f

RE: [sqlite] Best way to compare two databases

Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Juan Perez Sent: 05 September 2006 09:13 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Best way to compare two databases 2006/9/5, JP <[EMAIL PROTECTED]>: > Assumming that the clients will NOT chang

Re: [sqlite] Best way to compare two databases

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 the

Re: [sqlite] Best way to compare two databases

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

(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 dif

Re: [sqlite] Best way to compare two databases

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 an

Re: [sqlite] Best way to compare two databases

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 actualization

[sqlite] Best way to compare two databases

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 actualization system. So, what is the best wa