Skip to Content
0
Former Member
Sep 23, 2014 at 06:48 AM

Issue with SQL converter: Query Migration Tool for Microsoft SQL Server to SAP HANA

219 Views

Hello,

I found the following blog : http://scn.sap.com/community/business-one/blog/2013/04/10/how-to-convert-sql-from-ms-sql-server-to-sap-hana

I am trying out this migration tool for converting my MS SQL queries to HANA.

I am running into issue while converting certain queries.

The issue is specific to "set" commands which set local variables inside "create procedure" commands.

e.g.

a standalone set command:

SET @var = (SELECT TOP 1 name FROM mytable ORDER BY name)

is converted well:

SELECT (SELECT TOP 1 "name" FROM "mytable" ORDER BY "name") INTO var FROM DUMMY;


But when the same is part of create procedure:

CREATE PROCEDURE [dbx].[XXXXX_YYYY_ZZZZ]

AS

SET @var = (SELECT TOP 1 name FROM mytable ORDER BY name)

it fails in converting the same:

--Statements in the input file contain errors; conversion was canceled

I would like to understand who can help me here.

Thanks...