Skip to main content
Version: OpCon 23.0 (On-Prem)

Database Replication Checklist

The SQL scripts provided by SMA Technologies for replicating the OpCon database require several scripting variables to execute successfully. The following sections describe these SQL scripting variables as defined within the SMA_SetDBReplicationScriptingVariables.cmd file. Installed with the SAM and supporting services (SAM-SS), the script is in the <Configuration Directory>\Utilities\Database\ directory. For information on variables, refer to Replication Tab under the SMA OpCon Configuration Utility section in the Utilities online help.

note

The Configuration Directory location is based on where you installed your programs. For more information, refer to File Locations in the Concepts online help.

Replication Information Worksheet

Before configuring mirroring in Setup for Automatic Microsoft SQL Replication, print the form below and fill in the values.

Scripting VariableValue
DistributorServerName
DistributorSQLInstance
LoginForDistributorService
REPLDATAFolder
PathToDistributionDataFile
PathToDistributionLogFile
PublisherServerName
PublisherSQLInstance
LoginForPublisherService
PublicationDatabaseName
PublicationName
SubscriberServerName
SubscriberSQLInstance
LoginForSubscriberService
SubscriptionDatabaseName
OpConxpsServerName
DBReplicationScriptsDirectory
SQLScriptOutputDirectory
RunSnapshotAgentAs
RunLogReaderAgentAs
RunDistributionAgentAs
DomainUser
ReplicationProxyKey
DistributorKey
SubscriptionType