> I have Publisher and Subscriber on 2 different locations.
> Data added on subscriber is getting deleted and overwritten by the
> publishers data at the time of synchronisation.
> I want 2 way update. Data can be added on PUBLISHER as well as SUBSCRIBER.
>
> Is it possible in Trans Replication ?
> OR is there any other alternative.
>
> Thanks in Advance
> Sanjay

"Daniel Crichton" <msnews@worldofspack.com> wrote in message
news:%23Bk9wl$LHHA.2232@TK2MSFTNGP02.phx.gbl...
> SANJAY wrote on Thu, 4 Jan 2007 17:27:39 +0530:
>
>> I have Publisher and Subscriber on 2 different locations.
>> Data added on subscriber is getting deleted and overwritten by the
>> publishers data at the time of synchronisation.
>> I want 2 way update. Data can be added on PUBLISHER as well as
>> SUBSCRIBER.
>>
>> Is it possible in Trans Replication ?
>> OR is there any other alternative.
>>
>> Thanks in Advance
>> Sanjay
>
> Depends on what version of SQL Server you have. From what I understand,
> with 2000 you need Merge Replication, on 2005 you can use Transactional
> Replication with updating subscriptions (intended where very few changes
> are made at the Subscribers) or Merge Replication. Normal Transactional
> Replication in both cases only handles the Publisher making changes.
>
> Dan
>

"SANJAY PAWAR" <sanju@nisiki.net> wrote in message
news:evJItNAMHHA.3552@TK2MSFTNGP03.phx.gbl...
> Dear Dan,
>
> Thanks for the suggetions.
>
> I am using following commands from VB. Which does not work with MERGE
> Replication. It is asking for SNAPSHOT or TRANSACTIONAL. Pls suggest what
> modification it require ?
>
>
> Dim objSQLDist, objNetwork
> Set objSQLDist = CreateObject("SQLDistribution.SQLDistribution.2")
> 'Set objNetwork = Wscript.CreateObject("Wscript.Network")
> objSQLDist.Publication = mPublication
>
> objSQLDist.Publisher = mPublisherName
> objSQLDist.PublisherAddress = mPublisherAddress
> objSQLDist.PublisherNetwork = TCPIP_SOCKETS
> objSQLDist.PublisherDatabase = mPublisherDatabase
> objSQLDist.PublisherSecurityMode = DB_AUTHENTICATION
> objSQLDist.PublisherLogin = mPublisherLogin
> objSQLDist.PublisherPassword = mPublisherPassword
> objSQLDist.FileTransferType = PULL
> objSQLDist.Subscriber = mSubscriberName
> objSQLDist.SubscriptionType = ANONYMOUS
> objSQLDist.SubscriberSecurityMode = DB_AUTHENTICATION
> objSQLDist.SubscriberLogin = mSubscriberLogin
> objSQLDist.SubscriberPassword = mSubscriberPassword
> objSQLDist.SubscriberDatabase = mSubscriberDatabase
>
> objSQLDist.Initialize
> objSQLDist.Run
>
>
>
> "Daniel Crichton" <msnews@worldofspack.com> wrote in message
> news:%23Bk9wl$LHHA.2232@TK2MSFTNGP02.phx.gbl...
>> SANJAY wrote on Thu, 4 Jan 2007 17:27:39 +0530:
>>
>>> I have Publisher and Subscriber on 2 different locations.
>>> Data added on subscriber is getting deleted and overwritten by the
>>> publishers data at the time of synchronisation.
>>> I want 2 way update. Data can be added on PUBLISHER as well as
>>> SUBSCRIBER.
>>>
>>> Is it possible in Trans Replication ?
>>> OR is there any other alternative.
>>>
>>> Thanks in Advance
>>> Sanjay
>>
>> Depends on what version of SQL Server you have. From what I understand,
>> with 2000 you need Merge Replication, on 2005 you can use Transactional
>> Replication with updating subscriptions (intended where very few changes
>> are made at the Subscribers) or Merge Replication. Normal Transactional
>> Replication in both cases only handles the Publisher making changes.
>>
>> Dan
>>
>
>

"SANJAY PAWAR" <sanju@nisiki.net> wrote in message
news:uvHN6PAMHHA.1872@TK2MSFTNGP04.phx.gbl...
>I am unable to synchronise through sql server 2000 enterprise manager.
> It gives problem connecting remote server.
>
> Pls help.
>
>
>
> "SANJAY PAWAR" <sanju@nisiki.net> wrote in message
> news:evJItNAMHHA.3552@TK2MSFTNGP03.phx.gbl...
>> Dear Dan,
>>
>> Thanks for the suggetions.
>>
>> I am using following commands from VB. Which does not work with MERGE
>> Replication. It is asking for SNAPSHOT or TRANSACTIONAL. Pls suggest what
>> modification it require ?
>>
>>
>> Dim objSQLDist, objNetwork
>> Set objSQLDist = CreateObject("SQLDistribution.SQLDistribution.2")
>> 'Set objNetwork = Wscript.CreateObject("Wscript.Network")
>> objSQLDist.Publication = mPublication
>>
>> objSQLDist.Publisher = mPublisherName
>> objSQLDist.PublisherAddress = mPublisherAddress
>> objSQLDist.PublisherNetwork = TCPIP_SOCKETS
>> objSQLDist.PublisherDatabase = mPublisherDatabase
>> objSQLDist.PublisherSecurityMode = DB_AUTHENTICATION
>> objSQLDist.PublisherLogin = mPublisherLogin
>> objSQLDist.PublisherPassword = mPublisherPassword
>> objSQLDist.FileTransferType = PULL
>> objSQLDist.Subscriber = mSubscriberName
>> objSQLDist.SubscriptionType = ANONYMOUS
>> objSQLDist.SubscriberSecurityMode = DB_AUTHENTICATION
>> objSQLDist.SubscriberLogin = mSubscriberLogin
>> objSQLDist.SubscriberPassword = mSubscriberPassword
>> objSQLDist.SubscriberDatabase = mSubscriberDatabase
>>
>> objSQLDist.Initialize
>> objSQLDist.Run
>>
>>
>>
>> "Daniel Crichton" <msnews@worldofspack.com> wrote in message
>> news:%23Bk9wl$LHHA.2232@TK2MSFTNGP02.phx.gbl...
>>> SANJAY wrote on Thu, 4 Jan 2007 17:27:39 +0530:
>>>
>>>> I have Publisher and Subscriber on 2 different locations.
>>>> Data added on subscriber is getting deleted and overwritten by the
>>>> publishers data at the time of synchronisation.
>>>> I want 2 way update. Data can be added on PUBLISHER as well as
>>>> SUBSCRIBER.
>>>>
>>>> Is it possible in Trans Replication ?
>>>> OR is there any other alternative.
>>>>
>>>> Thanks in Advance
>>>> Sanjay
>>>
>>> Depends on what version of SQL Server you have. From what I understand,
>>> with 2000 you need Merge Replication, on 2005 you can use Transactional
>>> Replication with updating subscriptions (intended where very few changes
>>> are made at the Subscribers) or Merge Replication. Normal Transactional
>>> Replication in both cases only handles the Publisher making changes.
>>>
>>> Dan
>>>
>>
>>
>
>