Can sync be done using denormalized tables locally using ColdFusion ActionScript ORM Library
We are working on a flex air sync application using the ColdFusion ActionScript ORM Library. Since we have just started with this, I had a basic question. The remote database is a huge one with lot of tables and relation ships and we are implementing a small portion of the functionality for the sync application. Hence we are planning to use some de-normalized tables for the local database (sqlite). I just wanted to know whether sync would work when we have de-normalized tables locally i.e the local DB and the remote DB are not exactly similar. We are using ColdFusion 9.0.1 ActionScript ORM Library. Also, if this can be done then where have to handle the differences ? ( I supp开发者_JAVA百科ose on the server cold fusion side)
Thanks,
精彩评论