Rank: Administration Groups: Member
Joined: 4/21/2009 Posts: 3 Location: Durant, OK
|
When moving the TAM database (FundMan) from one server to another, the database connection string in the TAMCommon.config file must be updated to reference the new database location. Since the connection string is encrypted in the .config file, it is necessary to use TAMCommon configuration utility (TAMCommonConfig.exe). This is typically located under the ServerSetup folder in the installation media folder.
The following steps may be performed to move the database from one server to another: 1) Ensure all clients have logged out of TAM. 2) Create a backup of the FundMan database on the old server. 3) Stop the database on the old server. 4) Copy the proper .mdf and .ldf files from the old server to the new server. 5) Attach the database on the new server. 6) Run the TAMCommonConfig.exe utility to update the shared TAMCommon.config to reference the new database location. 7) Run TAM on the client computers and verify that they can see the database without problems.
|