SQL Server 2008 - SQL Compact Ed. Synchonization with filtered informations RRS feed

  • General discussion

  • Hi!
    I'm developing a client-server application with multiple clients accessing informations on a server. When internet connection is available clients work with the central database. If there's no connection clients can work on local databases. When connection is available i want to re-synchronize data between client and server, so they send each other a copy of their database as a Compact Ediction database and synchronize through these copies. Considering that central database has a great amount of data, I would send to clients only a small amount of this data that can be of any interest for this client. Is there a safe way to filter information to synchronize? I'm not only speaking of tables (and then of scopes) but I want to filter data in tables too. All kind of suggestions are welcome^^
    Friday, January 22, 2010 10:44 AM