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.
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.
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.
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.
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.
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.