Is it easy to migrate the PF HelpDesk data from an Access to an SQL database?

Table of Contents (index)
Problem Type : Database
Problem Category : Public Folder HelpDesk

If you find it easy depends on how familiar you are with SQL server tools. Follow these steps for migrating to an SQL database. The process is the same for SQL Server and SQL Azure.
  1. Shutdown Outlook.

  2. Move the PFHelpdesk.mdb database to a backup folder.

  3. Delete the PFhelpdesk.mdb database in the PF HelpDesk network shared folder (that is, if you have not moved, but copied to a backup folder).

  4. Start Outlook and click the PF HelpDesk Outlook folder.

  5. PF HelpDesk will now prompt you to select a new database. Select one of the SQL options that will create a new empty database.

  6. Do not perform any ticket operation from Outlook yet, as you need to manually migrate the ticket data from Access to the SQL database.

  7. You can use any import tool (part of SQL server or 3rd party) to import data from the Access database (PFHelpdesk.mdb). You can also do that simply by opening each table and copy and paste.

  8. Once everything is copied, start Outlook and use PF HelpDesk as you would normally do.
Table of Contents (index)