Usage
Creates or modifies a request for change-based replication.
CREATE REPLICATION REQUEST name AT [DISTRIBUTION] distname
Or ALTER REPLICATION REQUEST name AT [DISTRIBUTION] distname TO
[PATHGROUP name]
[SCHEDULE START {NOW | ON month/day/year [AT hours:minutes:seconds]}
[DURATION n {HOUR[S]|MINUTE[S]|SECOND[S]|DAY[S]|MONTH[S]}]
[STOP ON month/day/year [AT hours:minutes:seconds] ]
[EVERY n {HOUR[S]|MINUTE[S]|SECOND[S]|DAY[S]|MONTH[S]}]
]
[CONNECT TO [SERVER] server-name USING username] ...
[ON_ERROR {CONTINUE | IGNORE | SHUTDOWN }]
[PROTECTED_RESOLUTION {AUTOMATIC | MANUAL}]
[UNPROTECTED_RESOLUTION FOR { {INSERT | UPDATE
| DELETE} {NONE | TARGET_CORRECT | SOURCE_CORRECT}, ... }]
s1
JOB_SEQUENCER s2 [NOT] ACTIVE] …
[FILES_ON_START {DELETE | RETAIN}]
[DESCRIPTION ‘descriptive text’]
;Parameters
|
Parameter |
Description |
|---|---|
|
CREATE |
Establish a new replication request in a previously defined distribution. |
|
ALTER |
Modify a previously established replication request. Specify the distribution for this request. |
|
PATHGROUP |
Specify the path group (if any) to use for this request. |
|
SCHEDULE... |
Set replication request times:
|
|
CONNECT |
Specify a username for a server connection. |
|
ON_ERROR |
Specify error handling: continue, ignore, or shutdown. |
|
PROTECTED_RESOLUTION |
Specify automatic or manual full collision resolution by shadow table. |
|
UNPROTECTED_RESOLUTION |
Specify unprotected collision resolution:
|
|
FILES_ON_START |
The FILES_ON_START clause indicates whether existing files at a FileSystem target server should be deleted or retained when the request starts. |
|
Description |
User-defined text. |
-- RSL REQUEST flatfile definition
CREATE REPLICATION REQUEST flatfile AT DISTRIBUTION FLATFILE
ON_ERROR SHUTDOWN
INTEGRITY STANDARD
PROTECTED_RESOLUTION AUTOMATIC
UNPROTECTED_RESOLUTION FOR INSERT NONE, UPDATE NONE, DELETE NONE
FILES_ON_START RETAIN
"qatest.dbo.JOR_DATATYPES_1"
CATEGORY JC_M SSS_mikey JOB_SEQUENCER JS_MSSS_mikey ACTIVE"qatest.dbo.JOR_DATATYPES_2"
CATEGORY JC_MSSS_matty JOB_SEQUENCER JS_MSSS_matty ACTIVE
MODIFY LEVEL NONE
;