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/t.asp?id=2439&p=go/dr_text_aff1 Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1733 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:>
