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

Make a new replication with exsist table. Expand / Collapse
Author
Message
Posted Saturday, November 30, 2013 11:36 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 7:40 AM
Points: 81, Visits: 175
Hello SQL Guru's,

Im trying to make a replication with a exist table.

When I make a replication its always drops the table and make een new one... But I dont like it I just need only the column to be updated...

How can i fix it.


In the picture I need the column's Date_logged1 and date_logged2 in my table... But when I start my replication its dropping theys columns in table incident.
Picture 1 Original;


Picture 2 when I use a replication;


  Post Attachments 
picture1.JPG (11 views, 67.73 KB)
picture2.JPG (7 views, 96.69 KB)
Post #1518657
Posted Sunday, December 1, 2013 10:58 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 7:40 AM
Points: 81, Visits: 175
NO answers??!!
Post #1518759
Posted Monday, December 2, 2013 2:48 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 18, 2014 3:04 AM
Points: 1,331, Visits: 15,269
I think the reason you have no replies is you aren't completely clear.

Replication does not drop tables on the publisher.

The default on the subscriptions is to "drop existing" and is a per article setting you can change.

What are you trying to achieve? Are you adding columns to a published table?
Post #1518806
Posted Monday, December 2, 2013 3:07 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, November 21, 2014 3:22 AM
Points: 740, Visits: 960
Are you using which type of replication?
Post #1518814
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse