Migrating Control Center's database to a new server

You can migrate your Control Center's database to a new server and run your Control Center on the existing server.

Note

If you migrate your Control Center's database and also upgrade your Control Center, first migrate the database, then run the Control Center upgrade installation.

In case your Control Center is installed on Server1, your Control Center SQL database is located on Server2 and you want to migrate your SQL database to Server3, do the following:

On Server2 create your Control Center SQL database backup. Copy the database backup to Server3 and perform a database restore.
Uninstall Control Center on Server1.
Perform a fresh Control Center installation on Server1. While installing, select the option to install Control Center database on Server3. Since there is already a backup of your database on Server3, choose a different name for your new database.
Open your SQL Management Studio on Server3 and run the following scripts on your restored database. Scripts rename the users on your restored database so Control Center can recognize the users. (The old usernames are related to Server2.)

Note

$(DatabaseName) replace with NiceAN (your old database)

$(SchemaName) replace with nan

$(EPM_DB_ADMIN) replace with NEW_SERVER\EPM_DBADMIN

$(EPM_USER) replace with NEW_SERVER\EPM_USER
1. Create Windows or SQL credentials.
  
  Warning
  
  Edit the scripts before executing. Replace variable names $(VARIABLE_NAME).
```
USE [master];    
GO
```
2. Add permissions to EPM_DBADMIN user:
```
GRANT CONNECT SQL TO [$(EPM_DB_ADMIN)];
GRANT CREATE ANY DATABASE TO [$(EPM_DB_ADMIN)];
```
3. Create EPM_USER and grant permissions:
```
USE [$(DatabaseName)];
GO
CREATE USER [$(EPM_USER)] FOR LOGIN [$(EPM_USER)] WITH DEFAULT_SCHEMA = [$(SchemaName)];
GRANT CONTROL, EXECUTE, SELECT, INSERT, UPDATE, DELETE ON SCHEMA::[$(SchemaName)] TO [$(EPM_USER)];
GRANT CREATE TABLE TO [$(EPM_USER)];
GRANT CREATE SCHEMA TO [$(EPM_USER)];
```
4. Change the owner of SignalR schema:
```
IF EXISTS (SELECT * FROM sys.schemas WHERE name = 'SignalR')
BEGIN
     -- set schema owner
        EXEC ('ALTER AUTHORIZATION ON SCHEMA::[SignalR] TO [$(EPM_USER)];');
END
```
5. Change the owner of the database. Here is the syntax for Windows users:
```
EXEC ('ALTER AUTHORIZATION ON DATABASE::[$(DatabaseName)] TO [$(EPM_DB_ADMIN)];');
```
Rename your new Control Center NiceAN database on Server3.
Rename your restored database to the original name of your new Control Center NiceAN database on Server3.

You can delete your new Control Center NiceAN database on Server3 after you verify that your Control Center works fine.

Note

Note

Warning