This article describes the steps to perform when you need to copy one customer environment to another (new) environment for the same customer - e.g. copy test to prod or the opposite.
Start by unzipping the content of this zipped folder - it contains all the needed scripts:
Step-by-step guid
1) Take backups of everything (both from databases and to databases)
2) Take a copy of install_acctual_site table from _dam database (in a seperate fil eg. excel)
3) Stop Digibatch, digimonitor, resetpassword and website + app pools
4) Delete the logfiles for Digibatch, Digimonitor and website (Optional)
5) Copy the 2 .bak files to the database you want to overwrite.
6) restore the databases
6b) Check the ownership of the databases. It should be an SA user.
7) Create schematics on both databases (1a_CreateSchemas.sql)
8) Create/connect users to schematics with the correct roles (1b_Addusers.sql)
9) Copy over schematics rights using script: 1c_MoveSchmeaObjects.sql
10) Change the owner of the schematics admin_dmm4standard_dam + admin_dmm4standard_dam + UserMgmt (1d_ChangeSchemas.sql)
11) Delete old schematics admin_OLDNAME_dam and admin_OLDNAME_dam_jobs on both databases
12) Null the completed date for search proxy scripts (1e_ResetSearches.sql)
13) Delete everything from service broker (2a_DROPSB.sql) (Check that everything has been removed sometimes a few autogenerated need to be cleared manually)
14) Delete the old users from both databases.
15) Login as admin_NAME_dam user (password = username)
16) Run scripts for SB (2b_RebuildServiceBroker.sql + 2c_ServiceBrokerItemLastChanged.sql)
17) run the first script entry from search_proxy_scripts to create the search service broker (You can get it, by rightclicking the table and select edit top 200 and select all from the script collum)
18) Logon as your Server admin
19) Run the script 2d_EnableServiceBroker.sql
20) run the updateDZConfig script
21) run the updateinstallAcctuallsite script
22) Edit the stored procedures you get from running the script: 5_GetSPs.sql replace the old datbasename (NAME_dam_Jobs) with the new (NAME_dam_Jobs)
23a) Reconfigure web.config files update user passwords
23b) Create the database ref
23c) Start the Digizuite website and check you can login
24) Update Digimonior instances by running the script 6_UpdateDMInstance.sql
25) Check the Digimontor instances to make sure you didnt miss any.
26) Repopulate the searches by running https://URL/apiproxy/JobService.js?accesskey=xxx&method=PopulateAllSearches - replace xxx with a valid accesskey from the script 5_GetAccessGUID.sql
27) Start DigiMonitor (Reconfigure config files first -update user passwords)
28) Configure Digibatch and re-enroll the jobengines.
29) Start Digibatch
30) Check the jobs created by the "Repopulate the searches" are being processed.
31) Recreate and publish any SOLR searches - clean up the old ones.
When the jobs has completed: Test