Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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

      Code Block
      @echo off
      
      SET AWS_ACCESS_KEY_ID=GET ID FROM E-PLAN
      <AWS_ACCESS_KEY_ID>
      SET AWS_SECRET_ACCESS_KEY=GET KEY FROM E-PLAN
      <AWS_SECRET_ACCESS_KEY>
      SET AWS_DEFAULT_REGION=us-west-2
      
      aws s3 cpsync 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

...