We're on a Windows server 2003, MS SQL 2005 environment and all we had to do was update the "Sybase-Server-Name: " parameter in ar.cfg. Our DBA copied all of the DB accounts over to the new server. If you have users that have connection strings in Excel macros, Crystal Reports, etc. that connect to the DB directly, they will have to modify those.
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Marty.Thorin Sent: Thursday, February 05, 2009 9:44 AM To: [email protected] Subject: Migrating databases ** Good morning: I need to move my database from one Oracle server to another. I shall have the DBA copy the arsystem database from the old server to the new. I know I need to change the file ar.conf. Do I need to do anything else? <from today's ar.conf> Db-name: arsystem Db-user: ARAdmin Dbhome-directory: /usr/oracle/product/10.2.0/client_1 Oracle-Two-Task: ORDDPS1G.WEPCO Db-Character-Set: UTF-8 <end ar.conf> Statistics: ARS 7.1.0 Patch 5 Oracle 10g This is our first Remedy system using Oracle. All previous systems used Sybase. Thank you for your help. Thorin __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
