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