Access to SQL: Is it easy to migrate the Folder HelpDesk 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. The process is the same for SQL Server and SQL Azure.
-
Shutdown Outlook.
-
Move the FolderHelpDesk.mdb database to a backup folder.
-
Delete the FolderHelpDesk.mdb database in the
Folder HelpDesk
network shared folder (that is, if you have not moved, but copied to a backup folder).
-
Start Outlook and click the
Folder HelpDesk
Outlook folder.
-
Folder HelpDesk
will now prompt you to select a new database. Select one of the SQL options that will create a new empty database.
-
Do not perform any ticket operation from Outlook yet, as you need to manually migrate the ticket data from Access to the SQL database.
-
You can use any import tool (part of SQL server or 3rd party) to import data from the Access database (FolderHelpDesk.mdb ). You can also do that simply by opening each table and copy and paste.
-
Once everything is copied, start Outlook and use
Folder HelpDesk
as you would normally do.
|