CODEWITHSUNDEEP
sqloracle-databasesybase
Harish Malavade
Harish Malavade

Reputation: 71

Migrating Sybase queries to Oracle Sql : oracle sql Developer

I have a query written in sybase which gets executed, Anybody knows if there is a easy way to convert this query into Oracle Sql or do we need to manually wrtite this query.

I understand that DML/DDL/procs/views can be migrated using SQL developer.

Any help is much appreciated

Upvotes: 1

Views: 1155

Answers (1)

thatjeffsmith
thatjeffsmith

Reputation: 22427

Yes. We have a T-SQL translator, built right into the SQL Developer UI.

enter image description here

I talk about it here.

If you use the Migration Project to do your translation, when your Sybase object names change, because of size or reserved word limitations in Oracle, the project will know to propagate those name changes throughout your stored procs, views, etc.

This translator is provided for ad-hoc stuff, but it works very well for what it does.

Upvotes: 1

Related Questions