Relocating Databases to SQL Server

 

You can relocate (migrate) databases from Jet/MSAccess to SQL Server, or from one SQL Server to another. To relocate databases to SQL Server, you must have a license for Vector HelpDesk SQL Enabled.

There are two types of databases you can relocate:

    Global databases are the databases shared by all projects: the users database (users.mdb), the Web views database (censusweb.mdb), and the licenses databases (licenses.mdb).

    Project databases contain issues and project definitions (such as the definitions of fields, queries, and reports).

To relocate databases to SQL Server:

1    Log on to HelpDesk Web Admin:

    In HelpDesk Admin, click Tools > Relocate > Databases to log on to HelpDesk Web Admin, where you can use the Relocation tab to relocate databases to SQL Server.

    In your Web browser, go to //server/helpdeskadmin, where server is the name of your Web server.

2    On the Relocation tab, under Databases to relocate, select the databases you want to relocate.

3    In the Relocate databases to this SQL Server list, click the computer to which you want to relocate the databases.

To relocate to a SQL Server instance, click Add a SQL Server to this list and then type the instance name using the syntax <computer name>\<instance name>.

4    In the New location for database files box, enter the name of a folder on the Server where the database files (*.mdf, *.ldf) can be stored.

The new location must be the path as seen from the Web server. If the SQL Server is in a different computer, enter a UNC., otherwise, enter a local path.

5    Click Apply to relocate the databases.

6    During the relocation, you may be prompted for the password for the sa SQL Server login account. Vector HelpDesk needs the password so it can initialize the SQL Server.

7    After the databases are relocated, regenerate your Web views.

If you relocated the global databases, regenerate all Web views. If you relocated project databases, regenerate the Web views of the relocated projects.

Notes

    We recommend that all databases be stored on the same SQL Server computer. This improves performance by reducing the amount of data sent over the network.

    When relocating databases from one SQL Server to another, the locations of the physical data files (.mdf,.ldf) on both the source and target computers must be accessible from the Web server. Also, the user running HelpDesk Web Admin must have full permission to move and create files on the locations .

    Relocating databases logs off users and prevent users from logging on, so choose a time when there is little or no activity on Vector HelpDesk.

    When you relocate a database to SQL Server, Vector HelpDesk creates a SQL Server database with one data file and one log file. After the database is created and is accessible in SQL Server, database administrators can add more files or configure the database as required.

    Vector HelpDesk creates a SQL Server login account named censusapplication, which is used to connect to the SQL Server.

Related Topics

Troubleshooting Relocation

Generating Web Views

Relocating Attachments

Editing Project Properties

Troubleshooting HelpDesk Web Admin

Releasing Databases