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.