Convert Oracle code to Microsoft SQL code
I've been given an Oracle DB that has some triggers and "LOAD DATA" jobs. Is there a tool/utility to convert the triggers/loads from PL/SQL into T-SQL?
Software/Hardware used:
Software/Hardware used:
ASKED:
March 30, 2009 9:20 PM
UPDATED:
June 23, 2011 7:07 AM
Answer Wiki:
Have a look at the <a href="http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx">SQL Server Migration Assistant (SSMA) for Oracle</a>. It might help you.
To see all answers submitted to the Answer Wiki: View Answer History.
SELECT DISTINCT MBM.MBM_MBR_ID,MBM.MBM_MBR_NAME,B.MPH_STS,B.MPH_STRT_TIME
FROM PROD.MBR_MST MBM,PROD.MBR_PRVLGE_HSTRY B
WHERE
MBM.MBM_MBR_ID NOT LIKE ‘CCRBIDMD%’AND
MBM.MBM_MBR_ID=B.MPH_MBP_MBM_MBR_ID
–AND MBM.MBM_MBR_ID=’CCBPGTBK0022′
and B.MPH_MBP_BSNS_SGMNT=’FRX’
AND B.MPH_MBP_BSNS_SUB_SGMNT=’USDINR’
AND
–MAX(B.MPH_STRT_TIME)
(NVL(B.MPH_STRT_TIME,’01-JAN-2000′),mbm.MBM_MBR_NAME)
IN
(
SELECT
NVL(MAX(B.MPH_STRT_TIME),’01-JAN-2000′),MBM.MBM_MBR_NAME
FROM PROD.MBR_MST MBM,PROD.MBR_PRVLGE_HSTRY B
WHERE
MBM.MBM_MBR_ID NOT LIKE ‘CCRBIDMD%’AND
MBM.MBM_MBR_ID=B.MPH_MBP_MBM_MBR_ID
AND B.MPH_MBP_BSNS_SGMNT=’FRX’
AND B.MPH_MBP_BSNS_SUB_SGMNT=’USDINR’
–AND MBM.MBM_MBR_ID=’CCBPGTBK0022′
AND
B.MPH_STRT_DATE<=’31-OCT-2010′
GROUP BY mbm.MBM_MBR_NAME)
–GROUP BY MBM.MBM_MBR_NAME,B.MPH_STS,MBM.MBM_MBR_ID
ORDER BY MBM.MBM_MBR_NAME