Thursday, March 29, 2012 3:50 PM
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?
Thursday, March 29, 2012 5:17 PM
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.
- Marked As Answer by pdegagne Thursday, March 29, 2012 5:17 PM