Synchronization

[Lotiara]

Hi All,

I am testing Unidac Components and don't know how to do a simple thing.
I have an application which is connected one or two times a day with an MySQL server and uses a local SQLite database.

What is the best way to manually synchronize two identical tables ?
TUniscript, TUniloader, TUnidump ?
I don't want to use some server replication mechanism, I want to trigger the synchro myself and basically make an algorithm like:

select * from LocalDB.Invoices where sincro > mylastsincro.
UniDump/UniScript/whatever.CahedUpdates;
starttransaction
While ther are fields
--->insert fields into UniDump/UniScript/whatever
endWhile
UniDump/UniScript/whatever.excecutesql
UniDump/UniScript/whatever.Applyupdates;
commit;



BTW any opinion about SQLlite vs EmbeddedMYSQL

Thank you for your time.

[AlexP]

Hello,

For resolving your synchronization task, the optimal decision will be to use our TCRBatchMove component (it is on the Data Access tab), which is designed for automatic data transfer between DataSets, and provides for several modes of data transfer. You can find more details on this component in the UniDAC help. The DB choice depends on the tasks to solve, therefore it is rather difficult to compare these two DBs abstractly. There are links to the websites of these DBs developers below, where the main features of these DBs are represented, so you can compare them in agreement with your tasks.

http://www.sqlite.org/whentouse.html
http://mysql.com/oem/
http://www.mysql.com/oem/faq.html