I've been given the job of porting a small Sybase application to a 11.2
instance. The tables are easy enough to sort out, but some aspects of
the Sybase stored code are not clear. Any suggestions for a good online
source that will help me convert it to PL/SQL ?


TIA

Adrian
--
To Reply :
replace "bulleid" with "adrian" - all mail to bulleid is rejected
Sorry for the rigmarole, If I want spam, I'll go to the shops
Every time someone says "I don't believe in trolls", another one dies.

On Tue, 28 Jun 2011 21:24:47 +0100, Adrian wrote:

SQL*Developer can do the trick. It has workshop repositories which can
help with conversion of Sybase and MS-SQL Server databases to Oracle. In
my experience, the tool does a pretty good job.



--
http://mgogala.byethost5.com

On 06/29/2011 02:18 AM, Mladen Gogala wrote:
As an alternative to SQL*Developer: the Oracle Migration Workbench.
Been using that some time ago, so functionality may have been
ported to Developer.
--

Regards,

Frank van Bortel

In message <9a073$4e0b248c$524b97d2$10192 (AT) cache2 (DOT) tilbu1.nb.home.nl>,
Frank van Bortel <fbortel (AT) home (DOT) nl> writes

Thanks.

SQL developer we have, is the migration workbench a freebie (like SQL
Developer), or a paid for option. We are hoping that this is a one off,
so it would be hard justifying expenditure.

I don't have a Sybase DB, only table definitions and the source code in
a file, is this likely to make a difference ?.


Adrian
--
To Reply :
replace "bulleid" with "adrian" - all mail to bulleid is rejected
Sorry for the rigmarole, If I want spam, I'll go to the shops
Every time someone says "I don't believe in trolls", another one dies.

On Wed, 29 Jun 2011 20:52:51 +0100, Adrian wrote:

Not much of a difference. It's approximately the same difference as if
you just had a picture of car, not the car itself. You can't actually
drive it, but you can imagine driving it.
What you need is someone who knows pathologically eclectic rubbish
lister (perl for short) well and knows how to use regular expressions to
fix the codes. You need no workbench, either standalone or from SQL
Developer.



--
http://mgogala.byethost5.com

On Wed, 29 Jun 2011 20:52:51 +0100, Adrian wrote:

It's a freebie, integrated with the Duhveloper.



--
http://mgogala.byethost5.com

In message <pan.2011.07.08.15.45.43 (AT) email (DOT) here.invalid>, Mladen Gogala
<no (AT) email (DOT) here.invalid> writes
Thanks.


Adrian
--
To Reply :
replace "bulleid" with "adrian" - all mail to bulleid is rejected
Sorry for the rigmarole, If I want spam, I'll go to the shops
Every time someone says "I don't believe in trolls", another one dies.