tags:

views:

11

answers:

1
Q: 

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?

A: 

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

leppie  2010-08-19 09:48:24
I will check the features deeper. You think this could work with numerous clients and 1 server?
 2010-08-19 09:58:24
@gtas: That is what we are doing currently. Newer versions of the Sync Framework supports peer-2-peer syncing features, although I have not used that.
leppie  2010-08-19 09:59:44
Interesting....
 2010-08-19 10:51:22

related questions

How do you determine how far to normalize a database?
Tips for database design in a web application
How do you deal with polymorphism in a database?
Database Patterns
Is it okay to have a lot of database views?
Extra tables or non-specific foreign keys?
Implementing a '20 Questions'-like Wizard in a Database
Database Design for Revisions?
Which database table Schema is more efficient?
How do you build a ratings implementation?
How should I model a field that can contain both numeric and string values in SQL Server 2005?
What if analysis on multi dimensional cubes (OLAP)
Data model for a extensible web form
Database Schema Diagram Design Tool
Good strategy for leaving an audit trail/change history for DB applications?
How do you recommend implementing tags or tagging
One database or many?
Suitable E-R notation for introductory DB design course? Good/free diagram tools?
What is the best strategy for retainment of large data sets?
Query a union table with fields as columns.
When is a file just a file?
Database triggers
What are the advantages of using a single database for EACH client?
Database, Table and Column Naming Conventions?
Auto Generate Database Diagram MySQL