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.
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.
You have to reconfigure the database setting (in sm.ini) for new environment.
Assign Kudo, if found post useful and mark it accepted if solves the issue.
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.