Hi Experts,
I have to implement Transsactional Push type replication on my OLTP database to seperate out reporting database as a subscriber.Also we need to apply frequent ddls as part of build and patch on the source (publisher) database, and replication dosent allow it.
I need step by step procedure to setup and ofcourse the solution for the following issues -
1. Database changes DDLs apply on the publisher and subscriber.
2. Notification when problem comes and action to restart the replication.
3. Any hidden issues which i am not considering.
Pl. let me know any link/url for the same.
TIA,
Sheilesh