Migrating PANTHEON to a New Server

In this chapter, we will introduce you to the reinstallation of the PANTHEON software or migration to a new server.

1. Arranging a database backup

When migrating a database, it is first necessary to perform a backup of the database. This can be done through the Management Studio or through PANTHEON. The backup is then transferred to another computer/server.

For instructions on how to back up your database, see chapter Backup.

2. Reinstalling the program

The second step is to reinstall the program to a new location.

For instructions on how to install the program, see Installation of PANTHEON and required components.

3. Adding users at server level

In order to allow users to access the database at a new location, it is necessary to add users at SQL level. The user does this using the AddUsers tool.

For instructions on how to add users to the server level, see AddUsers – adding database users.

4. Restoring the database

There are several ways to restore the database:

• Using the Management Studio: instructions can be found in chapter Restoring database onto SQL server.
• Using the isqlw console (or Management Studio with sql command):

  restore database IMEBAZE from disk = 'c:\POT\DO\BACKUPA\BkpDatalab19991105133614.dat' with

  move 'DataLab_Data' to 'c:\POT\PRIPETE\BAZE\MDF\DataLab_Data.mdf',

  move 'DataLab_Log' to c:\POT\PRIPETE\BAZE \LDF\DataLab_Log.ldf'

• Using PANTHEON: you can find instructions in chapter Backup.

5. Releasing the license

After a successful migration of the database, the final step – the release of the licence – must be done before the database can be used. To do this, please inform Datalab's support centre of the successful migration by sending an email to: pomoc@datalab.si.

It is recommended to send your request before the migration starts, or arrange a day before your license needs to be released. In this way, PANTHEON will not be disrupted.