What is the syntax for a no sync initialization when using scripts to create publication & subscription & subscription agent?
JLS
@.sync_type =none in sp_addsubscription.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanx so much Paul!!!
Also true in sp_addpullsubscription ?
JLS
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message news:umBvYgn%23FHA.1256@.TK2MSFTNGP15.phx.gbl...
@.sync_type =none in sp_addsubscription.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||No corresponding argument in sp_addpullsubscription. You could try using
sp_addsubscription with @.subscription_type = 'pull'. I've never set it up this way (always used push) but it seems the way to go.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Excellent! Thank you very much!!!
Jude
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message news:uIN8Zmo%23FHA.1600@.TK2MSFTNGP11.phx.gbl...
No corresponding argument in sp_addpullsubscription. You could try using
sp_addsubscription with @.subscription_type = 'pull'. I've never set it up this way (always used push) but it seems the way to go.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Wednesday, March 7, 2012
Script (No Sync) syntax
Labels:
create,
database,
initialization,
microsoft,
mysql,
oracle,
publication,
script,
scripts,
server,
sql,
subscription,
sync,
syntax
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment