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'?


  • 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)

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

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