How to alter provisioning scripts for SqlSyncProvider? RRS feed

  • Question

  • Is there a convenient way to alter the database provisioning scripts before provisioning occurs, possibly without manually altering the script as a string but in a structured way?

    I’m using SqlSyncProvider for a SQL database. What I would like to do is to add one table to Sync metadata for every scope that is created. This table would map a GUID to the corresponding table name and PK value. The table triggers would also need to be altered to automatically insert new rows to this additional tracking table.

    Can anyone tell me what is the simplest way to achieve this?

    Wednesday, September 21, 2011 10:49 AM

All replies

  • most of the provisioning APIs is internal to the framework. Moreover, what you are trying to inject really has nothing to do with the framework itself. so it's either you alter the script generated by framework or you do the extra work outside of sync framework.
    Thursday, September 22, 2011 2:07 AM