I have a simple question Dan, I am not being critical here either I just was wondering:
Why did you not go with mirroring of the DB solution? Respectfully, William Abdo From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Wangler, Dan Sent: Monday, May 17, 2010 10:51 AM To: arslist@ARSLIST.ORG Subject: DSO ** Dear List We are trying to implement a database replication by using DSO. We have a duplicate, parallel system to our production that is used for Analytics/reporting. We have setup DSO to push changes, as they occur, from the production (source) server to the parallel (target) server. Our thoughts were to use the target server both for reporting and as a hot backup. We have all workflow and escalations turned on but are sending transaction to the target server as Data Only. I wanted to check to see if anyone is doing this, using DSO to push to a reporting, and to solicit comments about this approach. I see one important issue. When a record is created or modified on the source server, the record always says it was modified last by “Distributed Server”. This is probably because DSO pushes the transaction to the target server and returns a “Successful” transfer back to the source server. Is there anyway to retain the “real” last modified by and last Modified Date? While the information on the target server is correct, it is confusing to the user on the source server. In addition, while DSO is updating fields with the successful status, another user could have open the form and get the message saying the ticket had already been updated by someone else since the user opened it. Is there someway to prevent this from happening? Another issue we see is that as information is pushed from the source server to the target server, filters are driven on the target server. In some cases, modifications on one form causes an update to a different form and could lead to permissions issues. Is there someway to stop this without adding to the filter qualification “USER’ != “Distributed Server”? One way, I can think of, is placing the target server in Admin Only mode. Would the DSO creates and updates take place in Admin Only? Any comments or suggestions would be greatly appreciated. Regards Dan Dan Wangler, SAIC; MHS Remedy Support Team Tri-Service Infrastructure Management Program Office (TIMPO) 300 Convent St, Suite 1800; San Antonio, Texas, 78205 Phone: 210-338-3162; Email: dan.wangler....@timpo.osd.mil _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_