provisioning - SyncFramework Dynamic Filtering Template Error Creating Select Changes sp -
i provisioning server, sql 2008 r2, , creating 3 different provisions, speak, 12 tables in scope. first provisioning has no parameters , second , third provisioning parameters. on second , third provisioning using templates , adding filters each table. specifying schema object. filters creating dynamic filters. when execute apply command on provisioning second , third provisions, error _selectchanges stored procedure exists table. have set setcreateproceduresforadditionalscopedefault(dbsynccreationoption.create). still trying create stored procedure name of original stored procedure 1st provisioning.
in playing around see found each of provisions insert, update, bulkinsert,etc... stored procedures created each table created in schema specified selectchanges stored procedures each table not created in schema specified in default schema. found if did not specify schema , did 3 provisionings, describe above, worked , separate selectchanges stored procedures each table wer created. use different schema though since there lot of tables, sps, , such.
it makes me think when creating stored procedures selectchanges sync framework checking existence of selectchanges stored procedure table schema specified in objectschema parameter when creating selectchanges stored procedure not using schema specified.
any ideas on why or if doing wrong?
Comments
Post a Comment