Output Formats

Examples demonstrating different output formats supported by FastTransfer.

CSV Format

Standard comma/delimiter-separated values format.

Basic CSV Export

.\\FastTransfer.exe `
  --connectiontype "mssql" `
  --server "localhost" `
  --database "SalesDB" `
  --trusted `
  --sourceschema "dbo" `
  --sourcetable "Sales" `
  --directory "C:\temp" `
  --fileoutput "sales.csv" `
  --decimalseparator "." `
  --delimiter "," `
  --dateformat "yyyy-MM-dd HH:mm:ss" `
  --encoding "UTF-8" `
  --parallelmethod "None"

CSV with Custom Delimiter

Using pipe delimiter for better data separation:

.\\FastTransfer.exe `
  --connectiontype "mssql" `
  --server "localhost" `
  --database "SalesDB" `
  --trusted `
  --sourceschema "dbo" `
  --sourcetable "Sales" `
  --directory "C:\temp" `
  --fileoutput "sales.csv" `
  --decimalseparator "." `
  --delimiter "|" `
  --dateformat "yyyy-MM-dd HH:mm:ss" `
  --encoding "UTF-8" `
  --parallelmethod "Random" `
  --distributekeycolumn "sale_id" `
  --paralleldegree 8 `
  --merge "False"

CSV with European Format

Using comma as decimal separator (common in European countries):

.\\FastTransfer.exe `
  --connectiontype "mssql" `
  --server "localhost" `
  --database "SalesDB" `
  --trusted `
  --sourceschema "dbo" `
  --sourcetable "Sales" `
  --directory "C:\temp" `
  --fileoutput "sales_european.csv" `
  --decimalseparator "," `
  --delimiter ";" `
  --dateformat "dd/MM/yyyy HH:mm:ss" `
  --encoding "UTF-8" `
  --parallelmethod "Random" `
  --distributekeycolumn "sale_id" `
  --paralleldegree 8 `
  --merge "False"

Parquet Format

Columnar storage format optimized for analytical queries.

Basic Parquet Export

.\\FastTransfer.exe `
  --connectiontype "mssql" `
  --server "localhost" `
  --database "SalesDB" `
  --trusted `
  --sourceschema "dbo" `
  --sourcetable "Sales" `
  --directory "C:\temp" `
  --fileoutput "sales.parquet" `
  --parallelmethod "None"

Parallel Parquet Export

Maximize performance with parallel execution:

.\\FastTransfer.exe `
  --connectiontype "mssql" `
  --server "localhost" `
  --database "SalesDB" `
  --trusted `
  --sourceschema "dbo" `
  --sourcetable "Sales" `
  --directory "C:\temp" `
  --fileoutput "sales.parquet" `
  --parallelmethod "RangeId" `
  --distributekeycolumn "sale_id" `
  --paralleldegree 12 `
  --merge "False"

Parquet with PostgreSQL

.\\FastTransfer.exe `
  --connectiontype "pgcopy" `
  --server "localhost" `
  --port "5432" `
  --database "salesdb" `
  --user "postgres" `
  --password "postgres" `
  --sourceschema "public" `
  --sourcetable "sales" `
  --directory "C:\temp" `
  --fileoutput "pg_sales.parquet" `
  --parallelmethod "Ctid" `
  --paralleldegree 10 `
  --merge "False"

Parquet with Oracle

.\\FastTransfer.exe `
  --connectiontype "oraodp" `
  --server "localhost:1521/ORCLPDB1" `
  --user "system" `
  --password "password" `
  --sourceschema "SYSTEM" `
  --sourcetable "SALES" `
  --directory "C:\temp" `
  --fileoutput "oracle_sales.parquet" `
  --parallelmethod "Rowid" `
  --paralleldegree 8 `
  --merge "False"

Excel Format

Export data to Microsoft Excel format (.xlsx).

Excel Format

Excel exports automatically format data for spreadsheet applications. Large datasets may be split across multiple sheets if they exceed Excel's row limits.

Basic Excel Export

.\\FastTransfer.exe `
  --connectiontype "mssql" `
  --server "localhost" `
  --database "SalesDB" `
  --trusted `
  --sourceschema "dbo" `
  --sourcetable "Sales" `
  --directory "C:\temp" `
  --fileoutput "sales.xlsx" `
  --parallelmethod "None"

Parallel Excel Export

.\\FastTransfer.exe `
  --connectiontype "mssql" `
  --server "localhost" `
  --database "SalesDB" `
  --trusted `
  --sourceschema "dbo" `
  --sourcetable "Sales" `
  --directory "C:\temp" `
  --fileoutput "sales.xlsx" `
  --parallelmethod "RangeId" `
  --distributekeycolumn "sale_id" `
  --paralleldegree 6 `
  --merge "False"

Excel with Custom Query

Export filtered data to Excel:

.\\FastTransfer.exe `
  --connectiontype "mssql" `
  --server "localhost" `
  --database "SalesDB" `
  --trusted `
  --query "SELECT * FROM dbo.Sales WHERE sale_date >= '2024-01-01' AND sale_date < '2025-01-01'" `
  --directory "C:\temp" `
  --fileoutput "sales_2024.xlsx" `
  --parallelmethod "Ntile" `
  --distributekeycolumn "sale_id" `
  --paralleldegree 4 `
  --merge "False"

tip

Build your command with the Wizard