Versions Compared

Key

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

...

  1. Export EPC MS SQL database put it into the <EPC>/uploads folder

  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=<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-NAMErun the batch script to start copying files over