Showing posts with label movement. Show all posts
Showing posts with label movement. Show all posts

Monday, December 2, 2013

Moving and migrating data from on premise to AWS using Attunity CloudBeam

Here is some interesting information regarding using a solution like Attunity CloudBeam to move and migrate Oracle databases from on premise to AWS:

Monday, February 11, 2013

Oracle DB data transfer to AWS


A typical Oracle database is 1 TB or more in size. This will mean that a T3 line or higher speed line will be needed to move this much data. Otherwise, the AWS import export service can be used. The information below is from the http://aws.amazon.com/importexport/ web page but repeated here for easy of finding.

Connection           Theoretical 80% Utilization    AWS Imp/Exp
T1 (1.544Mb)        82 days                                    100GB or more
10Mbps                  13 days                                    600GB or more
T3 (44.736Mbps)    3 days                                      2TB or more
100Mbps               1 to 2 days                                 5TB or more
1000Mbps             Less than 1 day                         60TB or more

Elapsed time is going to depend on many factors: speed of connection, compression used (if any), can load be done in parallel etc. The fastest load times will happen using AWS import/export (http://aws.amazon.com/importexport/ ). The next fastest will be using AWS Direct Connect (http://aws.amazon.com/directconnect). 

Direct Connect provides speeds of 1 Gbps to 10 Gbps. Using a 1 Gbps line, it would take about 3-4 hours (here is a good site: http://fasterdata.es.net/fasterdata-home/requirements-and-expectations/).