June 30, 2003 at 12:38 pm
Hi,
I need some help with replication. I am new to DBA position in my company.We have replication betwwen 4 servers.we are getting the data into server 4 from servers 1,2 and 3.
we have the table Xxxx in all the 4 servers. Now we are going to add two columns to the table. basiacally i dont know which replication they are using already and which server is a publisher and which is subscriber,how should i know all the details.If i wanted to add the two columns what should i do with the existing replication? can i modify it with some procedure or should i recreate the new replication. please help me in this issue.
Thanks..
June 30, 2003 at 1:55 pm
Before you start modifying your replication schema, I would suggest that you really understand how your replication works.
You must know wich server is the distributor (that sometimes can be the same as the publisher). You will find this server with EM, because is the only one that has the replication monitor. If you have multiple servers with this, then that usually means that they are all publisher (and also distributor).
Then to add the column to the published table, you can use the sp sp_repladdcolumn. I would check in BOL for more info.
You should execute this sp in the publisher/s, and the new column would be replicated to all subscribers
September 26, 2003 at 9:20 am
How should i do the same with Enterprise manager.
September 26, 2003 at 10:04 am
In the publication properties, right click over the publication.In the "Filter Columns" Tab, you can select the table you want to add a column and then click over the "Add Column to table" button.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply