Oracle DECODE and SSMA

5 pts.
Tags:
DECODE
Oracle 9i
Oracle migration
SQL Server 2005
SSMA for Oracle
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
ASKED: August 4, 2010  6:49 PM
UPDATED: August 4, 2010  8:39 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

I don’t think such a function exists.

The <a href=”http://download.microsoft.com/download/e/c/8/ec8d5025-7ef7-4dcc-a9f3-9c297cf5350e/SSMAOracle.docx”>Guide to Migrating from Oracle to SQL Server 2005</a> specifies that the Oracle’s DECODE function is converted using standard T-SQL mapping (using a CASE-WHEN construct).

That is also the case when migrating to SQL Server 2008.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following