SYBASE Emulated Functions - can not find

Question

Hi everyone,

As I understood from the official migration guide, after migration there should be emulated Sybase functions (UDF), which I do not see anywhere. Below is one example of the SSMA emulated function replacement, as per the SSMASybase documents. I have also found documents referencing s2ss.ssma_"functionname"....

"In most cases you can migrate the SUBSTRING function as is. The result of SQL Server SUBSTRING functions is different if start < 0, or if the function produces an empty string. To provide compatibility, SSMA can emulate it by using a UDF, which is chosen depending on the parameter data type. SSMA has an appropriate conversion option.

If expression is of NCHAR or NVARCHAR data type, convert to:

SYSDB.SSMA_SYB.SUBSTRING_NVARCHAR(expression, start, length)

Otherwise convert to:

SYSDB.SSMA_SYB.SUBSTRING_VARCHAR(expression, start, length)"

But my converted db doesn't have any such objects. Is there something I am missing or not doing correctly?

Answer 1

Figured this out on my own also, sure wish they had better instructions. The issue here was that it creates a schema for 's2ss', which contains the deploy of the required emulated functions. You must synchronize for that schema in order to deploy to required databases. Previously, I only cared about 'dbo', so I wasn't trying to deploy any other objects under other schemas.