February 11, 2019 at 12:34 am
Hi All,
We are working on few projects to migrate Sybase ASE DB schema to MSSQL 2014 using SSMA and while conversion below errors were noticed.
I don't see any issues while executing the scripts and SP's from Sybase.
1. @@TRANSTATE - global variable cannot be converted.
2. compare(VARCHAR, VARCHAR) - Not able to convert the identifier.
3. 'get_appcontext(VARCHAR, VARCHAR)' identifier was not converted.
4. Select statement with unresolved identifiers and GROUP BY cannot be converted ( example get_pledged_collateral_shorts – Line 114 ).
We are thinking to write our own TSQL to fix fix this. However, in-build conversions should be helpful.
Is it possible to convert above into SQL 2014?
Thanks in advance!
Regards,
Austin
February 12, 2019 at 8:48 am
Insufficient detail. Please be a lot more detailed in your description of EXACTLY what you are trying to do. You can't just assume that everyone here knows what you are trying to do. Be anally detailed. Don't leave anything out.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply