Step 1: Set up a publisher
Procedure
- Set up a database connection dedicated to CDC.
- Set up a connection to the database where data is located.
Results
Information noteNote: If you work with an MS SQL Server,
you must set the two connections to the same database but using two different
schemas.
![Example of two connections to the same database on an MS SQL Server.](/en-US/studio-user-guide/8.0-R2024-07/Content/Resources/images/cdc_trigger_publisher.png)
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!