1

Can SQL Server replicate TO SQL Server Compact Edition?

To put this in some relevant context, I'm considering the implications of using SQL Server CE as a near line edge cache instead of querying & caching results from our database.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Chris Marisic
  • 32,487
  • 24
  • 164
  • 258

1 Answers1

3

According to this page Implementation Replication (SQL Server Compact) it would seem possible, to create a replication publication, and a subscriber in SQL Server CE.

Or maybe the Microsoft Sync Framework is more what you're looking for? See Database Sync - SQL Server and SQL Compact for some code samples.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
  • 1
    Definitely the kind of information I was looking for, kudos for posting those links in regards to the Sync framework as this is the type of information I was hoping to gleam by adding the context I did to my question – Chris Marisic Mar 04 '11 at 19:32