Home >FAQ >TimeCard kalmstrom.com site map icon Site map  

kalmstrom.com FAQ – TimeCard


Category TimeCard

Type Database

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

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

If you find it easy depends on how familiar you are with SQL server tools. Follow these steps for migrating to an SQL database.

TimeCard Admin:
  1. Close Outlook
  2. Move or copy the TimeCard3.mdb database to a backup folder
  3. If you just copied the .mdb file in the original direction, delete it in the original shared folder now when you have a backup copy.
  4. Open Outlook. Now the TimeCard Sharing Options dialog will be shown, and you can select a new SQL Server database. That will create a new empty database 'TimeCardSQL' under your SQL server.
  5. Close Outlook again.
  6. Now you can use any import tool (part of SQL server or 3rd party) to import data from the backup of the Access database. You can also do it by simply opening each table and Copy-Paste.
  7. Once everything is copied, start Outlook again and make sure the settings are ok.
TimeCard Users:
  1. Open Outlook. The TimeCard Sharing Options dialog will be shown, and each user can select the new SQL Server database.
Products Buy FAQ Services Apps Tips Education Contact About Us Blog

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved