How to migrate settings and master data from SAP Business One on SQL to SAP Business One on HANA

[former_member354011]

Hi,

Tell me please how can I migrate settings (UDF, document numberig etc) and master data (projects, Sales Employee etc) from SAP Business One DB on SQL (9.2, pl08) to SAP Business One DB on HANA.

Thanks a lot!

[Vaibhav_Kaushik · Accepted solution]

Hi,

I have recently migrated my SQL db (the entire DB, not just the settings as mentioned by you) and it was not that difficult. I had followed these steps and faced no issue:

1. Install SQL on the windows application server

2. Restore the SBO COMMON database on the windows application server

3. Restore the actual database which you want to migrate (should be atleast 1 patch level lower, Example: SAP HANA is on PL 08 then the database which is being migrated has to be lower than PL 08)

4. Go to the setup folder of SAP Business One and execute as admin the migrate setup.

5. Follow the steps and provide the credentials of the source and destination to migrate the database

6. Upgrade the newly migrated DB to the same PL as in you HANA invironment

Hope this is useful

Regards

[former_member186605]

Dear Oleg,

have you checked the "SAP Business One Administrator's Guide, version for SAP HANA", esp. section 8, Migrating from Microsoft SQL Server to SAP HANA? All these questions should be answered there.

Best, Peter

[former_member354011]

Thanks a lot, Peter!