Migration to a new server

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

1. Arranging a backup of the database

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

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

2. Reinstalling the software

The second step is to arrange for the programme to be reinstalled in the new location.

For instructions on how to install the software, see Installing the software and necessary 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 users to the server.

4. Base restoration

There are several ways to restore the database:

• Via Management Studio: instructions can be found in Connect a database to SQL Server.
• Via 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'

• Via PANTHEON: you can find instructions in the Backup section.

5. Release of the licence

After the successful migration of the database, the final step, the release of the licence, must be arranged before the database can be put into use. Please inform Datalab's support centre by sending an email to: pomoc@datalab.si.

It is advisable to send your request before the migration starts, or arrange a day before you need to release your licence. This way, PANTHEON will not be disrupted.