Replication

I need to copy 10 Databases (150GB) to another SQL machine.
Now I need the destination machine to be updated every 24 hours.
Transcational replication is not helping me - cause it doesn't copy tables
without primary keys.
Snapshot replication is not helping me either - cause i can't transfer every
24 hours 150GB.
Help me please,
Aviad Avi.
You can use merge and configure it to only move the data one way. Add the
ExchangeType parameter to the merge agent with a value of 2.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||It seems you on something.
Can you please explain what do you meen by adding the ExchangeType parameter
with a value of 2?
Where should i configure the Merge?
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:QQXX4wl1EHA.768@.cpmsftngxa10.phx.gbl...
> You can use merge and configure it to only move the data one way. Add the
> ExchangeType parameter to the merge agent with a value of 2.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
|||Why does it called merge? because the uniqueidentifier colum that is added?
"Aviad Avi" <aviad00001@.yahoo.ca> wrote in message
news:%23RWGK1l1EHA.304@.TK2MSFTNGP11.phx.gbl...
> It seems you on something.
> Can you please explain what do you meen by adding the ExchangeType
parameter[vbcol=seagreen]
> with a value of 2?
> Where should i configure the Merge?
> "Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
> news:QQXX4wl1EHA.768@.cpmsftngxa10.phx.gbl...
the[vbcol=seagreen]
rights.
>
|||Moreover,
I think I need to run it with 1 value = push
don't I?
"Aviad Avi" <aviad00001@.yahoo.ca> wrote in message
news:%23RWGK1l1EHA.304@.TK2MSFTNGP11.phx.gbl...
> It seems you on something.
> Can you please explain what do you meen by adding the ExchangeType
parameter[vbcol=seagreen]
> with a value of 2?
> Where should i configure the Merge?
> "Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
> news:QQXX4wl1EHA.768@.cpmsftngxa10.phx.gbl...
the[vbcol=seagreen]
rights.
>
|||In the merge agent job, on the middle step, add -
ExchangeType 2 to the parameters list. This is one of
those cases where the parameter needs adding here rather
than to the profile. The values according to BOL are :
UPLOAD 1 Only merge Subscriber changes with the
Publisher.
DOWNLOAD 2 Only merge Publisher changes with the
Subscriber.
BIDIRECTIONAL 3 Merge all changes between the Publisher
and Subscriber (default).
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Snapshot and Transactional in their plain forms are
essentially unidirectional. Merge is bidirectional, and
the subscriber can change data offline, so there is the
potential that data can conflict. However, in certain
configurations a change to a different column on the same
row is not treated as a conflict and the changes
are 'merged'.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)