Details
-
Suggestion
-
Resolution: Fixed
-
None
Description
We should add a step on the Create a staging environment for upgrading Confluence article to account for Triggers that need to be updated should the database name be changed (as we actually advise on step 2).
https://confluence.atlassian.com/doc/create-a-staging-environment-for-upgrading-confluence-866094180.html
Suggestion
Add the below step ("2.3") to the existing list:
2. Replicate your database
To replicate your database:
- Back up your production database. Refer to the documentation for your database for more info on the best way to do this.
- Install your database on the staging server and restore the backup.
3. Recreate any DB Trigger that may still reference the original DB name. For SQLServer, for example, the following query may help identifying them:
SELECT table_name = so.name ,trigger_name = st.name ,trigger_text = sc.text ,create_date = st.create_date FROM sys.triggers st JOIN sysobjects so ON st.parent_id = so.id JOIN syscomments sc ON sc.id = st.[object_id];
Attachments
Issue Links
- mentioned in
-
Page Loading...