Replication Merge SQL 2000

[rlals]

Does Replication change the struture tables on subscriber server when I do it on Publisher ? (and vice-versa over a Merge replication?)

Have I to stop the replication to change table struture ?

thanks.

 

[mrdenny]

The changes that replication makes to the tables will be pushed out to the subscriber when you apply the snapshot to the subscriber.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[rlals]

Opps! I think that I didn´t express myself right.
My question is:
If my application changes some table struture, this will be replicated to subscriber ?

 

[mrdenny]

Your application won't be able to change the tables. While a table is part of a publication the table schema can not be changed via the normal ALTER TABLE command. There are special system stored procedures which must be used to send the command to both servers at the same time.

Look up sp_repladdcolumn in BOL.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com