-1

How many hours it will take to transfer 500 gb of data from on premise SQL database to AWS S3 using AWS DMS.

I want to use t3 or t4 instances in AWS DMS

KAUSHIK DEY
  • 19
  • 4
  • 1
    There is no t4 instance type for AWS DMS. Also, we can't possibly give you a concrete answer, since much depends on the database schema, and connectivity of the on prem database. – Anon Coward Mar 16 '22 at 14:12

1 Answers1

0

as noted on your previous question, you do not need ec2 for data transfer. Just mount a disk locally with S3 File Gateway service, it will be one of the easiest ways to do it.

Speed will depend on your network connection between you and AWS destination. You can test ping here to get some insight: https://cloudpingtest.com/aws

jarmod
  • 71,565
  • 16
  • 115
  • 122
Lukas Liesis
  • 24,652
  • 10
  • 111
  • 109
  • 1
    Do you mean [S3 File Gateway](https://aws.amazon.com/storagegateway/file/) rather than API Gateway? – jarmod Mar 16 '22 at 11:08
  • Yes, API Gateway is to host REST/Socket APIs and has payload limit of 10Mb. Your single upload "batch" would be limited by 10Mb and you would pay a lot more. You do not need any kind of compute service to transfer data. Don't think about anything like Lambda, Ec2, API Gateway etc. You just need networking & storage. That's it. File Gateway can mount local drive for you directly to drive in cloud or s3 bucket. Then you will pay for network + storage. – Lukas Liesis Mar 16 '22 at 13:51
  • https://aws.amazon.com/storagegateway/pricing/?nc=sn&loc=3 https://aws.amazon.com/s3/pricing/ ingress traffic is free networking, so it won't charge for data upload. Download is paid though, starting at 0.09$/gb for <10Tb/month – Lukas Liesis Mar 16 '22 at 13:55