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: Wednesday, May 21, 2014 3:21 AM
Points: 13, Visits: 47
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: Wednesday, July 30, 2014 5:45 AM
Points: 85, Visits: 399
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
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 3:16 AM
Points: 666, Visits: 900
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