Re: Migrate SQL Server Stored Procedures

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Lloyd Sheen (sqlguyremoveallofthis_at_tostopspamhotmail.com)
Date: 06/17/04 

Date: Thu, 17 Jun 2004 14:37:17 GMT

There is no quick method to migrate procedures to and from SQL Server to
Oracle. SQL Server uses Transact-SQL as a language and Oracle uses PL/SQL.
Those two languages are as different as english and chineese.

There are many constructs in Oracle including packages that SQL Server would
never understand. Many stored procedures in SQL Server are just select
statements that have been compiled to store the access plan. Oracle must
return a cursor as a parameter to get the same functionallity so your VB
program would have to access the information in a different manner.

What you are asking is not easy. If all you are doing is returning
information then it would be better (not more efficient) to use standard
ANSI selects to do your database access.

Lloyd Sheen

"usman" <usman@isf.com.pk> wrote in message
news:e6H26CHVEHA.2520@TK2MSFTNGP12.phx.gbl...
> Dear Sir,
>
> How can I migrate all SQL server Stored Procedures to Oracle adn Oracle
> to SQL Server? I want to code in VB 6.0 or VB.Net Please tell me Can I
> move all stored procedures using DTS if yes then How can ?
>
> Thanks very much,
>
> usman
>
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: What is Oracles version of MS SQL Profiler
    ... Tracking code path of a stored procedure (find out what is being ... I'm new to Oracle coming in from Sql Server. ... what I use to debug stored procedures and track performance. ...
    (comp.databases.oracle.server)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)
  • Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
    ... "Writers block readers and readers block writers in SQLServer. ... getting around this fundamental issue and because of it SQL Server ... admitted they can happen in Oracle, I guess Oracle should never been used ... isolation level but you will always disagree because you follow doctorine ...
    (comp.databases.oracle.server)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... If it was the update statement that references ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... There are however differences how both products deal with concurrency; in Oracle readers don't get blocked while this may happen in SQL Server. ...
    (comp.databases.oracle.misc)
  • Re: Import problems on Windows Server
    ... XP is fine, so is Vista, like you I use them day in day out, around 12 hours ... a day myself too - laptops and the desktop i'm writing this on. ... I use SQL Server on XP and Vista for writing and demo'ing stuff, ... those are the same problems in the Oracle world. ...
    (comp.databases.oracle.server)