Migrating from Access to SQL: How do I migrate the TimeCard data from an Access to an SQL database?

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

If you find it easy depends on how familiar you are with SQL server tools. Follow these steps for migrating to an SQL database:
  1. Shutdown Outlook
  2. Go to the TimeCard network shared folder
  3. Move or copy the TimeCard3.mdb database to a backup folder
  4. Delete the TimeCard3.mdb database in the TimeCard network shared folder (that is, if you have not moved, but copied to a backup folder).
  5. Run TCCommonSettings.exe. TimeCard Common Settings will now prompt you to select a new database.
  6. Select the second option, use a SQL database. That will create a new empty database 'TimeCardSQL' under your SQL server.
  7. A new text file TimeCardConnection.txt will be created in the shared folder, which has detailed configuration information on the SQL server database.
  8. You can use any import tool (part of SQL server or 3rd party) to import data from the Access database (TimeCard3.mdb). You can also do it by simply opening each table and Copy-Paste.
  9. Once everything is copied, start Outlook.
  10. Run TimeCard Personal settings. You might be prompted that it was unable to find the TimeCard database and you may be offered to browse for TimeCardConnection.txt.
  11. Either:
    browse and select the TimeCardConnection.txt
    or
    cancel the prompt, change the reporting type to SQL server in Personal Settings and click the 'Configure...' button to connect to the TimeCard SQL database.
    Step 10-11 needs to be performed by each user on their Outlook/TimeCard Personal Settings.
Table of Contents (index)