How to migrate B1UP Configurations from MSSQL to HANA

This article explains the things you need to be aware of if you will migrate an SAP database with B1 Usability Package to SAP HANA.

Q: What do I need to do in terms of the B1UP Configurations? 
A: Basically you need to find every place you have written SQL Sentences in our system and convert it from MSSQL T-SQL to HANA SQL. Here is a list of places you need to look for SQL:

• B1 Dashboards (the SQL inside)
• B1 Search Customizations
• B1 Validation SQL conditions
• Item Placement Tool - Valid Values SQL
• Letter Merge - Mass Delivery Templates
• Master Data Manager - Templates
• Right Click Menu Creator Conditions
• Toolbox - Automated Numbers
• UF - External Launcher - SQL: usages
• UF - Message - SQL: usages
• UF - SQL Report SQL
• UF - Content Creator - SQL: usages
• UF - Macro - SQL Usage
• UF - Line Loop SQL
• UF - Dynamic Code - SQL In your code
• UF - File Exporter - SQL
• UF - File Importer - SQL In your code
• UF - Internal Message - SQL Used in fields
• UF - Create Activity - SQL Used in fields
• UF - Batch Configurations
• Crystal Reports

Q: Do Boyum offer a tool to auto-convert this SQL:
A: No, that is not possible as some SQL in MSSQL can't be converted (some SQL need to be written in different ways in HANA). We do however have an MSSQL to HANA Converter that can help in some cases as part of the B1UP Solution