SQL TO HANA MIGRATION

SQL TO HANA MIGRATION

METHODOLOGY

MIGRATE SAP BUSINESS ONE FROM SQL SERVER TO SAP HANA

In general, we recommend adopting the latest version for SAP Business One, version for SAP HANA. Nevertheless, it is up to the customer whether they go for the SAP Business One, version for SAP HANA in terms of the project budget, the readiness of business processes for the new functions and Add-On(s) migration etc. The migration path differs from patch level to patch level.

·         Identify the migration path and landscape architecture given the current and target versions of the customer’s SAP Business One system.

Example:
The customer is using SAP Business One 9.2 PL07 (SQL), planning to migrate to the SAP Business One 9.3, version for SAP HANA, PL04.

SAP Business One 9.2 PL07 (SQL) -> SAP Business One 9.3, version for SAP HANA, PL03

Step 1: Install HANA Rev 122.16


Step 2: Install SAP Business One 9.3, version for SAP HANA, PL04.


Step 3: Run the migration wizard to migrate and upgrade the database from SAP Business One 9.2 PL 07 (SQL) to SAP Business One 9.3, version for SAP HANA, PL04

·         Hardware configuration and Install SuSE Linux Enterprise Server

·         Install SAP HANA, and SAP Business One, version for SAP HANA

·         Request and install the license key for SAP HANA and SAP BUSINESS One, version for SAP HANA

·         Upgrade the source SAP Business One system (SQL Server version) to the relevant version which can be migrated as the migration path

·         Migrate SAP Business One Databases from SQL Server to SAP HANA

·         Upgrade the company schema to the target patch level

·         Initialize the company schema for the analytical features with the Administration Console of SAP Business One analytics.

·         Migrate customization related to SQL queries in SAP Business One

·         Create reusable models or extend Semantic Layer for analytics scenario

·         Migrate Analytics

·         Migrate Add-Ons