First off, Evaluate your need for the data. Do you need to develop against the most current data? What is wrong with your DTS setup now? Are you just interested in learning ore about replication?
Snapshot replication is less taxing than transactional replication but still taxing nonetheless and provides no greater advantage over DTS in YOUR situation based on what you told us so far. Triggers are not necessary, and the overhead cost would not be worth it if traffic is heavy. I disagree with snapple... replication and triggers are not for you... I say stick with DTS and grab the data once or twice a day at low traffic times. Mike -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 8:34 PM 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. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the mailserver that powers this list at http://www.coolfusion.com Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1732 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:>
