Re: adds articles to a publication

Tech-Archive recommends: Speed Up your PC by fixing your registry

I can't re-initialize the entire publication, because the snapshot is
longer.

I can't put it in separate publication, because the performance would
be lower and I should must subscribes anonymous.

After I execute the previous script to add articles, I put in
Publication other script to execute in subscriber after run the
snapshot.

This second script is generated with:

EXEC sp_script_synctran_commands @publication = N'Publisher', @article
= N'Table'
GO

But I thought that some automatic method would exist. Some parameter in
previous script like @schema_option or @for_schema_change.

For example:

@schema_option = 0x000000000800CFF3

The 8 number indicate that "Create any schemas not already present on
the subscriber", but don't work.

Sorry for my english again

Do you have another idea for this problem ?

thank you very much !!


Santiago Titon

.

Relevant Pages

  • Re: Incremental Article Additions to an Existing Merge Publication
    ... Further to this I used the settings below and also a compressed snapshot and then added a test view to the existing publication. ... Ensure that the -InternetLogin user when using basic authentication and the user running the merge when using Windows integrated authentication has been granted access to the snapshot share. ... "Venketash Ramadass" wrote in message ... You might want to put your subscriber database into bulk logged ...
    (microsoft.public.sqlserver.replication)
  • 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: trans replication of large tables...
    ... decrease the time required to deploy the snapshot and if your line is ... > subscriber, the subscription is created specifying that the subscriber ... >> be in the same publication - or if they are queried in the same procs ... >> Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Incremental Article Additions to an Existing Merge Publication
    ... How large is your snapshot? ... then added a test view to the existing publication. ... authentication has been granted access to the snapshot share. ... and kick all users off the subscriber. ...
    (microsoft.public.sqlserver.replication)
  • Re: trans replication of large tables...
    ... in the same publication - or if they are queried in the same procs they ... Pull has more options to transfer the snapshot files to the subscriber ... >> the distribution agent to send it to the subscribers. ...
    (microsoft.public.sqlserver.replication)