Migrating SAP Business One Databases from SQL Server to SAP HANA
Updated on Apr 28 2018:
This document guides you how to Migrate SAP Business One Databases from SQL Server to SAP HANA, which is step 5 of Cookbook of migrating SAP Business One from SQL Server to SAP HANA
You should follow the section Migrating Company Databases from the Microsoft SQL Server Database to the SAP HANA Database in the “SAP Business One Administrator’s Guide, version for SAP HANA“.
As of SAP Business One 9.1 PL05, version for SAP HANA, you can run the new migration wizard to migrate databases from the Microsoft SQL Server to the SAP HANA database, as well as upgrade the databases on SAP HANA. You can migrate and upgrade the company schema with the migration wizard.
This database migration tool is applicable only for the SAP Business One company database. Precisely speaking, it only covers the system tables and User Defined Tables/Fields of SAP Business One. Any other external database or direct SQL table in SAP Business One database is considered as out of scope
This step migrates only the data format of the database from SQL Server to SAP HANA, no data content itself. Migration of SQL query related customization and upgrade of table structure will be discussed in later steps
With regards to how long the database migration may take, the key factors are listed below:
- The size of the SAP Business One company database
- The specification of the SQL Server machine
- The specification of the machine where the migration tool is to be run, and memory allocated to the migration tool and the number of threads for migration.
- The specification of SAP HANA
The 2nd and 3rd factors are usually the most critical ones affecting the whole migration time length, this is because the migration tool pulls a large amount of data from SQL Server and writes to SAP HANA.
Database Size: 20 G
Hardware Specification of SQL Server Machine: 16 G RAM
Hardware Specification of Workstation for Migration: 8 G RAM, 2.0 GHZ of 1 CPU with 4 COREs. (A different workstation from the SQL Server machine.)
-Allocated Memory for Migration: 4 G
-Number of Threads for Migration: 10
Hardware Specification of SAP HANA Server: 64 G RAM
The database migration takes around 30~60 minutes.
Another sample from SAP tests: it only takes around 3 hours to migrate a company database with 100 G data from SQL Server to SAP HANA.
- You are highly recommended to run the migration tool on another workstation instead of on the SQL Server machine, because both the migration tool and the SQL Server require considerable computing resources and conflict with each other during migration.
- The migration should be performed while B1 users are offline.
- Run the migration tool on a physical machine rather than a virtual one.
- The SQL Server machine, the SAP HANA server and the workstation running the migration tool should be located in the same LAN due to the large amount of exchange within the network.
- You should perform a system backup of SAP HANA after a successful migration so that you have a snapshot of the system at each stage
Please see the migration section in SAP Note 1969397 – Troubleshooting Guide for SAP Business One, version for SAP HANA