Comments (4)
Theoretically this could be achieved easily but technically every type of SQL or PL/SQL code processing is separated from others using the export type. This mean that if you want to convert pl/sql code you have to use the FUNCTION, PROCEDURE or PACKAGE export type individually with the corresponding file.
For example, let's say you have a file with several Oracle functions inside, using ora2pg as follow:
ora2pg -p -t FUNCTION -i the_oracle_file.sql -o the_postgresql_file.sql
will do the code conversion. This is the same for PL/SQL packages body, just use -t PACKAGE instead.
Since release 10.0 SQL queries can also be converted by the ora2pg SQL code rewritter with the following command:
ora2pg -p -t QUERY -i the_oracle_file.sql -o the_postgresql_file.sql
This will only apply to SELECT, UPDATE, DELETE and INSERT SQL commands.
So using one file per type of SQL code it is already possible, but I understand the need. Can you send me a sample file ? It will help me to have a random file to parse instead of my own well formatted file and not very useful for others :-)
from ora2pg.
We would need a new export type, mixing function, procedure, package and queries contained in a single SQL file. Would that make sense ?
I will send you a sample file privately, as I cannot share it widely.
from ora2pg.
Yes that the goal of the feature: being able to convert anything from an input file using a new export type.
Of course by "send to me" I wanted to say privately.
from ora2pg.
This item can be closed for me, the feature is now included into Ora2Pg. The only thing is that export must be done separately using the different export type, the all-in-one export in a single output file is not possible with the actual design of Ora2Pg.
from ora2pg.
Related Issues (20)
- Migrating From SQL Server to Postgres with Ora2pg Is very Slow HOT 1
- Request for sha256sum on downloads HOT 1
- Config option to override the NLS_TIMESTAMP_FORMAT or such encoding parameters used by Ora2pg HOT 1
- Invalid check constraint conversion to PostgreSQL format while exporting schema from Oracle HOT 1
- OUT OF MEMORY EVEN THOUGH SERVER HAS OVER 16GB FREE RAM HOT 2
- [ORACLE]Slow export of BLOB and CLOB from HOT 7
- Reading the ora2pg assessment report HOT 6
- Mysql to postgresql migration HOT 9
- ERROR : DBI::db=HASH(0x29c1784f2e8)->disconnect invalidates 1 active statement handle HOT 3
- Wrong argument "extra_param OPAQUE" in function with OUT arguments (regression in release 24.3) HOT 1
- Wrong change in translation of "is not null" clause (regression in release 24.3) HOT 1
- Extract data query errorring out HOT 6
- Oracle column aliases (after TRIM function) are syntactically incorrect due to small bug introduced in commit 66f4fc37 HOT 1
- Issue in migrating from SQL Server to CloudSQL Postgres HOT 4
- Foreign server always generated with default port HOT 3
- Export data with CLOB is too slow HOT 7
- Generated export_schema.ps1 contains bash if else HOT 1
- Problems trying to use new parameter PARTITION_BY_REFERENCE=duplicate
- Oracle to Postgresql migration - issue with SECURITY DEFINER
- Filenames created incorrectly when exporting using the COPY option and parameter RENAME_PARTITION=1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from ora2pg.