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.
- 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.
- 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:"
- Browse to the path noted in Step 2 and grab the backup of the database file (.bak) file
- 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.
- 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.
- 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
- To repoint the Enterprise database to the new Server,follow the below steps
II. Repointing Enterprise installs to the new Server/DSN
- 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.
- Follow the steps listed above on all the workstation installs.
- 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.
- 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.