replication between same server

Hi,
I am setting up a DataCenter database on SERVER1. my data is residing in
the different databases on SERVER1 as well. I am intending to do a
replication for each of the databases to DataCenter but i believe replication
cannot be done on the same server.
However, i would like the abilities of Replication to update DataCenter
whenever there's modification and new records automatically from the various
databases. How can i acheive this as there's no unique field in the tables of
these databases to allow me ensure that i am able to copy over all the new
records as well as modified records by using queries.
furthermore , all these databases are also replicated databases from
elsewhere , if i create a insert/modify triggers in these databases will it
work ? i.e during replication a record is inserted and will this be
considered a real insertion that will trigger off the triggers ?
Appreciate any advice
tks & rdgsHi
http://www.mssqlcity.com/Articles/Replic/Replic.htm --Setting All
Replica (Step by step)
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:83E7984A-50AC-4FA2-9541-EB2558EB7905@.microsoft.com...
> Hi,
> I am setting up a DataCenter database on SERVER1. my data is residing in
> the different databases on SERVER1 as well. I am intending to do a
> replication for each of the databases to DataCenter but i believe
> replication
> cannot be done on the same server.
> However, i would like the abilities of Replication to update DataCenter
> whenever there's modification and new records automatically from the
> various
> databases. How can i acheive this as there's no unique field in the tables
> of
> these databases to allow me ensure that i am able to copy over all the new
> records as well as modified records by using queries.
> furthermore , all these databases are also replicated databases from
> elsewhere , if i create a insert/modify triggers in these databases will
> it
> work ? i.e during replication a record is inserted and will this be
> considered a real insertion that will trigger off the triggers ?
> Appreciate any advice
> tks & rdgs|||Hi ,
Actually it's not a matter of me not able to set up replication but i
don't think Replication can occur on the same server between 2 different
databases as in my case.
So i am wondering if w/o having to write any queries (as the structure does
not allow me to uniquely identify whether a record is a new or modified one)
, can i have something that as automatic as replication in detecting changes
(such as a modified or new record)
I am thinking of using triggers actually ...
Appreciate any advice
tks & rdgs
"Uri Dimant" wrote:
> Hi
> http://www.mssqlcity.com/Articles/Replic/Replic.htm --Setting All
> Replica (Step by step)
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:83E7984A-50AC-4FA2-9541-EB2558EB7905@.microsoft.com...
> > Hi,
> >
> > I am setting up a DataCenter database on SERVER1. my data is residing in
> > the different databases on SERVER1 as well. I am intending to do a
> > replication for each of the databases to DataCenter but i believe
> > replication
> > cannot be done on the same server.
> >
> > However, i would like the abilities of Replication to update DataCenter
> > whenever there's modification and new records automatically from the
> > various
> > databases. How can i acheive this as there's no unique field in the tables
> > of
> > these databases to allow me ensure that i am able to copy over all the new
> > records as well as modified records by using queries.
> >
> > furthermore , all these databases are also replicated databases from
> > elsewhere , if i create a insert/modify triggers in these databases will
> > it
> > work ? i.e during replication a record is inserted and will this be
> > considered a real insertion that will trigger off the triggers ?
> >
> > Appreciate any advice
> >
> > tks & rdgs
>
>