Update SQL CE Table Data

I need to create an application where i can update the data once in a while. I'm trying to figure out the best way so I can create the schema...should i create a database with the tables i need and just copy from the modified database i have? but then i lose relationships that should make my life easier inside the application. Or create scripts with a tool (Red Gate Data Comparer) and run the script in the client 开发者_运维百科to update the data in the tables.

Any suggestions to this problem?

The Sync Framework works OK once you get used to it. It does have some limitations and quirks though.