April 16, 2008 at 2:53 am
Hi all,
i want to know one thing about replication...
my question is
In transactional replication if we add one new coloumn in a table at publisher.than will the result be reflected at subscriber ?
or the replication will stop working ????
Regards
Vikas
April 16, 2008 at 3:41 am
Yes,it is possible to replicate the column changes.
Right click on Publisher -->click on properties
In property window,choose the Subscription option then make Replicate schema changes -->True
April 16, 2008 at 4:10 am
Thanks alot for ur valuable advice...
Regards
Vikas:)
April 16, 2008 at 7:00 am
If you have replication running for a particular table (making it an article) you need to make schema changes through the replication UI. If you try to make a change through Management Studio you will get an error.
Most schema changes replicate well, but you should read the books online topics about transactional replication and schema changes because there are some tricky parts.
April 16, 2008 at 8:18 am
Most of your schema changes will be forwarded to a subscriber automatically. You do not need to bring down replication or even create a new subscription. Some of the changes will be replicated only after running a new snapshot (in my case we do not run it at all because of customizations), but there are exceptions, like adding indexes will not be replicated automatically.
An article that will answer your question in details:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply