Hi Kay
"Publisher" can be the same machine with "publication" Well it depends I try
to say this as you are publisher of magazine called "Penthouse" which is
your data server and you have distributor called "Vendor" in this
"publication" and you have subscriber called "noughty"
Penthouse can take roles as vendor for reason it cost less since you donot
need to set setup new server called vendor however this will make Penthouse
inefficient (" extra work to do double job like what Michael mention in his
email")
That's why you saw the article that show Penthouse and vendors are on
different servers
However it doesnot make sense if Penthouse need tobe a subscriber
subscribers are your client and normally in different servers in this case
myhouse or anybody's house. Now if you want to make your publisher's job
easier now you have to decide
you want to send the magazines to your subscriber or you ask the subscriber
to pick the magazines themselves
Kay everything can be done using your enteprise manager and make sure your
"agent" running at the same acct as your server
Regards
snapple
----- Original Message -----
From: "Kay Smoljak" <[EMAIL PROTECTED]>
To: "SQL" <[EMAIL PROTECTED]>
Sent: Wednesday, November 12, 2003 9:49 AM
Subject: RE: Replication
> Thanks snapple...
>
> I had a look through the BOL - I should have looked there first!
>
> One thing I'm not sure of though... Does the remote server need to be
> involved in the process? Can the "publisher" be my local database server,
> which publishes the data from the remote server to a "subscriber" which is
> actually itself? Or does the publisher have to be the remote server
itself?
> I saw something about the publisher being separate from the server with
the
> "publications" but not about the publisher and the subscriber being the
same
> server. If I can remove the need for my shared hosting provider to
actually
> do anything it would be much better. Or would I be able to set it up
myself
> using Enterprise Manager, seeing as I am the dbo for that particular
> database?
>
> Cheers,
> K.
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, 12 November 2003 9:34 AM
> > To: SQL
> > Subject: Re: Replication
> >
> > Hi Kay
> >
> > Replication is the answer since you do not need to update
> > quite often just use snapshot replication it is straight
> > forward process Check Snapshot replication on your book online
> >
> > Another way is you can create a trigger to update your
> > development server for every events happen but you must
> > create a link server between live server and your development
> > server this is straight forward as well but with trigger you
> > can manipulate data to suit your need while replication is
> > exact replica on what you want
> >
> > Both will give the same result
> >
> > Regards
> > snapple
> > ----- Original Message -----
> > From: "Kay Smoljak" <[EMAIL PROTECTED]>
> > To: "SQL" <[EMAIL PROTECTED]>
> > Sent: Wednesday, November 12, 2003 8:12 AM
> > Subject: Replication
> >
> >
> > > I was wondering if anyone uses MSSQL Server replication. I
> > have sites that
> > are hosted on shared hosting, and a development server in the
> > office. One
> > site in particular has quite frequent data updates, and I'd
> > like to keep my
> > development copy fairly well synchronised with the live
> > version. At the
> > moment every couple of weeks I do a DTS transfer of the main
> > tables, but
> > this is obviously time consuming and probably not the most
> > efficient way to
> > go. Would replication be the answer? Is it something that
> > shared hosts are
> > likely to allow (my host is fairly accomodating usually)?
> > >
> > > I was reading
> > http://databases.about.com/cs/sqlserver/a/aa041303a.htm and
> > I pretty much understand the concept, but what I still don't
> > know is whether
> > it's a good idea in my situation or not :)
> > >
> > > Thanks in advance for any advice or experience you can share,
> > > Kay.
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://affiliates.macromedia.com/b.asp?id=2439&p=go/fl_aff1
Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1739
Archives: http://www.houseoffusion.com/lists.cfm?link=t:6
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>
