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

Replication Expand / Collapse
Author
Message
Posted Thursday, February 3, 2011 6:24 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 6, 2011 1:53 AM
Points: 18, Visits: 121
Good Day we are running SQL Server 2008R Enterprise Edition . We need to replicate some tables to an Archive Server . In the Archive database a table is also stored that is updated by another process. According to the specs
t his table is not selected in the initial Snapshot and my not be deleted by the snapshot . Is there a way to configure Replication to do this ?
Post #1058033
Posted Thursday, February 3, 2011 8:32 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:43 AM
Points: 3,309, Visits: 6,700
You can always set up the table as a separate publication with no snapshot. But you will have to do the first data load on your own. BCP or backup can be used for that. This link should point you to the right direction.
http://msdn.microsoft.com/en-us/library/ms151705.aspx


-Roy
Post #1058129
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse