Document Management SystemProject Type: software

Document Management System

Uploaded image for project: 'Document Management System'
  1. Document Management System
  2. DMS-1518

SQL script to copy global templates from Pre Prod to Production

    Details

    • Type: Maintenance
    • Status: Code Review
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: CBAT Offer Letter - Fall
    • Labels:
      None

      Description

      SQL script to copy global templates from Pre prod to PRoduction

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          samir Samir created issue -
          samir Samir made changes -
          Field Original Value New Value
          Summary SQL script to copy global templates from Pre prod to PRoduction SQL script to copy global templates from Pre prod to Production
          samir Samir made changes -
          Summary SQL script to copy global templates from Pre prod to Production SQL script to copy global templates from Pre Prod to Production
          samir Samir made changes -
          Epic Link DMS-480 [ 75973 ]
          samir Samir made changes -
          Fix Version/s CBAT Offer Letter - Fall [ 10607 ]
          Sprint DMS - Fall Sprint 6 [ 165 ]
          samir Samir made changes -
          Remaining Estimate 8h [ 28800 ]
          Original Estimate 8h [ 28800 ]
          Hide
          Permalink
          samir Samir added a comment -
          • Global template to be copied with sql script. Template ID to be given as parameter
          • Files to be managed manually (Folder Copy)

          Ganesh Sadawarte

          Show
          samir Samir added a comment - Global template to be copied with sql script. Template ID to be given as parameter Files to be managed manually (Folder Copy) Ganesh Sadawarte
          samir Samir made changes -
          Assignee Samir [ samir ] Rushikesh Dattatray Bane [ rushikesh.bane ]
          samir Samir made changes -
          Assignee Rushikesh Dattatray Bane [ rushikesh.bane ] Ramya Tantry [ ramya.tantry ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status To Do [ 10000 ] In Progress [ 3 ]
          samir Samir made changes -
          Sprint DMS - Fall Sprint 6 [ 165 ] DMS - Fall Sprint 5 [ 164 ]
          Permalink
          ramya.tantry Ramya Tantry (Inactive) logged work - 20/Jun/19 05:47 AM
          • Time Spent:
            2.5h
             

            Discussion with Rushikesh and Rohan

            Script creation

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 8h [ 28800 ] 5.5h [ 19800 ]
          Time Spent 2.5h [ 9000 ]
          Worklog Id 184295 [ 184295 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Remaining Estimate 5.5h [ 19800 ] 5h 10m [ 18600 ]
          Time Spent 2.5h [ 9000 ] 2h 50m [ 10200 ]
          Worklog Id 184309 [ 184309 ]
          Permalink
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 20/Jun/19 05:25 PM
          • Time Spent:
            20m
             
            • Created Super Admin User on Pre-production.
          Hide
          Permalink
          ramya.tantry Ramya Tantry (Inactive) added a comment - - edited

          Tasks Done: 

          1. Creation of Script with Template ID as parameter. This template ID is of Pre-prod's document template.
          2. Migrated data of tables documenttemplate, documenttemplatefields, documenttemplatefieldmappings, documenttemplatefieldsrights of pre-prod to Prod
          3. Unit testing on local server.

          NOTE: Template Files will be copied manually. 

          As discussed with Samir, when data is to be moved from Pre-prod to prod, Pre-prod db will be attached to prod db server.

          This will be executed as and when required basis. Hence it will be checked into Other folder of Database Objects

          Files Affected:

          DMS/Databases Objects/07_Other/DMS_SP_CopyGlobalTemplates.sql

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - - edited Tasks Done:   Creation of Script with Template ID as parameter. This template ID is of Pre-prod's document template. Migrated data of tables documenttemplate, documenttemplatefields, documenttemplatefieldmappings, documenttemplatefieldsrights of pre-prod to Prod Unit testing on local server. NOTE : Template Files will be copied manually.  As discussed with Samir, when data is to be moved from Pre-prod to prod, Pre-prod db will be attached to prod db server. This will be executed as and when required basis. Hence it will be checked into Other folder of Database Objects Files Affected: DMS/Databases Objects/07_Other/DMS_SP_CopyGlobalTemplates.sql
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status In Progress [ 3 ] Code Review [ 11801 ]
          Permalink
          ramya.tantry Ramya Tantry (Inactive) logged work - 21/Jun/19 02:39 AM
          • Time Spent:
            4h
             

            Unit testing

            Script creation

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Harshveer Singh [ harshveer.singh ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 5h 10m [ 18600 ] 1h 10m [ 4200 ]
          Time Spent 2h 50m [ 10200 ] 6h 50m [ 24600 ]
          Worklog Id 184519 [ 184519 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Fall Sprint 5 [ 164 ] DMS - Fall Sprint 5, DMS - Fall Sprint 6 [ 164, 165 ]
          samir Samir made changes -
          Assignee Harshveer Singh [ harshveer.singh ] Samir [ samir ]
          Hide
          Permalink
          samir Samir added a comment -

          Production Super Admin id : 145

          Show
          samir Samir added a comment - Production Super Admin id : 145
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Attachment DMS_SP_CopyGlobalTemplates.sql [ 111116 ]
          Hide
          Permalink
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Steps: 

          1. This SP should be available on Production DB.
          2. Pre-prod db should be attached to Prod db server.
          3. Identify Pre-prod's Template Id's to be copied.
          4. Supply Pre-prod's document template ID as parameter  to attached SP. DMS_SP_CopyGlobalTemplates.sql
            Eg : CALL `dms_master`.`DMS_SP_CopyGlobalTemplates`(355);
          5. Template Files will be copied manually. 
          6. Verify migrated Data on Production db.

           

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Steps:   This SP should be available on Production DB. Pre-prod db should be attached to Prod db server. Identify Pre-prod's Template Id's to be copied. Supply Pre-prod's document template ID as parameter  to attached SP.  DMS_SP_CopyGlobalTemplates.sql Eg : CALL `dms_master`.`DMS_SP_CopyGlobalTemplates`(355); Template Files will be copied manually.  Verify migrated Data on Production db.  
          Permalink
          ramya.tantry Ramya Tantry (Inactive) logged work - 24/Jun/19 05:43 AM
          • Time Spent:
            0.5h
             

            Discussion with Samir and Steps updation

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 1h 10m [ 4200 ] 40m [ 2400 ]
          Time Spent 6h 50m [ 24600 ] 7h 20m [ 26400 ]
          Worklog Id 184838 [ 184838 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Fall Sprint 5, DMS - Fall Sprint 6 [ 164, 165 ] DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7 [ 164, 165, 166 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7 [ 164, 165, 166 ] DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8 [ 164, 165, 166, 167 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8 [ 164, 165, 166, 167 ] DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1 [ 164, 165, 166, 167, 173 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1 [ 164, 165, 166, 167, 173 ] DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2 [ 164, 165, 166, 167, 173, 174 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2 [ 164, 165, 166, 167, 173, 174 ] DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2, DMS - Gap Fall & Win Sprint 3 [ 164, 165, 166, 167, 173, 174, 177 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2, DMS - Gap Fall & Win Sprint 3 [ 164, 165, 166, 167, 173, 174, 177 ] DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2, DMS - Gap Fall & Win Sprint 3, DMS - Gap Fall & Win Sprint 4 [ 164, 165, 166, 167, 173, 174, 177, 179 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2, DMS - Gap Fall & Win Sprint 3, DMS - Gap Fall & Win Sprint 4 [ 164, 165, 166, 167, 173, 174, 177, 179 ] DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2, DMS - Gap Fall & Win Sprint 3, DMS - Gap Fall & Win Sprint 4, DMS - Gap Fall & Win Sprint 5 [ 164, 165, 166, 167, 173, 174, 177, 179, 181 ]
          Transition Time In Source Status Execution Times
          Ramya Tantry (Inactive) made transition -
          To Do In Progress
          		1d 19m 1
          Ramya Tantry (Inactive) made transition -
          In Progress Code Review
          		1d 5h 6m 1

            People

            Assignee:
            samir Samir
            Reporter:
            samir Samir
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Time Tracking

                Estimated:
                Original Estimate - 8h
                8h
                Remaining:
                Time Spent - 7h 20m Remaining Estimate - 40m
                40m
                Logged:
                Time Spent - 7h 20m Remaining Estimate - 40m
                7h 20m