Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2007
    Posts
    7

    Unanswered: Problem in replicating altered column in ER

    Hi
    I am implementing Enterprise Replication on IDS version 10.00.UC4. between 2 databases, using primary target setup.

    All tables are to be replicated, so I am using templates.
    I was successful in setting up the replication, but problem is the alter command.

    As far as I have explored, in ER, if you alter a table on primary server, it is not automatically altered on target server. The solution I found was re-mastering, but I am unable to do that. I tried auto re-mastering and manual re-mastering, but both are not working.

    Please help me out in resolving this issue.


    Regards,
    Omer Saeed Khan

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    262
    Omer,
    Yes your right Alter statements will not work in ER. In order to alter a table
    you will have to first stop replication for that table, then delete the replication for that table, Run alter statements on both servers, Define replication for that table, start replication and make the replication a part of the group.

    Lloyd

Posting Permissions

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