EPC to EPR Migration

The first step to migrate EPC to EPR is to copy EPC database and all EPC project PDF files to EPR S3 bucket

Step-by-step instructions

1. Export EPC MS SQL database

2. Copy EPC PDF files from the uploads folder to an EPR S3 bucket

   1. Download and install the AWS CLI command line tool : https://docs.aws.amazon.com/cli/latest/userguide/install-windows.html#install-msi-on-windows

   2. create a Windows batch script to perform the S3 upload
      

      @echo off
      
      SET AWS_ACCESS_KEY_ID=<AWS_ACCESS_KEY_ID>
      SET AWS_SECRET_ACCESS_KEY=<AWS_SECRET_ACCESS_KEY>
      SET AWS_DEFAULT_REGION=us-west-2
      
      aws s3 sync ./ s3://BUCKET-NAME/

3. Finally, copy MS SQL backup DB file from step #1 above to S3: aws s3 cp db.bak s://BUCKET-NAME

Related articles