How to move Statistica Enterprise Metadata database from one SQL Server to another SQL Server

How to move Statistica Enterprise Metadata database from one SQL Server to another SQL Server

book

Article ID: KB0083464

calendar_today

Updated On:

Products Versions
Spotfire Statistica 8.0 and above

Description

User wants to move Statistica Enterprise metadata database from one SQL Server to another due to various possible reasons - Server upgrade/ SQL Server Upgrade/ managemenet decisions to relocate the server.



 

Issue/Introduction

This article covers how to move Statistica Enterprise Meta database from one SQL Server to another SQL Server.

Environment

Windows operating systems only. MS SQL Server versions only.

Resolution

Moving Statistica Enterprise Meta database is a 2-step process involving:

      I. The actual physical move of the database

      II. Repointing Enterprise installs to the new Server/DSN.

I. The best way to  move the Statistica Enterprise meta database from one server to another is for an Administrator /DBA using the SQL Server Management Studio Tool.

Important Note:  Ensure that the new SQL Server version is the same version as the old SQL Server or newer. There might be restoration problems due to version compatabilty otherwise.

  1. On the old SQL Server, connect to SQL Server Management Studio and locate the Statistica Enterprise Meta database. Look up the System DSN named SEWSS from Control Panel | Administrative tools | Data Sources (ODBC) if unsure of the database Statistica is pointing to.
  2. Right click on the Statistica Enterprise meta database and Click Tasks | Backup... Let the options be default and make a note of the path under the option "Back up to:" 
  3. Browse to the path noted in Step 2 and grab the backup of the database file (.bak) file
  4. Copy the .bak file the new server. Place it in the same relative folder of the SQL Server install or copy to a known location on the server.
  5. Open SQL Server Management Studio on the new server and right click on the folder named Databases and select 'Restore Database'. Type a name for the database and click on From device option. Click on the ... button next the option to add the .bak file.
  6. Click on Add in the Specify backup dialog and browse to the .bak file saved on the new Server. Click Add after choosing the .bak file
  7. To repoint the Enterprise database to the new Server,follow the below steps
II.  Repointing Enterprise installs to the new Server/DSN
  1. Remote into the server and open Control Panel | Administrative tools | Data Sources (ODBC) | System DSN and click on the SEWSS DSN and click Configure. Point to the new server and give the credentials for the server and point to the Enterprise meta database.
  2. Follow the steps listed above on all the workstation installs.  
  3. Locate the file named ent.dsn in the Statistica install folder in the server ( For version 13, by default this would be : C:\Program Files\Dell\Statistica 13\) and email the file to TIBCO support along with details of the new Server name, DSN name,Database Name, UserID for the database, Password for the database so that the file can be encrypted for future workstation installs.
  4. TIBCO Support will send a new ent.dsn file , which should be updated on the Statistica Enterprise Server in the Statistica install directory and Statistica install Workstation Installer 64  directories.

Additional Information

Legacy Article ID: 147682