Replication script constants control Transact-SQL command batch contents for the Script method of a SQL-DMO object representing a replication component.
| Constant | Value | Description |
|---|---|---|
| SQLDMORepScript_AnsiFile | 16777216 | Output to a file is written as ANSI character text. |
| SQLDMORepScript_AppendToFile | 8192 | Output is appended to a designated operating system file. If not set, output overwrites any data in an existing, designated file. |
| SQLDMORepScript_Creation | 16384 | Script includes database object creation. |
| SQLDMORepScript_Default | 256 | SQLDMORepScript_ InstallDistributor. |
| SQLDMORepScript_Deletion | 32768 | Script includes deletion of existing database objects. |
| SQLDMORepScript_ DisableReplicationDB |
134217728 | Script disables a replication database. |
| SQLDMORepScript_ EnableReplicationDB |
67108864 | Script enables a replication database. |
| SQLDMORepScript_ InstallDistributor |
256 | Default. The script installs the replication Distributor. |
| SQLDMORepScript_InstallPublisher | 1024 | Script installs a Publisher. |
| SQLDMORepScript_ InstallReplication |
1048576 | Script installs replication. |
| SQLDMORepScript_ NoCommandTerm |
268435456 | No command terminator is added to script commands. |
| SQLDMORepScript_NoSubscription | 128 | Script a publication without scripting its subscriptions. |
| SQLDMORepScript_ PublicationCreation |
65536 | Script includes publication creation text. |
| SQLDMORepScript_ PublicationDeletion |
131072 | Script includes text that removes publications. |
| SQLDMORepScript_ SubscriptionCreation |
262144 | Script includes subscription creation text. |
| SQLDMORepScript_ SubscriptionDeletion |
524288 | Script includes text that removes subscriptions. |
| SQLDMORepScript_ToFileOnly | 4096 | Output generated by an executed script is directed to an operating system file only. If not set, output is available as status or error messages. |
| SQLDMORepScript_UnicodeFile | 33554432 | Output to a file is written as Unicode character text. |
| SQLDMORepScript_ UninstallDistributor |
512 | Script removes the replication Distributor. |
| SQLDMORepScript_ UninstallPublisher |
2048 | Script removes a Publisher. |
| SQLDMORepScript_ UninstallReplication |
2097152 | Script removes replication. |
Script Method (Replication Objects)