DATABASE EXPORT for HANA

By | 01/11/2018

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.

STEP 1:

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
./sapinst
This will launch Installation Window

DATABASE EXPORT for HANA

STEP 2:

Now we need to choose the existing component of our SAP system.
Select component
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

DATABASE EXPORT for HANA

STEP 3:

Now we need to specify the profile path.

In our current scenario we are using windows, hence we will provide path as
\\sapexport\sapmnt\<SID>\SYS\profile

For UNIX/Linux etc. operating system we need to provide profile path as:
/usr/sap/<SID>/SYS/profile

DATABASE EXPORT for HANA

STEP 4:

Now we need to specify SAP System Administrator Password
Tips: Have a standard administrative password for your project, so there will be less chance of forgetting it.
Press the Next button.

DATABASE EXPORT for HANA

STEP 5:

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 the Next button.

DATABASE EXPORT for HANA

STEP 6:

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 the Next button.

DATABASE EXPORT for HANA

STEP 7

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 the execution of report SMGR_CREATE_DLL report.
But we will select “No, skip the export and runs the export without SQL files”
Press the Next button.

DATABASE EXPORT for HANA

STEP 8:

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”

DATABASE EXPORT for HANA

STEP 9:

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.

DATABASE EXPORT for HANA

STEP 10:

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 uses 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.

DATABASE EXPORT for HANA

STEP 11

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 the Next button.

DATABASE EXPORT for HANA

STEP 12:

Enter the general export parameters. Then click NEXT.
Under the General Unload Settings tab, we have Big-Endian and Little-Endian.

Big 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.

Little Endian:

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.

The number of Parallel Jobs:

Parallel job expedites the Export process and helps in completing faster.
Check the total number of work process and totally available for the export task. Accordingly set the parallel job.
Example If you have 5 available work process, then use 3 for export.

DATABASE EXPORT for HANA

STEP 13:

Now we need to choose a custom Package to 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 the next button.
We use Time Analyzer Result if export has already completed.

DATABASE EXPORT for HANA

STEP 14:

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.

DATABASE EXPORT for HANA

STEP 15:

In this screen, we will get a 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.

DATABASE EXPORT for HANA

STEP 16:

Now we have reached to the Execution phase.
Export Process Running and multiple tasks like database installation, export ABAP, run r3szchk etc. will be completed.

STEP 17:

Once all the tasks get completed without any error we will get “Export Process Successfully Completed” screen.
Click on to close the window.

DATABASE EXPORT for HANA

If you have any queries related to above export of HANA database please let us know via your valuable comments.

Related Content:

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.