Phil- Thanks for the reply. I he did use transactional, which seems like it should not have caused problems, and the BMC tech we talked to said it was supported.
Once he put it on the dev side, everything appeared to be fine until form changes occurred- if you have anyone looking to use it I'd definitely suggest testing it on a test/dev install and doing form changes both in the admin tool and the class manager to make sure things are acting like they should. Chris From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Phil Murnane Sent: Friday, June 06, 2008 9:29 AM To: arslist@ARSLIST.ORG Subject: Re: Cautionary tale? SQL Replication service and Remedy Chris: What kind of "replication" did your DBA set up? We have a customer looking at this type of configuration in order to create a reporting server. They're deciding between either transactional replication with a read-only consumer or a mirrored database with snapshots. BTW, we did some testing a few years ago with SQL Server 2000 and transactional replication with read-write consumers, and that failed miserably because SQL Server added columns to every table to be replicated, which of cource confused arserver.exe terribly. Thanks, --Phil __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
