Database export to HANA
This article explains step by step method to Perform the DATABASE EXPORT for HANA via SWPM. We have our SAP system on ERP 6.0 EHP 7 and OS is MS SQL Server.
We need to download SWPM.
Go inside the folder, right click sapinst.exe and run as administrator
For UNIX system, we need to uncar the SWPM files using SAPCAR and run by command
This will launch Installation Window
Now we need to choose the existing component of our SAP system.
Business Suite 7i 2013 Support Release 2 –> EHP7 for ERP 6.0 ABAP Support Release 2 –> MS SQL SERVER –> System Copy –> Source System –> Based on AS ABAP towards SAP HANA DB
Then Click NEXT
Now we need to specify the profile path.
In our current scenerio we are using windows, hence we will provide path as
For UNIX/Linux etc. operating system we need to provide profile path as:
Now we need to specify SAP System Administrator Password
Tips: Have standard administrative password for your project, so there will be less chance of forgetting it.
Press Next button.
Now we need to specify Existing Database SID. By default it will be reflected.
If it doesn’t then choose from the dropdown list.
Press Next button.
In this screen we need to enter the “Export Location”. Enter the directory for the EXPORT Location.
Here we have browsed and chosen F:EXPORT
We also want to manually Stop our SAP system. Thus, we need to check “Manual Stop System” checkbox.
Once done, press Next button.
We need to run SMIGR_CREATE_DLL report to generate SQL files for a correct database on the target system.
In this screen we will be asked to execution of report SMGR_CREATE_DLL report.
But we will select “No,skip the export and runs the export without SQL files”
Press Next button.
Now we need to mention Source System and Target System information.
All the source system information will be automatically fetched as shown in below screen.
We need to specify the Target System Database Type as “SAP HANA Database”
In this screen we have an option to select “SAP System Extended Export Options”
As we are performing 1st time this export hence we will select “New export from scratch” and then Click NEXT
New export from scratch created a complete new export by running R3ldctl, R3szchk and other files.
R3szchk has two option to determine the size of the source database system.
The option “Use data dictionary information” uses the data types from the SAP data dictionary to calculate the size.
This is the standard option.
Another option is to use “Use database specific information”. It basically use database statistics and for most database platforms. It has lesser runtime as compared to Use data dictionary information
We will select “Use data dictionary information(R3szchk parameter-s DD)”. Then Click NEXT.
In this step we are going to split larger tables. So we need to enter the parameter for the java splitting tool.
Check the “Largest Tables in Separate Packages” button and enter the number of tables to be extracted.
Similarly provide input to other values mentioned below.
Once all fields are filled, press Next button.
Enter the general export parameters. Then click NEXT.
Under the General Unload Settings tab, we have Big-Endian and Little-Endian.
The most significant byte is stored in memory at the lowest address, and the least significant byte at the highest address. (The big end comes first.) As an analogy, we say “twenty-four” in English; the more significant number, twenty, comes first.
This is also called most significant byte (MSB) ordering.
The least significant byte of the number is stored in memory at the lowest address, and the most significant byte at the highest address. (The little end comes first.) As an analogy, we say “fourteen” in English; the less significant number, four, comes first.
This is also called least significant byte (LSB) ordering.
Every information you required related to Big Endian and Little Endian is stored on SAP Note 552464.
Number of Parallel Jobs:
Parallel job expedite the Export process and helps in completing faster.
Check the total number of work process and total available for export task. Accordingly set the parallel job.
Example If you have 5 available work process, then use 3 for export.
Now we need to choose custom Package unload order. We can choose by size, time analyzer or by name.
For unload order by size, the files created during R3srchk execution will be used.
Choose the unload order you want to use. By default option is Size. Select size and then click next button.
We use Time Analyzer Result if export has already completed.
After selecting custom package order by size, we have two groups during the export. “Group Large” contains packages sorted from the biggest downward whereas “Group Small” contains packages sorted from smallest upwards. Enter the parameter for the Custom order. Then Click NEXT.
In this screen we will get summary of all the parameters we had selected so far in previous screens. We need to cross-verify all the parameter listed there in the Parameter summary. Once verified then Click NEXT.
Now we have reached to Execution phase.
Export Process Running and multiple tasks like database installation, export ABAP, run r3szchk etc. will be completed.
Once all the tasks get completed without any error we will get “Export Process Successfully Completed” screen.
Click on to close the window.
If you have any queries related to above export of HANA database please let us know via your valuable comments.