Moving SAP Business One from SQL Server to HANA: what to check first

Many SAP Business One installations start on Microsoft SQL Server and later move to SAP HANA for faster reporting and access to HANA-based features. The standard migration tooling moves the company database reliably. What usually takes the time is everything around it: code, reports and integrations written for SQL Server.

1. Custom queries and stored procedures

Saved queries, formatted searches and the SBO_SP_TransactionNotification procedure are often written in T-SQL. SAP HANA uses its own SQL dialect, so these need to be reviewed and rewritten. Start with an inventory: list every query, formatted search and custom procedure, and mark which ones are still in use.

2. Add-ons

Check with every add-on vendor that the version you use supports SAP Business One on SAP HANA, and plan the upgrade path. In-house add-ons that access the database directly need the same review as custom queries.

3. Print layouts and reports

Crystal Reports layouts and other reports that contain database-specific SQL must be adjusted and tested against HANA. Collect sample documents from the current system so the new output can be compared side by side.

4. Integrations

Interfaces to e-commerce, banking, document management or reporting tools may connect directly to SQL Server. Identify each one and decide whether to move it to the SAP Business One Service Layer or adapt the database connection.

5. Infrastructure and licensing

SAP HANA runs on Linux and needs sizing according to SAP’s guidelines. Decide early whether it will run on premises or in the cloud, for example on Microsoft Azure, and review your licenses with your partner before planning the cutover.

6. Test migration and cutover

Run at least one full test migration on a copy of the production company. Let key users work through their daily processes and month-end tasks, then plan the cutover for a quiet period, with a tested way back.

Planning a migration? Softinent has moved SAP Business One companies to SAP HANA and to Azure. We are happy to review your current setup in a free consultation.