Start your FREE Trial of NetHelpDesk!
Print

Migrate NHD SQL Database from one Instance to Another

There may be a few reasons you wish to migrate NetHelpDesk from one SQL instance to another. These include:

There are three options when migrating in NetHelpDesk:

OPTION M1

Use an existing SQL Server instance on a different machine, perhaps a dedicated SQL Server, and manually import an existing SQL Server NetHelpDesk database, and manually create/adjust shortcuts.

or

OPTION M2

Create a new SQL Server instance on a different other machine, perhaps a dedicated SQL Server, and manually import an existing SQL Server NetHelpDesk database, and manually create/adjust shortcuts.

or

OPTION M3

Use an existing or a create a new SQL Server instance on a different machine, and upsize a Microsoft Access NetHelpDesk database into a SQL Server NetHelpDesk database.

Whichever option you choose, and whatever the reason, migrating NetHelpDesk is easy to do, and the installer is not needed.


Important Notes

Some initial considerations when migrating from one SQL Server Instance to another:

Most important of all: Take a backup of your existing SQL Server database.


Backing up your existing NetHelpDesk SQL Server Database

As good practice, all activity to the database should be stopped (Agents logged out, NHServer processes stopped), and a copy of your database made.


Using a Pre-Existing SQL Server Instance

For Option M1, if the SQL Server instance is pre-existing, it will need some configuration checks before restoring the NetHelpDesk pre-configured database to it.


SQL Server Management Studio

Launch SQL Server Management Studio, and login using a high level access login to the instance. If the “sa” account exists, you’ll need to be able to log into the instance with it. When logged in:


SQL Server Configuration Manager

Launch SQL Server Configuration Manager:

Migrate SQL 1
Migrate SQL 2
Migrate SQL 3

How To Restore the .bak Database

Now locate the backup created earlier.

Migrate SQL 4

Configuring a new UDL file for use with SQL Server

With Option SQL2 or Option SQL 3, the data link file, which links the NetHelpDesk interfaces to the SQL Server database, will need to be updated. The data link file is called NetHelpDesk.udl, and one is automatically created and configured for you if following the installer.

If not, you will have to do this manually. To achieve this:

Migrate SQL 5
Migrate SQL 6

Should you have any questions regarding any steps in this guide, please speak with the NetHelpDesk Support Team.

Our software is available on multiple platforms...

NetHelpDesk is available on a range of devices with industry-leading functionality available throughout.

  • Windows Phone

    Windows Phone

  • Android

    Android

  • iPhone

    iPhone

  • BlackBerry

    BlackBerry

  • Tablets

    Tablets

  • Windows

    Windows

Close

Cookie Policy

We use cookies to enhance your experience on our web site. By using our website or closing this message, you are agreeing to our Cookie Policy.