Server Provisioning Template (Non-SQL Server)

This template enables you to create the stored procedures that enumerate, insert, and update data and metadata in the server database. To create procedures, find and replace the strings below with the appropriate values for your database:

  1. Change [basetable] to the name of the base table, e.g. orders

  2. Change [trackingtable] to the name of the tracking table, e.g. orders_tracking

  3. Change [bt.allcols] to a list of the columns in the base table (bt), e.g. bt.order_id, bt.order_date

  4. Change [bt.pk=tt.pk] to join the PK columns in the base table (bt) with those in the tracking table (tt), e.g. bt.order_id = tt.order_id

  5. Change [bt.nonPkCols] to a list of columns in the base table that are not PK columns, e.g. bt.order_date

  6. Change [@allcols\_with\_datatype\] to a list of columns in the base table, as sql variables along with their datatypes, e.g. @order\_id int, @order\_date datetime

  7. Change [pkcol= @pkcol\] to match PK columns with their corresponding sql variables, e.g. order_id = @order\_id

  8. Change [allcols] to a list of columns in the base table, e.g. order_id, order_date

  9. Change [@allcols\] to a list of columns in the base table as sql variables, e.g. @order\_id, @order\_date

  10. Change [@pkcols\_with\_Datatype\] to a list of PK columns in the base table as sql variables along with their datatypes, e.g. @order\_id int

  11. Change [set_allcols_except_PK] to assign values to all non-PK columns from their corresponding sql variables, e.g. order_date = @order\_date

  12. Change [tt.pk=@pk\] to match PK columns in the tracking table with their corresponding sql variables, e.g. tt.order_id = @order\_id

  13. Change [pkcols] to a list of PK columns in the base table, e.g. order_id

  14. Change [database] to the name of the database that contains the base table e.g. peer1

  15. Change [ScopeTableMap] to the name of the table that stores the scope-to-table mappings, e.g. scope_table_map

Vea también

Conceptos

How to: Provision a Server Database for Collaborative Synchronization (Non-SQL Server)