Start a project

SQL to HANA query converter for SAP Business One

Paste a SQL Server query. Get the HANA version with every column quoted, every function translated and every change explained.

SQL Server
SAP HANA
 
 
 
 
Changes made 0
     
    Check manually 0
       
       
      Complex procedure or a whole add-on? Send it to us and we convert and test it on HANA.Get a quote →
       
         
       
        
       
       
      How it works
      Three steps, no signup
       
       
      1
      Paste your SQL Server query
      Any SAP Business One query from Query Manager, a Crystal report command or a formatted search.
      2
      Get the HANA version
      Brackets, functions, dates, text joins and column quoting are converted in your browser, in milliseconds.
      3
      Read the change log
      Every rule that fired is listed, and anything that needs a human (temp tables, variables) is flagged.
       
       
       
       
       
       
      FAQ
      Questions about this tool
       
       
      Is this SQL to HANA converter really free?
      Yes. It runs completely in your browser, needs no signup and your query is never sent to a server.
      Why does HANA need "double quotes" around SAP B1 column names?
      SAP HANA converts unquoted names to UPPERCASE. SAP Business One columns are mixed case (CardCode, DocTotal), so they must be written as T0."CardCode" or HANA will report an invalid column name.
      Which SQL Server functions are converted?
      ISNULL, LEN, GETDATE, DATEADD, DATEDIFF, DATEPART, DATENAME, CONVERT with date styles, CHARINDEX, IIF, EOMONTH, CEILING, NEWID, REPLICATE, SPACE, STR and FORMAT, plus + string joins, [brackets], dbo. prefixes, NOLOCK hints and single-quoted aliases.
      Does it convert stored procedures and temp tables?
      No. Procedures, #temp tables, cursors and DECLARE variables have to be rewritten in SQLScript. The converter flags them so you know exactly what is left. We can do that work for you.
      Will the [%0] parameters still work in SAP B1 Query Manager?
      Yes. B1 parameters like [%0] and '[%0]' are kept exactly as written, and they work the same way on HANA.
       
       
       
       
       
       
      More free tools
      Built for SAP Business One teams
       
       SAP B1 query libraryReady-made reports for sales, finance, stock and approvals, in SQL and HANA.SAP B1 table finderSearch any table: what it stores, its line tables and its key fields.ZATCA QR code decoderRead a Saudi e-invoice QR (TLV Base64) or generate a Phase 1 QR from invoice values.SRI clave de accesoValidate or generate the 49-digit access key of Ecuador electronic invoices. 
       
       
       
       
       
      Moving SAP B1 from SQL Server to HANA?
       
      We convert queries, Crystal reports, stored procedures and add-ons, and test them on your HANA database. Fixed price, usually quoted within 24 hours.
       
       Start a project  Chat on WhatsApp