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 way (having the old database and the new one) to obtain a file with the differences. Something like this:
--------------------------- Difference file-------------------------------------- table1 +column1=value1;column2=value2 -column1=value2;column2=value4 table2 +column1=value5;column2=value6 -column1=value7;column2=value8 --------------------------- End of difference file-------------------------------------- Where the "+" indicates a new register in the database and the "-" indicates the deletion of the register. Thanks in advance. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
