You must change all the references to the ar.cfg file (ar.conf) regarding your
current instance.
Also you must check and be sure that your host file has been update if your
hosts name changes for the app server and the db server (just in case that the
db is set on a remote location).
An easiest way that I use on windows/SQL env is the next:
* Load your current SQL DB on the new SQL Server... Load tables, permissions,
users, etc.
* Move all your filesystem (or directories in this case) and place it in the
same location from your current server into the new one.
* Run the installer for ARS, and chose the upgrade option (If you have custom
views of fields on User and Group Forms, i recommend that have a backup from
this forms and data, if you dont have any customization, the backup is not
needed)
* Enjoy the show!!! (Just Kidding)
Regards
Hugo Ruesga perotsystems® US 972.577.7000MX +52 (33) 3332.3868
P Please consider the environment before printing this email
The information contained in and transferred with this electronic message is
intended only for the recipient(s) designated above, it is protected by law and
it may contain information which is privileged and confidential. If you are not
the intended recipient, please do not read, copy, or use it, and do not
disclose it to others. Please notify the sender of the delivery error by
replying to this message, and then delete it from your system. Thank you.
Date: Thu, 9 Oct 2008 12:05:06 -0700From: [EMAIL PROTECTED]: database instance
moveTo: [EMAIL PROTECTED]
Hi group,
We need to move the ARSystem database from the old SQL instance to
a new SQL instance. Can you please let me know what the application connection
strings (like changing the database name in ar.cfg etc.) may be changed? What
are the steps to be followed for that, or what are the precautions that need to
taken prior to the move. We are on AR Server 7.1 Patch 3, SQL server 2005 and
windows 2003 R2. The environment its going to be moved to is going to be
similar. We are not trying to migrate the AR Server installation to a new
machine but just moving the tables in the ARAdmin account in the old SQL
instance to a new instance of SQL Server. Do I need to make any changes for the
Mid-Tier settings to make it work?
Thanks
Sivarama__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
_________________________________________________________________
Es tu última oportunidad para ganar premios por el simple hecho de buscar en
internet.
http://www.ganabuscando.com/Default.aspx
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"