Transfer Citus Data to Oracle
Fast, streaming database-to-database transfer with parallel processing
Terminal
.\FastTransfer.exe `
--sourceconnectiontype "pgcopy" `
--sourceserver "your-source-server" `
--sourceuser "your-username" `
--sourcepassword "your-password" `
--sourcedatabase "your-source-db" `
--query "SELECT * FROM your_schema.your_table" `
--targetconnectiontype "orabulk" `
--targetserver "your-target-server" `
--targetuser "your-username" `
--targetpassword "your-password" `
--targetdatabase "your-target-db" `
--targetschema "your_table" `
--targettable "your_table" `
--parallelmethod "Ntile" `
--distributekeycolumn "id" `
--degree 10 `
--loadmode "Truncate"Source - Citus Data
Citus is a PostgreSQL extension that transforms PostgreSQL into a distributed database. FastTransfer uses the PostgreSQL protocol for seamless integration.
Features:
- •PostgreSQL wire protocol compatibility
- •Distributed query optimization
- •Support for sharded tables
Parallel Method - Ntile
Divides data into N equal partitions based on a numeric column.
Requirement: Requires a numeric distribution column
Available parallel methods with Citus Data:
Destination - Oracle Database
FastTransfer supports Oracle Direct Path Load and Conventional Path Load. Direct Path offers the best performance by bypassing the buffer cache.
Loading method:
Direct Path / Conventional Path Load
Advantages:
- •Direct Path Load for maximum performance
- •Conventional Path Load for compatibility
- •Native ODP.NET support
