Cena Data Transfer Agent
find more details in Cena-DTA's home page.
- server: PHP5.3 and MySQL
- client: WebSqlDB capable browser and jQuery.
Primary key value maybe changed during database synchronization process if keys are generated as auto-numbered as in many conventional RDB. If the changed key is used to create a relation between records, the relation will be broken.
Cena-DTA can keep track all the primary key changes, and automatically changes the corresponding values in other records to keep relationships correct.