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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Protect your mail server with built in anti-virus protection. It's not only good for you, it's good for everybody. http://www.coolfusion.com/products/prismav/prismavforcoldfusion.cfm Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1730 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:>
