Migration from Sybase SAP SQL Anywhere to SQL Server 2022

  • We are working on a project to migrate a client from a version of SAP Sql Anywhere (Sybase) to SQL Server 2022.

    However, we have encountered a challenge.

    The current application calls stored procedures and passes parameters, e.g.

    CALL TheStoredProc @a, @b-2+@c, @d

    However, to my knowledge, SQL cannot receive parameters that contain mathematical operators.

    Does anyone know how we can get this working (we are not allowed to change the vendor's application).


    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • If that is the syntax that the app will use, and you cannot change it, won't it fail anyway, because of the 'CALL'?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • you will need to speak with vendor - and see if the application is already prepared to work with SQL Server  instead of Sybase. It may well be just a case of installing a different version of the application or maybe changing configurations (or a reinstall with SQL Server as the target db)

  • This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply