We do this (not for every form, however). There are a subset of forms that we replicate to another SQL server using standard SQL server replication for reporting and the like. We don't run ITSM, but we do run Customer Support and several other home-grown apps.
For example, we don't need reporting (currently, anyway) for the entire support app, so we just replicate SHARE:Company, SHARE:Account, SPRT:Product_Owned, SHARE:Person, SHARE:Contact_base, SHARE:Employee_base, and SPRT:Issue. This seems to work well, SQL server doesn't seem to care about the Request ID field, just as long as it's tagged as a primary key column. Performance doesn't seem to be an issue (CS seems to be inherently slow anyway). Again, this works well for us, but we're not even close to replicating every form from the Remedy server. ARS 7.0.1 p6 SQL Server 2000 (ARSystem) SQL Server 2005 (replica/data warehouse server) Windows 2003 Mike On 2/11/08, Fossett, Darrel <[EMAIL PROTECTED]> wrote: > Some in our company want to use database replication to copy production > to a report server. This means that we would have two separate > instances of remedy on separate databases. > > I went through a little work of trying this a while back but we had > trouble with performance and the database replication did not like the > Request Id field as the unique identifier. I don't remember the > specifics it has been a little while back. > > We need to have both servers up at all times for reporting needs and > live production system. > > Has anybody ever done something like this? > If so what platform and apps did you use to do the transfer? > > I just want to make sure that someone has done this before so that I > know that it can be done. > > Darrel > > This email may contain material that is confidential, privileged, and/or > attorney work product for the sole use of the intended recipient. Any > review, reliance, or distribution by others or forwarding without express > permission is strictly prohibited. If you are not the intended recipient, > please contact the sender and delete all copies. > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
