Replication of specific records

How replication can be parameterized, let me clear what actually I
want. From publisher side I want specific records synchronization with
subscriber by passing parameter against that parameter publisher will
fetch the records and replicate that records to subscriber. Is it
possible in SQL Server 2000 or SQL Server 2005. If yes then please tell
me how is it possible, it will be appreciated, thanks in advance
regards
Shahzad TariqNo, you can't dynamically issue parameters against teh replication engine to
control what is synchronized. You can create filters on a publication such
that only a subset of the data is replicated between publisher and
subscriber.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Shahzad Tariq" <stariq@.gmail.com> wrote in message
news:1140447849.852129.291820@.g47g2000cwa.googlegroups.com...
> How replication can be parameterized, let me clear what actually I
> want. From publisher side I want specific records synchronization with
> subscriber by passing parameter against that parameter publisher will
> fetch the records and replicate that records to subscriber. Is it
> possible in SQL Server 2000 or SQL Server 2005. If yes then please tell
> me how is it possible, it will be appreciated, thanks in advance
> regards
> Shahzad Tariq
>|||Thanks Michael, it means if I want to transfer specific records from
one database to another by passing parameters I have to write my owner
scripts for that purpose I have to handle transactions as well in those
scripts so that in case any failure it rollback everything. So far I
have already written such kind of script for said purpose,anyway thanks
for your response.
Shahzad Tariq|||Thanks Michael, it means if I want to transfer specific records from
one database to another by passing parameters I have to write my owner
scripts for that purpose I have to handle transactions as well in those
scripts so that in case any failure it rollback everything. So far I
have already written such kind of script for said purpose,anyway thanks
for your response.
Shahzad Tariq