Using Regular expression to convert PL/SQL code to TSQL

Question

Using Regular expression to convert PL/SQL code to TSQL

venus.pvr

SSCarpal Tunnel

Points: 4813
More actions
October 10, 2011 at 11:52 pm

#260257

Comments posted to this topic are about the item Using Regular expression to convert PL/SQL code to TSQL

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Carlo Romagnano SSC-Insane Points: 22760 More actions · Answer 1

venus.pvr (10/10/2011)
Comments posted to this topic are about the item <A HREF="/articles/Regular+Expressions/75121/">Using Regular expression to convert PL/SQL code to TSQL</A>

Thanks! I found it very interesting for Regular expression syntax.

venus.pvr SSCarpal Tunnel Points: 4813 More actions · Answer 2

Thank you Carlo. I also thank Steve Jones for the support.

chrisfradenburg SSCrazy Eights Points: 9592 More actions · Answer 3

We have an application we're going to look at migrating from Oracle to MSSQL so I'm going to file this article away to help with changing the code. Thanks for writing it.

SQLRNNR SSC Guru Points: 281344 More actions · Answer 4

I find that this could prove very helpful. Microsoft has a tool available to help convert too - name and location of the download escape me right now though. Maybe somebody else can remember what it is called.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

chrisfradenburg SSCrazy Eights Points: 9592 More actions · Answer 5

SQLRNNR (10/11/2011)
I find that this could prove very helpful. Microsoft has a tool available to help convert too - name and location of the download escape me right now though. Maybe somebody else can remember what it is called.

This is probably what you're talking about:

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26711

And a page with some more info and a link to a whitepaper:

http://www.microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx