Load Ingest Data
Results 1 to 3 of 3

Thread: MS SQL Server CDC - Replication

  1. #1
    David is offline Documentation
    Join Date
    Aug 2006
    Posts
    72
    Rep Power
    14

    MS SQL Server CDC - Replication

    When logging an UPDATE operation, the MS SQL Server records only changed data to the TLOG. This is not enough information for the CDC agent to provide before and after images for UPDATE statements. To solve this problem, you must turn Replication on in the MS SQL Server. This replaces the UPDATE changes entered in the log with DELETE/INSERT pairs.
    An MS SQL system administrator must set up the database for replication. The system administrator must do this through the MS SQL Serverís publishing wizard in the MS SQL Serverís Enterprise Manager. Follow the instructions provided by the wizard or see the MS SQL Server documentation. The following should be added to the databaseís definitions:
    ■ A new Distribution database
    ■ A replication entry
    ■ A replication monitor entry
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  2. #2
    jodysmith is offline Junior Member
    Join Date
    Jan 2010
    Posts
    1
    Rep Power
    0
    Hello,
    How can we determine whether the server replication would be fully functional in linux beforehand if the process is being performed in windows?
    server replication UK

    :confused:
    Last edited by DrorHarari; 01-14-2010 at 07:45 AM.

  3. #3
    Join Date
    Sep 2006
    Posts
    233
    Rep Power
    10
    You are not the only one confused. What is your question?
    By Dror Harari

    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •