Re: Adding column to article on *susbcriber* side

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

I ran a little test, and it failed on delivering the snapshot because
of that extra column on the subscriber side. So the moral of the story
is to add the column in a post snapshot script which is not always the
best idea (if you already have your schema deployed and something is
dependant on this column), OR you can change the SYNC view on the
publisher and add a blank column to it prior to running the snapshot
agent.

R. Green


On Feb 25, 3:01 pm, "Hilary Cotter" <hilary.cot...@xxxxxxxxx> wrote:
It should work. This is the normal way of carrying out what you are trying
to accomplish.

--
Hilary Cotter

Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com

"Ronald Green" <zzz...@xxxxxxxxx> wrote in message

news:1172407317.380240.255030@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



Hi,

I've got a unidirectional transactional replication (on sql 2000) and
I want to add a column to a table on the subscriber's side, the column
allows nulls and is going to be updated on the subscriber.

I thought of creating the table, than adding the publication and when
I add this specific article, tell it to truncate the table if it
exists rather than to drop it.

Is there any flaw in this?

Thanks in advance,
R. Green- Hide quoted text -

- Show quoted text -


.

Relevant Pages

  • Re: trans replication of large tables...
    ... Just because it is set to local admins doesn't mean that it can ... something as simple as a timeout during the application of the snapshot. ... subscriber, the subscription is created specifying that the subscriber ... > in the same publication - or if they are queried in the same procs they ...
    (microsoft.public.sqlserver.replication)
  • Re: Snapshot Delivery - Violation of PRIMARY KEY constraint
    ... which I have mentioned previously is that your filter is time-dependent. ... the set of rows that qualify your filter when the snapshot was ... you will get uniqueness violation ... destination table is created from scratch at the subscriber (meaning you ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication over FTP
    ... My publisher, when setting up the replication, ... The subscriber, a pull merge subscription, has all the ... > place over port 1433 except for the application of the snapshot which is ... >> Can I, when setting up the database, export all objects to the server. ...
    (microsoft.public.sqlserver.replication)
  • Re: Snapshot Delivery - Violation of PRIMARY KEY constraint
    ... The simplest explanation is that the filter you use for deleting data at the ... data delivered with the snapshot. ... publisher and at the subscriber. ... Delivering a snapshot is fundamentally a very disruptive process at the ...
    (microsoft.public.sqlserver.replication)
  • RE: Merge pull subscription -- Applying snapshot from alternate UN
    ... In one line my objective is to apply the initial snapshot from the CD or UNC ... Even if the subscriber needs to connect to web server to get some ... Using RMO to create the subscription and start the merge agent ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.replication)