Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-80121

Update the Create a staging environment for upgrading Confluence article to include Triggers

    XMLWordPrintable

Details

    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    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:

      1. Back up your production database. Refer to the documentation for your database for more info on the best way to do this. 
      2. 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

          Activity

            People

              7a3726b618b3 Wendy H
              rmartinez3@atlassian.com Rodrigo Martinez
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: