Transfer Oracle to Citus Data
Fast, streaming database-to-database transfer with parallel processing
Terminal
.\FastTransfer.exe `
--sourceconnectiontype "oraodp" `
--sourceserver "your-source-server" `
--sourceuser "your-username" `
--sourcepassword "your-password" `
--sourcedatabase "your-source-db" `
--query "SELECT * FROM your_schema.your_table" `
--targetconnectiontype "pgcopy" `
--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 - Oracle Database
Oracle Database is the world's most widely used enterprise database. FastTransfer leverages the ODP.NET driver for maximum performance during Oracle transfers.
Features:
- •Native Oracle ODP.NET driver
- •Full support for Oracle-specific types
- •Optimized for large volumes
Parallel Method - Ntile
Divides data into N equal partitions based on a numeric column.
Requirement: Requires a numeric distribution column
Available parallel methods with Oracle:
Destination - Citus Data
FastTransfer uses PostgreSQL's binary COPY protocol for Citus with a PostgreSQL Compatible Source if you use pgcopy both in source and target connection types.
Loading method:
Binary COPY Protocol (Distributed)
Advantages:
- •Binary COPY for maximum performance (Pg Compatible Source Only + pgcopy/pgcopy)
- •Automatic distribution across shards
- •Optimized for distributed tables
