Highlighted
Absent Member.. Absent Member..
Absent Member..
503 views

Whats the process to duplicate SM db from Dev to Test

We have installed and configured SM 9.34 server with all the configurations and integrations along with Process Designer installation. Instead of creating anotherTest environment, we'd like to duplicate this one. Whats the best way to get this accomplish this? SM is running on Windows server and SQL Server.

0 Likes
3 Replies
Highlighted
Absent Member.. Absent Member..
Absent Member..

If it's not problem to move all data and setting, I recommend you to move SQLbackup.

 

(1) stop SM service and backup SQL server by using SQL Management stuido.

(2) move backup file to Tset and recover it.

(3) run sm - dbunlockdatabase(see sm -helpall)

(4) run SM service on Test

(5) if you have some tairoing with hostname or IP, you should change it.

 

Regards.

Highlighted
Absent Member.
Absent Member.

You should take the installation directory (that is RTE) also to Test server, which include all binaries and configuration files like sm.ini and sm.cfg. It depends on from which version you moved. If from 9.3x then fine otherwise first install 9.30 then move the directories,
You have to reconfigure the database setting (in sm.ini) for new environment.

Regards,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
Highlighted
Acclaimed Contributor.. Acclaimed Contributor..
Acclaimed Contributor..

Have you tried to use Deployment Manager? It is tool for similar tasks.

 

Also if you have done all that on VM then you can make a snapshot and move it to other ins.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.