Skip to main content
NOT AVAILABLE IN SAAS.
Syteca supports moving the MS SQL Server database either to another location on the same computer, or to a different computer entirely.

​
Move the database on the same computer

1

Stop the Application Server

Right-click the Syteca Server tray icon and select Stop, or stop the EkranServer service via Task Manager.
2

Detach the databases in SQL Management Studio

Log in as an administrator. For each Syteca database (default names EkranActivityDB and EKRANManagementDatabase), right-click it and select Tasks > Detach.
3

Locate the database files

Navigate to the current storage location, by default:
4

Move the files

Move these files (and their corresponding _log files) to the new location:
  • EkranActivityDB, EkranActivityDB_log
  • EKRANManagementDatabase, EKRANManagementDatabase_log
5

Re-attach the databases

In SQL Management Studio, right-click Databases, select Attach, click Add, and select each moved database file.
6

Restart the Application Server

Start the EkranServer service again.

​
Move the database to another computer

1

Stop the Application Server

Right-click the Syteca Server tray icon and select Stop, or stop the EkranServer service via Task Manager.
2

Detach the databases

In SQL Management Studio, right-click each Syteca database and select Tasks > Detach.
3

Copy the database files

From the default location C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA, copy:
  • EkranActivityDB and EkranActivityDB_log
  • EKRANManagementDatabase and EKRANManagementDatabase_log
  • EkranUbaDatabase
  • Any archived databases
If binary data is stored in a shared or local folder rather than the database itself, copy that too.
4

Transfer the files to the new computer

Upload the copied files to a suitable location on the new SQL Server computer.
5

Attach the databases on the new computer

Log in to SQL Management Studio on the new computer, right-click Databases, select Attach, click Add, and select each uploaded database file.
6

Uninstall the Application Server on the original computer

See Uninstalling the Application Server.
7

Reinstall the Application Server

Select the MS SQL Server database type and configure the connection to the database that was moved.
8

Restart the Application Server

Start the EkranServer service.

​
Move a database signed with a certificate

If monitoring data is signed with a certificate, moving the database to another computer takes three steps:
1

Export and import the master certificate

Export the master certificate on the original Application Server computer, copy it to the new computer, and import it there.
2

Move the database

Follow Move the database to another computer above.
3

Re-enable certificate signing

Install the Application Server on the new computer, then enable signing with the imported certificate.

Moving the PostgreSQL Database

The equivalent procedure for PostgreSQL deployments.

Database management

Archive, cleanup, and validation settings.

Master certificate

Back up, export, and import the master certificate.

Migration of the Application Server

Move the Application Server itself to a new computer.