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.