March 10, 2011 at 11:19 am
Is replication transactional transfers only data or If I add a field in the database it will transfer new fields too or I need to have fields already in another database to transfer data?
Thank you
March 11, 2011 at 9:54 am
You can add fields to a table which is an article and part of a transactional publication, and the field will be applied to the subscriber. I don't think you need to generate a new snapshot in order to get the ddl applied at the subscriber.
Cheers
March 11, 2011 at 10:12 am
TheLazyWriter (3/11/2011)
You can add fields to a table which is an article and part of a transactional publication, and the field will be applied to the subscriber. I don't think you need to generate a new snapshot in order to get the ddl applied at the subscriber.Cheers
That is correct as long as you have the "replicate schema changes" option to true in the publication properties > subscription options.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 14, 2011 at 1:01 am
David Benoit (3/11/2011)
TheLazyWriter (3/11/2011)
You can add fields to a table which is an article and part of a transactional publication, and the field will be applied to the subscriber. I don't think you need to generate a new snapshot in order to get the ddl applied at the subscriber.Cheers
That is correct as long as you have the "replicate schema changes" option to true in the publication properties > subscription options.
Alternitively, if replicate ddl is not enabled, you can use sp_repladdcolumn. Is down as a "to be deprecated" feature but still works. It offers more confirgurable options if you only want the column to go to specific publications.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply