Please use the Copy Live to Play wizard, to copy the live database data into the play database. Please complete the following steps:-
Log into Orchestrate System Manager
Select System Settings
Select General tab
Click on for Enable Copy Live to Play
Click OK
Log into Orchestrate
Select Tools
Select Copy Live to Play
Click Next
Use Windows Authentication or SQL server authentication
Click Next and Copy
Relevant users must have Orchestrate Admin role in both the live and the play databases. You must have enough SQL permissions to back up the live database and restore the play database. The minimum privileges include:
Live Database: users to have db_owner database role.
Play Database: the user is the owner of the database (dbo). Having db_owner database role isn't enough.
Users could have more permissions that can allow them perform Copy Live to Play including:
sysadmin fixed server role or dbcreator fixed server role.
Using the Copy Live to Play Wizard
Step 1 within the wizard will display the current SQL Server you are using, Also the Live Database that you are using, these fields are both greyed out.
A second field displays the 'To' destination which is the name convention that the Play Database will be named, this field is just visual and cannot be altered in any way.
Log on to the server, you have the option to either Use Windows Authentication, or User SQL Server Authentication.
If Use Windows Authentication is selected, the system will asses the users permissions as per mentioned within the Minimum SQL Permissions, the User SQL Server Authentication appears as greyed out.
If Use SQL Server Authentication is selected the User Name and Password fields become editable, validation will asses whether the correct username and password has been entered into these fields, it also checks that the user has sufficient permissions to carry out the Copy Live to Play operation.
If you are using our hosted servers, please raise a new case online referencing the title of this article and a member of our support team will be able to help you further.
Please upgrade to Orchestrate version 7.78 hotfix 20 where an additional permission created in the roles, set to Deny by default (even for the Admin role) has been implemented to designate only certain admin users to run copy live to play. It can be set as Allow for specific users using user permissions. If the permission is enabled, the Copy Live to Play button should show, otherwise it should be hidden. No changes are required to the Copy Live to Play service itself, running on the server.