While the above is only the 2nd fastest migration speed that I have achieved, it still felt good to obtain these impressive numbers from a Windows 2003 & SQL 2005 source databases during my recent 46C to EHP7 Combined Upgrade and Unicode Conversion (CUUC). Yes, source databases as in plural, because I did the export from two copies of the source database to speed up the export rate to a short 6.8hr duration for a 7.14TB size database.
The implementation concept to achieve the above was to copy the production database, at the right time after Unicode preparation steps are done, to a 2nd database server through storage cloning and stand up a VM with the SQL server database with exactly same disk drives as the source. This will lead to a scenario where you will have two copies of the production database in a state where either one can be exported. Let us identify them as source1 and source2. Use the distribution monitor tool to export half the packages from source1 and the remaining half from source2. Of course, one has to choose the packages to be exported from the two sources based on more intelligent criteria than blindly picking half and half. However, for the sake of discussion let us stick to that for the time being. Hence, since you are exporting only half the packages from each database server, you can theoretically cut down the export duration by half. I have implemented this idea on two projects with impressive results. The figure below illustrates this scenario:
Nice blog. Not many folks venture to do export from multiple source databases. This blog is showing that idea works with good results, written concisely in two pages. Very useful, if you have large database to migrate!
Leveraging middleware software for integration between SAP and AWS means additional administrative effort (installation, patching and upgrade) as well as runtime costs (software license). In order to address this, AWS introduced a managed service that eliminates the administrative effort and runtime costs to integrate SAP and AWS. AppFlow provides a no-code and serverless option to extract SAP Data, as well as write this data back to SAP..
 2e380cc55c