Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

transactional replication Expand / Collapse
Author
Message
Posted Saturday, February 16, 2013 1:43 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 27, 2014 12:24 AM
Points: 12, Visits: 24
After configure of transactional replication ,i want to add one more table ?will it be possible ,how will do that?
Post #1420871
Posted Tuesday, May 21, 2013 5:00 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 12:35 PM
Points: 85, Visits: 396
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
Post #1454920
Posted Monday, August 19, 2013 6:46 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 3:05 AM
Points: 606, Visits: 813
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

Post #1485774
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse