transactional replication

Question

transactional replication

shreekanth.kavali

Say Hey Kid

Points: 677
More actions
February 16, 2013 at 1:43 am

#289661

After configure of transactional replication ,i want to add one more table ?will it be possible ,how will do that?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

SQLAJ Ten Centuries Points: 1359 More actions · Answer 1

You should be able to add a new table in the publishing database, make sure it is selected in the Publication Properties under the "Articles" page. If you have a test environment setup try it there first.

______________________________
AJ Mendo | @SQLAJ

PRAMANA.DBA SSCertifiable Points: 5507 More actions · Answer 2

EXEC sp_addarticle

@publication = yourpublication_name,

@article = Table_Name,

@source_object = Table_Name

go through below link, it will help to you .

http://ansqldba.blogspot.in/2012/02/adding-new-article-to-existing.html