====== How to Migrate the SAP HANA Schema ======

<WRAP center round info 100%>
  * The following documentation is for Produmex WMS version 19.2 and later. If you use a previous version, click [[http://wiki.produmex.name/lib/exe/fetch.php?media=implementation:wms:olddoc:how_to_guide_v19.1.pdf|here]].
  * The next steps have been tested on HANA 1.00.112.03 and 1.00.122.05.
</WRAP>

There are some extra steps to perform in order to migrate a company database from MSSQL to HANA, when Produmex WMS is also running on that database.

1. Before executing the SAP migration tool, run the following query on the MSSQL database:    <code sql>ALTER TABLE PMX_ADDON ADD CONSTRAINT PK_PMX_ADDON PRIMARY KEY CLUSTERED (DbUserName)</code>

2. Install the correct HANA client version.

3. Run the SAP migration tool (migration.exe) from the SAP Patch Level installer.

4. If necessary, upgrade the company patch level on the target HANA server.

5. Log in once to the company using the SAP Business One client, set SAP license.

6. Install the Produmex Tools from ProdumexSuiteInstaller (HANA version)

7. Run the Produmex Hana Migration Tool, which you can find in the Produmex Tools folder. (c:\Program Files\Produmex\Produmex Tools\) \\ It does the following: \\
  * Removes the primary key on PMX_ADDON that was created at step 1. \\
  * Creates all SQL sequences for auto-incremented columns. \\

8. Restart the HANA database server, so it reinitializes the sequences.

9. Run the Produmex Tools Config and upgrade the database (ProdumexSuiteIsntaller).

10. Modify the SBO_SP_TRANSACTIONNOTIFICATION procedure.

  * [[implementation:wms:install_standardstoredprocedure|3.4.1. Enable the standard PMX stored procedure]] Topic: 3.4.1.2. With SAP HANA