If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Problem in replicating altered column in ER

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-22-07, 03:13
Omer Saeed Khan Omer Saeed Khan is offline
Registered User
 
Join Date: Feb 2007
Posts: 7
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
Reply With Quote
  #2 (permalink)  
Old 02-28-07, 17:16
lloydnwo lloydnwo is offline
Registered User
 
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On