Migrating to a new SQL server:  what should I think about?

Table of Contents (index)
Problem Type : Database
Problem Category : TimeCard

Close the old server or rename the TimeCard database, so that users are prevented from reporting while you move the folders to the new SQL server.

When you have moved the TimeCard database to the new SQL server, you must do the following:
  1. Change the path in the text file TimeCardConnection.txt, so that it points to the new server.
  2. Run TCCommonSettings.exe and save it, to update the TimeCard database with the new path.
  3. Run TimeCard Personal settings. You will be prompted that it was unable to find the TimeCard database and you may be offered to browse for TimeCardConnection.txt.
  4. Either:
    browse and select the TimeCardConnection.txt
    or
    cancel the prompt and click the 'Configure...' button to connect to the TimeCard SQL database.
Step 3 and 4 needs to be performed by each user on their Outlook/TimeCard Personal Settings.
 
Table of Contents (index)