Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Migration of embedded SQL's in PowerBuilder appn

807887Oct 25 2010 — edited Oct 28 2010

Hi all,

Well I am relatively new to PowerBuilder and we are trying to establish a PoC on migrating a large Powerbuilder Application with a Sybase database to an Oracle Database. Specifically, I am looking for more info on the migration of the embedded SQL's within the PB codes.

Is there an established methodology for the same?

Currenlt , I am accomplishing the same by extracting the PBL codes into .srd and .srw files and then running tools to convert the embedded SQL's in them. Could anyone elaborate on the presence/absence of embedded SQL's in these file types? And regarding the migration, does Oracle provide any assistance?

Or are there any open source tools to accomplish the same???

Looking forward to some asssistance from the OTn community!

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 25 2010

Added on Oct 25 2010

#database-and-application-migrations, #migration, #oracle, #sql, #sql-developer

12 comments

348 views