Home » RDBMS Server » Server Utilities » Migration from oracle to SQL
Migration from oracle to SQL [message #72130] Mon, 17 March 2003 01:51 Go to next message
Ramya Sundaresan
Messages: 1
Registered: March 2003
Junior Member
Can any of you tell me how to migrate the stored procedures written in oracle to MS SQL Server 2000

Report message to a moderator

Re: Migration from oracle to SQL [message #72137 is a reply to message #72130] Tue, 18 March 2003 22:07 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

> Migrate stored procedures from Oracle to MSSQL

Stored procedures in Oracle are written in PL/SQL. The equivalent in SQL Server is called T-SQL (Transact-SQL). PL/SQL and T-SQL are quite different.
I'm not aware of a tool that can convert from PL/SQL to T-SQL, it is probably too difficult and a straight translation is not possible.

Best regards.

Frank

Report message to a moderator

Previous Topic: exp in client
Next Topic: UTL_SMTP package and subject line of email
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 13:52:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.