How to move the MDB from a standalone server to a Remote Server.

Document ID : KB000054049
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

How to move the MDB from a standalone box to a Remote box.

Solution

There are a couple of ways to move the mdb:

Using SQL Server backup/restore tools:

  1. Install Service Desk's "remote components" on the new database server

  2. Move mdb to new server using SQL Server backup tools

  3. Configure Service Desk against the new database

Or using service desk to move the data:

  1. Install "remote components" on the new database server

  2. Extract the data from the current mdb using pdm_extract

  3. Configure Service Desk against the new database

  4. Reload the data using pdm_restore

Note: Using the SQL tools is working faster.