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=GET ID FROM E-PLAN
      SET AWS_SECRET_ACCESS_KEY=GET KEY FROM E-PLAN
      SET AWS_DEFAULT_REGION=us-west-2
      
      aws s3 cp uploads s3://BUCKET-NAME/ --recursive 

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

Related articles