October 11, 2006 at 12:40 pm
I am going to add NEW 15-20 fields to an existing 3-tables & also going to add NEW TABLE(7-Fields). As this one is Transaction Replication , so i would like to know how i can do that & to make sure that new Fields & Table are added correctly on Publisher & Subcriber & replication will work. will like to know what steps i need to follow to acheive this. Any help on this will be appreciated & thanking in advance.
October 11, 2006 at 6:29 pm
You will have to ReInitialize the Replication.
October 12, 2006 at 2:51 am
Totally agree.
Adding new columns to the publisher changes the schema. The safest way to get the schema to the subscribers would be to reinitialize.
Regards..Graeme
October 12, 2006 at 11:49 am
The two posts are correct; but more detailed answers are in the replication forum. I would read both the 2005 and 7/2000 forums on general principle. I have the same issue; except my problem is more frequent as the application changes the schema at any time. I know the answer is out there in those forums, as I have been looking and reading, too.
Good luck! (to both of us)
Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply