Does the SSMA or SQL Server Migration Assistant actually have a custom DECODE function that can be used in SQL Server? I've installed SSMA and can't find that function in the sysdb database. I assumed there was such a function based on a blog posting made by Kevin Kline. If there is a function in SSMA could you give me its name and perhpas an example of how it is used? Now I think he was just saying that the SSMA will convert what you have into CASE statements. Anyway, if you know if there is a decode function in SSMA, please let me know. Thanks.
A brief portion of the prior post comments: SQL Server Migration Assistant (SSMA) 22 AUG 2005 22:28 EDT (02:28, GMT)
The SSMA is a set of tools used to migrate users from other database platforms to SQL Server 2000 and 2005. The SSMA automates almost every aspect of database migration thereby reducing the time, cost and risks of a major migration project.
The most impressive component of SSMA is how they reproduce PL/SQL capabilities within Transact-SQL when none exists. For example, the Oracle DECODE function has no corollary on SQL Server. So rather than force users into a major redesign of their code, the SSMA provides a custom-written user-defined function that completely duplicates the capabilities of Oracle's native commands, functions and system packages. If you know Oracle PL/SQL, you can understand what a massive effort that was!
Software/Hardware used: SQL Server 2005, Oracle 9i