experdb / Experdb Db2pg
Licence: other
eXperDB-DB2PG is a data migration solution that transfers data extracted from various DBMSs to eXperDB or PostgreSQL. Currently, Oracle and Oracle Spatial, MySQL, SQL Server(MS-SQL) and Sybase data can be transferred.
Stars: ✭ 24
Programming Languages
java
68154 projects - #9 most used programming language
Projects that are alternatives of or similar to Experdb Db2pg
Linq2db
Linq to database provider.
Stars: ✭ 2,211 (+9112.5%)
Mutual labels: oracle, mysql, postgresql, mssql, db2
Csv2db
The CSV to database command line loader
Stars: ✭ 102 (+325%)
Mutual labels: oracle, mysql, postgresql, db2
Soci
Official repository of the SOCI - The C++ Database Access Library
Stars: ✭ 960 (+3900%)
Mutual labels: oracle, mysql, postgresql, db2
Dbshield
Database firewall written in Go
Stars: ✭ 620 (+2483.33%)
Mutual labels: oracle, mysql, postgresql, db2
Eosio sql plugin
EOSIO sql database plugin
Stars: ✭ 21 (-12.5%)
Mutual labels: oracle, mysql, postgresql, db2
Directus
Open-Source Data Platform 🐰 — Directus wraps any SQL database with a real-time GraphQL+REST API and an intuitive app for non-technical users.
Stars: ✭ 13,190 (+54858.33%)
Mutual labels: oracle, mysql, postgresql, mssql
Jooq
jOOQ is the best way to write SQL in Java
Stars: ✭ 4,695 (+19462.5%)
Mutual labels: oracle, mysql, postgresql, db2
Rom Sql
SQL support for rom-rb
Stars: ✭ 169 (+604.17%)
Mutual labels: oracle, mysql, postgresql, mssql
Fluentmigrator
Fluent migrations framework for .NET
Stars: ✭ 2,636 (+10883.33%)
Mutual labels: oracle, migration, mysql, db2
E Commerce Db
Database schema for e-commerce (webstores) sites.
Stars: ✭ 245 (+920.83%)
Mutual labels: oracle, mysql, postgresql, db2
Dbeaver
Free universal database tool and SQL client
Stars: ✭ 23,752 (+98866.67%)
Mutual labels: oracle, mysql, postgresql, db2
Pgloader
Migrate to PostgreSQL in a single command!
Stars: ✭ 3,754 (+15541.67%)
Mutual labels: migration, mysql, postgresql, mssql
Symmetric Ds
SymmetricDS is a database and file synchronization solution that is platform-independent, web-enabled, and database agnostic. SymmetricDS was built to make data replication across two to tens of thousands of databases and file systems fast, easy and resilient. We specialize in near real time, bi-directional data replication across large node networks over the WAN or LAN.
Stars: ✭ 450 (+1775%)
Mutual labels: oracle, mysql, postgresql, db2
Evolve
Database migration tool for .NET and .NET Core projects. Inspired by Flyway.
Stars: ✭ 477 (+1887.5%)
Mutual labels: migration, mysql, postgresql
Pointblank
Data validation and organization of metadata for data frames and database tables
Stars: ✭ 480 (+1900%)
Mutual labels: mysql, postgresql, mssql
Phpmyfaq
phpMyFAQ - Open Source FAQ web application for PHP and MySQL, PostgreSQL and other databases
Stars: ✭ 494 (+1958.33%)
Mutual labels: mysql, postgresql, mssql
Vscode Sqltools
Database management for VSCode
Stars: ✭ 741 (+2987.5%)
Mutual labels: mysql, postgresql, mssql
eXperDB-DB2PG: Data Migration tool for PostgreSQL
Introduction
eXperDB-DB2PG is a data migration solution that transfers data from various source DBMSs to eXperDB or PostgreSQL. It works on JAVA basis, so there is no restriction on platforms such as Unix, Linux and Windows, and installation is not necessary and can be used easily.
Features
- Export full data or using WHERE clause.
- Export Oracle Spatial data to PostGIS.
- Export Oracle CLOB, BLOB object to PostgreSQL BYTEA.
- Support for any platform such as Linux and Windows.
- Faster than PostgreSQL COPY function.
- Removing FK and INDEX before performing data import operation(Rebuild after termination).
- Data export using select query is supported.
- Selective extraction through exclusion table.
- Support for Oracle, Oracle Spatial, SQL Server, Sybase, DB2, Mysql, Sybase, Altibase, Cubrid.
TODO
- Export DDL from DB2, Sybase, Cubrid to PostgreSQL DDL.
License
Execution
1. System Requirements
- OS : Developed and tested on Linux and Windows, but work on any UNIX-like system and Windows System
- JDK : JDK 1.8 or later
- Storage : With the SAM(Sequential Access Method) file, you need to enough free space to store the original data when transferring data.
- From : Oracle(Including Oracle Spatial), SQL Server, MySQL, Sybase
- To : eXperDB, PostgreSQL
2. Options
| Option | Description | Mandatory |
|---|---|---|
-c, --config <arg>
|
Configuration file load for executing DB2PG command. (In the current version(1.1.2), the environment setting is not input as a parameter) | Y |
| -M, --make-templates | Create a configuration file to run the DB2PG command | N |
--rebuild-summary <arg>
|
Summarizes constraint execution logs such as PK, FK, INDEX created and deleted in Target Database. (Create a file using '>' or '>>') | N |
--unload-summary <arg>
|
Summarize the logs loaded on the target using the Import.sql script generated from the Source Database. (Create a file using '>' or '>>') | N |
3. Examples(On Linux)
| Command | E.g. use |
|---|---|
| Help | ./db2pg.sh |
| Execute | ./db2pg.sh -c db2pg.config |
| Create Import Log file | psql -U db2pg -d db2pg -p 5432 -h 127.0.0.1 -f import.sql > import.log |
| Import Log Summary | ./db2pg.sh --unload-summary ./db2pg-result/import.log |
| Create Rebuild log file | psql -U db2pg -d db2pg -p 5432 -h 127.0.0.1 -f fk_drop.sql > rebuild.log |
| psql -U db2pg -d db2pg -p 5432 -h 127.0.0.1 -f idx_drop.sql >> rebuild.log | |
| psql -U db2pg -d db2pg -p 5432 -h 127.0.0.1 -f idx_create.sql >> rebuild.log | |
| psql -U db2pg -d db2pg -p 5432 -h 127.0.0.1 -f fk_create.sql >> rebuild.log | |
| Rebuild Log Summary | bash db2pg.sh --rebuild-summary ./db2pg-result/rebuild/rebuild.log |
Copyright
Copyright (c) 2016-2019, eXperDB Development Team All rights reserved.
Community
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].