CDC Guide for Linux, UNIX, and Windows

10.5.4
- 10.5.8
- 10.5.6
- 10.5.5
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Example dbmover Statements for SQL Server

The following statements are typical of those included in a dmover.cfg for SQL Server CDC:

LOGPATH="C:\Informatica\PowerExchangeVnnn\Logs"
CAPT_XTRA="C:\Informatica\PowerExchangeVnnn\Capture\camaps"
CAPT_PATH="C:\Informatica\PowerExchangeVnnn\Capture"
CAPI_CONN_NAME=CAPIMSSC
CAPI_CONNECTION=(NAME=CAPIMSSC
                ,TYPE=(MSQL,DISTSRV=AUX159908\PWXPC
                      ,DISTDB=distribution
                      ,RSTRADV=30))

You must use non-curly double quotation marks around values that include a space.

Customizing the dbmover Configuration File for SQL Server CDC

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal