Knowledge Base

Move TT&E database to a new server

Expand / Collapse
 

Move TT&E database to a new server


Occasionally, you will have the need to move your SQL Server database to a new server.  To move a database, you will need SQL Server Enterprise manager or another MSDE administration tool.

Before any database major database maintenance, be sure to backup your database!

If you are using MSDE, run the Timeless MSDE installation.  After the installation has completed, use SQL Server Enterprise manager or your choice of MSDE administration tools to detach the Timeless database from the TIMELESS_MSDE database server.

Detach the Timeless database from the old server.  Next, copy the Timeless database from the old server to the new server.  If using TimelessMSDE, you will copy over the database files on the new server.  Now, attach the copied database to the new server.  Finally, run the Reset TT&E SQL Server database utility to reset user names and passwords.

To point Timeless Time & Expense Enterprise for Windows to the new server, rerun the installation on each client to select the new database server.  If you are comfortable modifying the Windows registry, you can change the HKEY_CURRENT_USER\Software\MAG Softwrx\Timeless Time & Expense Multiuser\Database\LastDatabaseServer key to point to the new server.

To point Timeless Time & Expense Enterprise for Web to the new server, modify the web.config file on the web server and change the <appSetting> databaseLocation key to the new server.



Rate this Article:
     

Add Your Comments


Comment require login or registration.

Details
Last Modified:Wednesday, October 08, 2008
Last Modified By: MAG Softwrx, Inc
Type: HOWTO
Article not rated yet.
Article has been viewed 8,969 times.
Options