BSD Portsdatabases/ora2pg 25.0 FreeBSD
Oracle to PostgreSQL database schema converter
- System
- FreeBSD
- Repository
- FreeBSD ports
- Maintainer
- [email protected]
- License
- GPLv3
- Categories
- databases
- Package size
- 395.4 KiB, 2001.2 KiB installed
Description
Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into your PostgreSQL database. Ora2Pg can be used from reverse engineering Oracle database to huge enterprise database migration or simply to replicate some Oracle data into a PostgreSQL database. It is really easy to used and doesn't need any Oracle database knowledge than providing the parameters needed to connect to the Oracle database.
In the other systems
| System | Port | Version |
|---|---|---|
| FreeBSD | databases/ora2pg | 25.0 |
| DragonFly | databases/ora2pg | 24.3 |
Install
Binary package:
pkg install ora2pgFrom the ports tree:
cd /usr/ports/databases/ora2pg/ && make install cleanTo depend on this port in another port's Makefile:
RUN_DEPENDS= ora2pg>0:databases/ora2pgPackages
The version each package repository carries. “-” means the repository builds no package of it, “n/a” that there is no such repository.
| Repository | aarch64 | amd64 | armv6 | armv7 | i386 |
|---|---|---|---|---|---|
| FreeBSD:14:latest | 25.0 | 25.0 | 23.1 | 25.0 | - |
| FreeBSD:14:quarterly | 25.0 | 25.0 | n/a | 25.0 | - |
| FreeBSD:15:latest | 25.0 | 25.0 | n/a | 25.0 | 25.0 |
| FreeBSD:15:quarterly | 25.0 | 25.0 | n/a | n/a | n/a |
| FreeBSD:16:latest | 25.0 | 25.0 | n/a | n/a | n/a |
| FreeBSD:16:quarterly | n/a | n/a | n/a | n/a | n/a |
Dependencies
As this port's Makefile names them.
Build 3
p5-Class-DBI-Pg>=0: databases/p5-Class-DBI-Pgp5-Class-DBI-mysql>=0: databases/p5-Class-DBI-mysqlp5-Class-DBI-Oracle>=0: databases/p5-Class-DBI-Oracle
Runtime 3
p5-Class-DBI-Pg>=0: databases/p5-Class-DBI-Pgp5-Class-DBI-mysql>=0: databases/p5-Class-DBI-mysqlp5-Class-DBI-Oracle>=0: databases/p5-Class-DBI-Oracle
The full lists below include those, and their dependencies in turn.
Build dependencies 34
- archivers/liblz4
- archivers/zstd
- converters/libiconv
- databases/mysql84-client
- databases/openldap26-client
- databases/p5-Class-DBI
- databases/p5-Class-DBI-Oracle
- databases/p5-Class-DBI-Pg
- databases/p5-Class-DBI-mysql
- databases/p5-DBD-Pg
- databases/p5-DBD-mysql
- databases/p5-DBI
- databases/p5-DBIx-ContextualFetch
- databases/p5-Ima-DBI
- databases/postgresql18-client
- devel/gettext-runtime
- devel/libcbor
- devel/libedit
- devel/libunwind
- devel/p5-Class-Accessor
- devel/p5-Class-Data-Inheritable
- devel/p5-Class-Trigger
- devel/p5-Clone
- devel/p5-IO-Stringy
- devel/p5-UNIVERSAL-moniker
- devel/readline
- lang/perl5.42
- print/indexinfo
- print/libpaper
- print/psutils
- security/cyrus-sasl2
- security/libfido2
- textproc/groff
- textproc/uchardet
Run dependencies 34
- archivers/liblz4
- archivers/zstd
- converters/libiconv
- databases/mysql84-client
- databases/openldap26-client
- databases/p5-Class-DBI
- databases/p5-Class-DBI-Oracle
- databases/p5-Class-DBI-Pg
- databases/p5-Class-DBI-mysql
- databases/p5-DBD-Pg
- databases/p5-DBD-mysql
- databases/p5-DBI
- databases/p5-DBIx-ContextualFetch
- databases/p5-Ima-DBI
- databases/postgresql18-client
- devel/gettext-runtime
- devel/libcbor
- devel/libedit
- devel/libunwind
- devel/p5-Class-Accessor
- devel/p5-Class-Data-Inheritable
- devel/p5-Class-Trigger
- devel/p5-Clone
- devel/p5-IO-Stringy
- devel/p5-UNIVERSAL-moniker
- devel/readline
- lang/perl5.42
- print/indexinfo
- print/libpaper
- print/psutils
- security/cyrus-sasl2
- security/libfido2
- textproc/groff
- textproc/uchardet
No port depends on this one.
Configuration
Options name: databases_ora2pg
| Option | Default | Description |
|---|---|---|
| DOCS | off | Build and/or install documentation |
- USES
- perl5
- Service scripts
- none
Files
pkg-plist 12
- bin/ora2pg
- bin/ora2pg_scanner
- etc/ora2pg/ora2pg.conf.dist
- %%SITE_PERL%%/Ora2Pg.pm
- %%SITE_PERL%%/Ora2Pg/GEOM.pm
- %%SITE_PERL%%/Ora2Pg/MSSQL.pm
- %%SITE_PERL%%/Ora2Pg/MySQL.pm
- %%SITE_PERL%%/Ora2Pg/Oracle.pm
- %%SITE_PERL%%/Ora2Pg/PLSQL.pm
- %%PERL5_MAN3%%/ora2pg.3.gz
- share/doc/ora2pg/README
- share/doc/ora2pg/changelog
distinfo 1
| File | Size | SHA256 |
|---|---|---|
| darold-ora2pg-v25.0_GH0.tar.gz | 590220 | 4f437f8240e5f0b46baf234d86bcf731be30fd6ae2b39ea2c2a8942a25c72a6e |
Commit history 0
No commits in the history this site was built from.