Creating overlapping scopes in an SqlCe database RRS feed

  • Question

  • I have need to create a couple of overlapping scopes in a client using an sqlce database. When I attempt this I get an error about the tracking tables already existing. Thats somewhat expected, but I was surprised to find that the scope provisioning classes don't share a common base class (other than object) or a common interface. Specifically SqlCeSyncScopeProvisioning class doesn't provide a SetCreateTrackingTableDefault method. 

    Are overlapping scopes not currently supported for sqlce databases? Are there any work arounds?

    Tuesday, May 4, 2010 3:15 PM


  • There is no support for overlapping scopes for SqlCeSyncProvider because SqlCe is regarded as a client only database, hence the need for overlapping scopes are not common. Also sqlce is a lightweight database, sharing a same sqlce db is not most important scenario by Sqlce's design and targeting scenarios.

    You could provision a different SqlServer scope with another SqlCe database for the specific data needed for that scope.

    Tuesday, May 4, 2010 5:04 PM