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

XMLWordPrintable

      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];
      

            Assignee:
            Wendy H
            Reporter:
            Rodrigo Martinez
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: