We help IT Professionals succeed at work.

script replication subscription initialize properties

bibi92
bibi92 asked
on
Hello,

How can I script replication subscription not initialize with a snapshot?

Thanks

Regards

bibi
Comment
Watch Question

Ramakanta SahooSenior Technical Engineer

Commented:
Can you explain a little bit more what you want to do?
Do you already have a replication ad you eant to generate the script?
Or do you want to create/add a new subscription to an existing publication?
The second question I meant::

"Do you already have a publication and you want to generate the script?"

Author

Commented:
I want to create  a new subscription to an existing publication with target db initialization  and I want to add a second subscription to existing publication without target db initialization because the datas are consolidated.

Thanks

bibi
WHen you add a new subscription to a publication the last snapshot will be applied. You have to run the snapshot agent after adding the subscriptions. After that the synch agent will do its job.

Author

Commented:
Sorry, with SSMS, It's possible to add a new subscription to a publication without the last snapshot will be applied if the target db is initialized. I search how to script not activate the case initialize.

Thanks

bibi

Author

Commented:
thanks bibi