• Global template to be copied with sql script. Template ID to be given as parameter
• Files to be managed manually (Folder Copy)

Ganesh Sadawarte

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

Production Super Admin id : 145

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.