Transfer ODBC to CedarDB

Fast, streaming database-to-database transfer with parallel processing

FastTransfer

Streaming Engine

Terminal

.\FastTransfer.exe `
  --sourceconnectiontype "odbc" `
  --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"

All Parameters Wizard

Get FastTransfer

Source - ODBC

ODBC (Open Database Connectivity) allows connection to virtually any database. FastTransfer supports ODBC connections for maximum compatibility.

Features:

•Compatible with any database supporting ODBC
•Maximum flexibility
•Standard ODBC driver support

Parallel Method - Ntile

Divides data into N equal partitions based on a numeric column.

Requirement: Requires a numeric distribution column

Available parallel methods with ODBC:

Destination - CedarDB

FastTransfer uses PostgreSQL's binary COPY protocol for CedarDB with a PostgreSQL Compatible Source if you use pgcopy both in source and target connection types, ensuring maximum compatibility and performance.

Loading method:

Binary COPY Protocol

Advantages:

•Binary COPY for maximum performance (Pg Compatible Source Only + pgcopy/pgcopy)
•PostgreSQL protocol compatibility
•Optimized for modern hardware

Related Pipelines