This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

Generating dynamic sync adapters

Question
0

Sign in to vote

I have to generate dynamic sync adapters primarily to update my SDF schema based on changes in the SQL server. The changes would limit to column additions and table additions. I'm using custom change tracking and don't use stored procedures and triggers. My question is whether to go with provisioning or is there any other way to dynamically read the tables and create sync adapters ? Will there be a performance issue if i have > 50 tables ?

Friday, February 3, 2012 5:43 AM

All replies

0

Sign in to vote

if you using the SqlCeClientSyncAdapter, then yes, i think you can dynamically add tables to the SyncGroup. you mentioned you're not using stored procs and triggers so am assuming you have the sync sql commands hardcoded, you can then dynamically replace the statements.

have a look at the Sync Adapter builder from here and see how much of it can you reuse for your scenario: http://blogs.msdn.com/b/sync/archive/2008/08/13/2-new-sync-samples-download-only-adapter-builder.aspx

Saturday, February 4, 2012 4:03 PM
0

Sign in to vote

URL seems to redirect to code samples and not able to figure out the sample..

Friday, February 10, 2012 4:53 AM
0

Sign in to vote

yes, it does redirect to a code sample.

Friday, February 10, 2012 5:34 AM