This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

auto SQL CE database provisioning with SqlCeSyncProvider

Question
0

Sign in to vote

Can I automatically provision my SQL CE database when I am using SqlCeSyncProvider for sync.

I have to sync my sql ce database from a SQL server. Initally the sql ce file is not there so sync operation should create the file/database and all the tables that are synched.

I can do this when using SyncAgent and SqlCEClientProvider (it created DB and table and sync data), but when I use SqlCeSyncProvider, the beginSession (I am writing a custom provider over wcf proxy which will internally call/use sqlCeSyncProvider) calls fails with message "table not found".

Regards
singhhome

Sunday, June 6, 2010 7:18 PM

Answers

0

Sign in to vote
You can take a look this MSDN document at http://msdn.microsoft.com/en-us/library/dd918848(v=SQL.105).aspx for the section "Provisioning the Clients"

Basically you get a DbSyncScopeDescription from server connection and create a SqlCeSyncScopeProvisioning object and call Apply to the SQlCe connection.
- Proposed as answer by jigu2014Microsoft employee, Editor Wednesday, June 9, 2010 4:34 PM
- Marked as answer by singhhome Wednesday, June 9, 2010 6:55 PM
Monday, June 7, 2010 6:33 PM

Answerer

All replies

0

Sign in to vote

you'll have to provision the scope in the SQL Ce database before synchronizing, check out SqlCESyncScopeProvisioning in the API

Monday, June 7, 2010 8:51 AM
0

Sign in to vote
You can take a look this MSDN document at http://msdn.microsoft.com/en-us/library/dd918848(v=SQL.105).aspx for the section "Provisioning the Clients"

Basically you get a DbSyncScopeDescription from server connection and create a SqlCeSyncScopeProvisioning object and call Apply to the SQlCe connection.
- Proposed as answer by jigu2014Microsoft employee, Editor Wednesday, June 9, 2010 4:34 PM
- Marked as answer by singhhome Wednesday, June 9, 2010 6:55 PM
Monday, June 7, 2010 6:33 PM

Answerer