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/st_aff1 Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1731 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:>
