setuprepl.bat

用VS。NET基于wince

REM -- Adding the merge articles

REM -- Add the "Order Details" Table
%sqlrepl_demo_osqlexe% /S%sqlrepl_demo_publisher% /U%sqlrepl_demo_publisher_user% /P%sqlrepl_demo_publisher_pwd% /n /d%sqlrepl_demo_publisher_db% /Q"exec sp_addmergearticle @publication = N'SQLCEReplDemoNet', @article = N'Order Details', @source_owner = N'dbo', @source_object = N'Order Details', @type = N'table', @description = null, @column_tracking = N'true', @pre_creation_cmd = N'drop', @creation_script = null, @schema_option = 0x000000000000CFF1, @article_resolver = null, @subset_filterclause = null, @vertical_partition = N'false', @destination_owner = N'dbo', @auto_identity_range = N'false', @verify_resolver_signature = 0, @allow_interactive_resolver = N'false', @fast_multicol_updateproc = N'true', @check_permissions = 0"


REM -- Add the "Orders" Table
%sqlrepl_demo_osqlexe% /S%sqlrepl_demo_publisher% /U%sqlrepl_demo_publisher_user% /P%sqlrepl_demo_publisher_pwd% /n /d%sqlrepl_demo_publisher_db% /Q"exec sp_addmergearticle @publication = N'SQLCEReplDemoNet', @article = N'Orders', @source_owner = N'dbo', @source_object = N'Orders', @type = N'table', @description = null, @column_tracking = N'true', @pre_creation_cmd = N'drop', @creation_script = null, @schema_option = 0x000000000000CFF1, @article_resolver = null, @subset_filterclause = null, @vertical_partition = N'false', @destination_owner = N'dbo', @auto_identity_range = N'true', @pub_identity_range = 100, @identity_range = 100, @threshold = 80, @verify_resolver_signature = 0, @allow_interactive_resolver = N'false', @fast_multicol_updateproc = N'true', @check_permissions = 0"


REM -- Add the "Products" Table
%sqlrepl_demo_osqlexe% /S%sqlrepl_demo_publisher% /U%sqlrepl_demo_publisher_user% /P%sqlrepl_demo_publisher_pwd% /n /d%sqlrepl_demo_publisher_db% /Q"exec sp_addmergearticle @publication = N'SQLCEReplDemoNet', @article = N'Products', @source_owner = N'dbo', @source_object = N'Products', @type = N'table', @description = null, @column_tracking = N'true', @pre_creation_cmd = N'drop', @creation_script = null, @schema_option = 0x000000000000CFF1, @article_resolver = null, @subset_filterclause = null, @vertical_partition = N'false', @destination_owner = N'dbo', @auto_identity_range = N'true', @pub_identity_range = 100, @identity_range = 100, @threshold = 80, @verify_resolver_signature = 0, @allow_interactive_resolver = N'false', @fast_multicol_updateproc = N'true', @check_permissions = 0"

REM -- Adding the article's partition column(s) for "Products" Table
%sqlrepl_demo_osqlexe% /S%sqlrepl_demo_publisher% /U%sqlrepl_demo_publisher_user% /P%sqlrepl_demo_publisher_pwd% /n /d%sqlrepl_demo_publisher_db% /Q"exec sp_mergearticlecolumn @publication = N'SQLCEReplDemoNet', @article = N'Products', @column = N'SupplierID', @operation = N'drop'"
%sqlrepl_demo_osqlexe% /S%sqlrepl_demo_publisher% /U%sqlrepl_demo_publisher_user% /P%sqlrepl_demo_publisher_pwd% /n /d%sqlrepl_demo_publisher_db% /Q"exec sp_mergearticlecolumn @publication = N'SQLCEReplDemoNet', @article = N'Products', @column = N'CategoryID', @operation = N'drop'"
%sqlrepl_demo_osqlexe% /S%sqlrepl_demo_publisher% /U%sqlrepl_demo_publisher_user% /P%sqlrepl_demo_publisher_pwd% /n /d%sqlrepl_demo_publisher_db% /Q"exec sp_mergearticlecolumn @publication = N'SQLCEReplDemoNet', @article = N'Products', @column = N'QuantityPerUnit', @operation = N'drop'"
%sqlrepl_demo_osqlexe% /S%sqlrepl_demo_publisher% /U%sqlrepl_demo_publisher_user% /P%sqlrepl_demo_publisher_pwd% /n /d%sqlrepl_demo_publisher_db% /Q"exec sp_mergearticlecolumn @publication = N'SQLCEReplDemoNet', @article = N'Products', @column = N'UnitsOnOrder', @operation = N'drop'"
%sqlrepl_demo_osqlexe% /S%sqlrepl_demo_publisher% /U%sqlrepl_demo_publisher_user% /P%sqlrepl_demo_publisher_pwd% /n /d%sqlrepl_demo_publisher_db% /Q"exec sp_mergearticlecolumn @publication = N'SQLCEReplDemoNet', @article = N'Products', @column = N'ReorderLevel', @operation = N'drop'"


REM -- Add the "Employees" Table
%sqlrepl_demo_osqlexe% /S%sqlrepl_demo_publisher% /U%sqlrepl_demo_publisher_user% /P%sqlrepl_demo_publisher_pwd% /n /d%sqlrepl_demo_publisher_db% /Q"exec sp_addmergearticle @publication = N'SQLCEReplDemoNet', @article = N'Employees', @source_owner = N'dbo', @source_object = N'Employees', @type = N'table', @description = null, @column_tracking = N'true', @pre_creation_cmd = N'drop', @creation_script = null, @schema_option = 0x000000000000CFF1, @article_resolver = null, @subset_filterclause = null, @vertical_partition = N'false', @destination_owner = N'dbo', @auto_identity_range = N'true', @pub_identity_range = 100, @identity_range = 100, @threshold = 80, @verify_resolver_signature = 0, @allow_interactive_resolver = N'false', @fast_multicol_updateproc = N'true', @check_permissions = 0"

%sqlrepl_demo_osqlexe% /S%sqlrepl_demo_publisher% /U%sqlrepl_demo_publisher_user% /P%sqlrepl_demo_publisher_pwd% /n /d%sqlrepl_demo_publisher_db% /Q"exec sp_mergearticlecolumn @publication = N'SQLCEReplDemoNet', @article = N'Employees', @column = N'Photo', @operation = N'drop'"
%sqlrepl_demo_osqlexe% /S%sqlrepl_demo_publisher% /U%sqlrepl_demo_publisher_user% /P%sqlrepl_demo_publisher_pwd% /n /d%sqlrepl_demo_publisher_db% /Q"exec sp_mergearticlecolumn @publication = N'SQLCEReplDemoNet', @article = N'Employees', @column = N'Notes', @operation = N'drop'"
%sqlrepl_demo_osqlexe% /S%sqlrepl_demo_publisher% /U%sqlrepl_demo_publisher_user% /P%sqlrepl_demo_publisher_pwd% /n /d%sqlrepl_demo_publisher_db% /Q"exec sp_mergearticlecolumn @publication = N'SQLCEReplDemoNet', @article = N'Employees', @column = N'PhotoPath', @operation = N'drop'"


REM -- Add the "Customers" Table
%sqlrepl_demo_osqlexe% /S%sqlrepl_demo_publisher% /U%sqlrepl_demo_publisher_user% /P%sqlrepl_demo_publisher_pwd% /n /d%sqlrepl_demo_publisher_db% /Q"exec sp_addmergearticle @publication = N'SQLCEReplDemoNet', @article = N'Customers', @source_owner = N'dbo', @source_object = N'Customers', @type = N'table', @description = null, @column_tracking = N'true', @pre_creation_cmd = N'drop', @creation_script = null, @schema_option = 0x000000000000CFF1, @article_resolver = null, @subset_filterclause = null, @vertical_partition = N'false', @destination_owner = N'dbo', @auto_identity_range = N'false', @verify_resolver_signature = 0, @allow_interactive_resolver = N'false', @fast_multicol_updateproc = N'true', @check_permissions = 0"


REM -- Add the "Shippers" Table
%sqlrepl_demo_osqlexe% /S%sqlrepl_demo_publisher% /U%sqlrepl_demo_publisher_user% /P%sqlrepl_demo_publisher_pwd% /n /d%sqlrepl_demo_publisher_db% /Q"exec sp_addmergearticle @publication = N'SQLCEReplDemoNet', @article = N'Shippers', @source_owner = N'dbo', @source_object = N'Shippers', @type = N'table', @description = null, @column_tracking = N'true', @pre_creation_cmd = N'drop', @creation_script = null, @schema_option = 0x000000000000CFF1, @article_resolver = null, @subset_filterclause = null, @vertical_partition = N'false', @destination_owner = N'dbo', @auto_identity_range = N'true', @pub_identity_range = 100, @identity_range = 100, @threshold = 80, @verify_resolver_signature = 0, @allow_interactive_resolver = N'false', @fast_multicol_updateproc = N'true', @check_permissions = 0"

REM -- Adding the article's partition column(s) for "Shippers" Table
%sqlrepl_demo_osqlexe% /S%sqlrepl_demo_publisher% /U%sqlrepl_demo_publisher_user% /P%sqlrepl_demo_publisher_pwd% /n /d%sqlrepl_demo_publisher_db% /Q"exec sp_mergearticlecolumn @publication = N'SQLCEReplDemoNet', @article = N'Shippers', @column = N'Phone', @operation = N'drop'"


REM -- *********************Starting Snapshot Agent***********************************************************************

@echo Generating initial snapshots...
@echo Wait for each job to finish before using application.
%sqlrepl_demo_snapshotexe% -Publication [SQLCEReplDemoNet] -Publisher %sqlrepl_demo_publisher% -PublisherDB [%sqlrepl_demo_publisher_db%] -Distributor [%sqlrepl_demo_distributor%] -ReplicationType 2 -DistributorSecurityMode 0 -DistributorLogin %sqlrepl_demo_distributor_user% -DistributorPassword %sqlrepl_demo_distributor_psswd% -PublisherSecurityMode 0 -PublisherLogin %sqlrepl_demo_publisher_user% -PublisherPassword %sqlrepl_demo_publisher_pwd%



REM -- *************************************Usage*************************************************************************

:usage
@echo Usage: SetupRepl {required parms} {optional parms}
@echo .
@echo . Required Arguments:
@echo . {snapshot share}          - a share available for the storage of snapshot 
@echo .                             files. All subscribers (IIS user) must be able 
@echo .                             to read from this share
@echo . {publisher login}         - Publisher user ID.
@echo . {publisher password}      - Publisher password.
@echo .
@echo . Optional Arguments:
@echo . {publisher}               - Publisher name. Defaults to local machine.
@echo . {snapshot server name}    - Defaults to Publisher name. (Must be set to
@echo .                             support named instance)
@echo .
@echo . Examples:
@echo .          SetupRepl ReplSnapshot sa password
@echo .      or
@echo .          SetupRepl ReplSnapshot sa password Publisher 
@echo .      or
@echo .          SetupRepl ReplSnapshot sa password Publisher\instance ServerName
@echo .
@echo . Will create a publication SQLCEReplDemoNet on your local machine, configure
@echo . it and prepare the snapshot files so you can begin using the %sqlrepl_demo_publisher_db% 
@echo . SQLCE application.

REM -- *************************************Reset*************************************************************************

set sqlrepl_demo_publisher=
set sqlrepl_demo_publisher_user=
set sqlrepl_demo_publisher_pwd=
set sqlrepl_demo_distributor=
set sqlrepl_demo_distributor_user=
set sqlrepl_demo_distributor_psswd=
set snapshot_job_name= 
set sqlrepl_demo_workfolder= 
set sqlrepl_demo_machine_name=

:end