Source Info

FastBCP offers multiple ways to define your data source for extraction. You can use a query, an input file, or specify schema and table names directly.

Query

Use the -q or --query parameter to specify your extraction as a SELECT statement.

./FastBCP \
...
 --query "SELECT * FROM Sales.Orders WHERE OrderDate >= '2024-01-01'" \
...

Syntax:

• Short form: -q "SELECT_statement"
• Long form: --query "SELECT_statement"

Input File

Use the -F or --fileinput parameter to specify an input file that contains only one query.

./FastBCP \
...
 --fileinput "/sources/sql/queries/my_extraction.sql" \
...

Syntax:

• Short form: -F "file_path"
• Long form: --fileinput "file_path"

Warning

The query in the input file must not end with a semicolon (;).

Source Schema

If no query or input file is used, you can specify the source schema with the -s or --sourceschema parameter. Combined with the source table, this will extract data from sourceschema.sourcetable.

./FastBCP \
...
 --sourceschema "Sales" \
 --sourcetable "Orders" \ 
...

Syntax:

• Short form: -s "schema_name"
• Long form: --sourceschema "schema_name"

Information

This field is mandatory if some parallel method is used. See Advanced Parameters section for more details.

Source Table

If no query or input file is used, you can specify the source table with the -T or --sourcetable parameter. Combined with the source schema, this will extract data from sourceschema.sourcetable.

./FastBCP \ 
...
 --sourceschema "Sales" \
 --sourcetable "Orders" \ 
...

Syntax:

• Short form: -T "table_name"
• Long form: --sourcetable "table_name"

Information

This field is mandatory if some parallel method is used. See Advanced Parameters section for more details.

Warning

if you use the placeholder {sourceschema} and {sourcetable} in the --directory or --fileoutput (See Output Info) then you must set the --sourceschema and the --sourcetable even you use --query or --inputfile