none
ObjectPrefix / ObjectSchema not consistent RRS feed

  • Question

  • I create a scope with...

    Dim localConfig As New SqlSyncScopeProvisioning(localCnn, scopeDesc) With
          {.ObjectPrefix = SYNC_PREFIX, .ObjectSchema = SYNC_SCHEMA}

    Problem is the prefix and/or schema is not applied to the _selectchanges stored procedures.

    I use Red-Gate's SQLCompare to sync schemas between my master db and my client's. I need a way to tell SQLCompare to ignore MS Sync stuff. I could do this via .ObjectPrefix or .ObjectSchema but neither is working correctly.

    Alternatively, is there a way to reprovision stored procedures only if they do not exist?

     

    Monday, April 11, 2011 4:01 AM

All replies