Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit2e2d17e

Browse files
committed
Here the latest version and first working release of Ora2Pg a tool to export
Oracle database to PostgreSQL. It currently dump the database schema (tables, views, sequences, indexes, grants), with primary, unique and foreign keys into PostgreSQL syntax without editing the SQL code generated. You can dump only a particular schema from the Oracle database. Functions, procedures and triggers with SQL or PLSQL code generated must be reviewed to match the PostgreSQL syntax. Some usefull recommandation on porting Oracle to PostgreSQL can be found athttp://techdocs.postgresql.org/ under the "Converting from other Databases to PostgreSQL" Oracle part. Ijust notice one thing more is that the trunc() function in Oracle is the same fornumber or date so be carefull when porting to PostgreSQL to use trunc() for numberand date_trunc() for date.I will add more precision in type NUMBER conversion based on length to matchas closest as possible all rich PostgreSQL numerics type. But it seems not to beurgent as it seems that Oracle DBAs only create number with length 22 (default)Space seems not to be their problem...Gilles DAROLD
1 parenta0c12d5 commit2e2d17e

File tree

6 files changed

+1293
-494
lines changed

6 files changed

+1293
-494
lines changed

‎contrib/oracle/CHANGES

Lines changed: 11 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@
44
- Add table grant extraction based on group. Oracle ROLES are groups in PG
55

66
2001 05 11 - Version 1.2
7-
- Views extraction is now really done with the option type=>'VIEWS'
7+
- Views extraction is now really done with the option type=>'VIEW'
88
- Add indexes extraction on tables.
99
- Changes name of constraints, default is now used.
1010
- Add debug printing to see that the process is running :-)
@@ -15,3 +15,13 @@
1515
- Complete rewrite of the grant extraction
1616
- Complete rewrite of most things
1717

18+
2001 06 20 - Version 1.3
19+
- Grant/privilege extraction are now done separatly with the option type=>'GRANT'
20+
- Sequence extraction with the option type=>'SEQUENCE'
21+
- Trigger extraction with the option type=>'TRIGGER'
22+
- Function extraction with the option type=>'FUNCTION' and type=>'PROCEDURE'
23+
- Complete rewrite of the foreign key extraction
24+
- Fix incorrect type translation and many other bug fix
25+
- Add schema only extraction by option schema => 'MYSCHEM'
26+
27+

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp