adding fields

Win 2K & SQL 2K
I have several SQL servers replicating to one server and
I need to add a field to a replicated table can I....
Add the field to the subscriber, then via the Properties-
>Filter Columns->Add Column to Table add the same field
to the publisher?
Will this cause a problem with the other publishers when
they attempt to replicate and there is an addition al
field in the destination table, but has not been added on
all the publishers?
Logically, this seems like it will work. I really do not
want to drop all the publications, alter the tables, then
recreate all the publications with no sync.
HELP!!!
the preferred way to add a column to articles in an existing publication is
to use sp_repladdcolumn.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"larry" <anonymous@.discussions.microsoft.com> wrote in message
news:757d01c4765b$2188ee20$a401280a@.phx.gbl...
> Win 2K & SQL 2K
> I have several SQL servers replicating to one server and
> I need to add a field to a replicated table can I....
> Add the field to the subscriber, then via the Properties-
> to the publisher?
> Will this cause a problem with the other publishers when
> they attempt to replicate and there is an addition al
> field in the destination table, but has not been added on
> all the publishers?
> Logically, this seems like it will work. I really do not
> want to drop all the publications, alter the tables, then
> recreate all the publications with no sync.
> HELP!!!

Adding an Article to a Publication

Hi:
I have a publication with larger sql table articles. I want to add another
article (small table). To start replicating, I will need to reinitialize and
rerun the snaphot. I don't want to run the snapshot during the day time
because it may block other users because publication has some large tables in
it.
Is there anyway that I can replicate just that table to subsriber during the
day time?
Thanks a lot
Hi Mike,
You shouldn't need to reinitialize your existing subscription in order to
get snapshot data for the new article propagated to the subscriber. And if
you have a transactional publication with the immediate_sync property set to
false, the snapshot agent will only generate bcp data for the new article.
-Raymond
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:43347180-986E-474C-8C45-EB83BEB62DE5@.microsoft.com...
> Hi:
> I have a publication with larger sql table articles. I want to add
> another
> article (small table). To start replicating, I will need to reinitialize
> and
> rerun the snaphot. I don't want to run the snapshot during the day time
> because it may block other users because publication has some large tables
> in
> it.
> Is there anyway that I can replicate just that table to subsriber during
> the
> day time?
> Thanks a lot
>
|||Thanks Raymond. Where will I see immediate_sync property.
"Raymond Mak [MSFT]" wrote:

> Hi Mike,
> You shouldn't need to reinitialize your existing subscription in order to
> get snapshot data for the new article propagated to the subscriber. And if
> you have a transactional publication with the immediate_sync property set to
> false, the snapshot agent will only generate bcp data for the new article.
> -Raymond
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:43347180-986E-474C-8C45-EB83BEB62DE5@.microsoft.com...
>
>
|||Hi Mike,
You can select the value of the immediate_sync property directly from
syspublications at the publisher database.
-Raymond
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:E58CEE1E-B55D-4DB3-8E4F-1AB5387C36F2@.microsoft.com...[vbcol=seagreen]
> Thanks Raymond. Where will I see immediate_sync property.
> "Raymond Mak [MSFT]" wrote: