your data is organised. If your subscriber receives partial dataset (through
filtering) then there would not normally be a case to use this clause.
elsewhere (e.g. at the publisher or some other subscriber) then you would
conflicts). If the above are not concerns then no need to use the where
"Samir R. Ibrahim" <samir.ibrahim@wilcopm.com> wrote in message
news:OrfcOGx$DHA.2040@TK2MSFTNGP12.phx.gbl...
> Thank you very much Raj for answering and this soultion.
>
> Actually i already was doing the push subscribtion with no schema. But my
> solution was is to export the recored from each table on the subscribor to
a
> new table and then import these table from the publisher. but your
solution
> is more efficent and quick. indeed Nice Trick.
>
> But i have a qyestion to you, what if i didnot specify any condition in
the
> WHERE ? that will take all the data fro the subscribor, is there is wrong
in
> that?
>
>
> "Raj Moloye" <rkmoloye@hotmail.com> wrote in message
> news:eqW83Ww$DHA.3352@TK2MSFTNGP09.phx.gbl...
> > Hello Samir,
> >
> > If you haven't got anything better, try this, if you are using merge
> > replication.
> > Create a push subscription normally, except where you are asked to
> > initialise the data at the Subscriber, select No. This way when you
> > synchronise, the data at the subscriber will not be lost. This also
> depends
> > on how your snapshot has been configured to happen (drop table, keep
data
> > etc...)
> >
> > Normally, the data from the subscriber should synchronise to the
> publisher.
> > If not, depending on your data organisation, you can induce updates into
> the
> > tables using statements like:
> > UPDATE <table_name>
> > SET <column_name1> = <column_name1> (use any one column from your
> > table)
> > WHERE <some condition>
> >
> > The WHERE clause should be well thought out so that only data belonging
to
> > the subscriber are updated.
> > Note: in the statement above we are updating values to themselves, so we
> are
> > not actually changing anything to the underlying data. However,
> replication
> > will capture them as changes to be updated to the publisher (nice
trick!!)
> >
> > Hope this helps.
> > Raj
> >
> >
> > "Samir R. Ibrahim" <samir.ibrahim@wilcopm.com> wrote in message
> > news:uDV9iSv$DHA.2524@TK2MSFTNGP10.phx.gbl...
> > > How can i re-create an alread push subscribtion that was deleted but
> > before
> > > that i want to get the data from the subscription server before the
main
> > > server send his data?
> > >
> > > Samir R. Ibrahim
> > >
> > >
> >
> >
>
>
