Bulk copy utility run from the command line to load data into SQL Server and Azure SQL; it is slower than the COPY statement.
Also called bulk copy program.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains BCP in context, with comparison tables and the common traps.
Terms in this definition
- ELT
Extract, load, transform: raw data lands in the target system first and is transformed there. See ETL for the opposite order.
- SQL Server
The relational database from Microsoft that organisations host and run themselves, in their own data centres or on VMs. Its engine also sits underneath the Azure SQL services and SQL database in Fabric.
- Auditing
Azure SQL capability that sends database audit logs to Log Analytics, Event Hubs or a storage account; that account is allowed to be in a different region.
- COPY statement
The quickest and recommended method of loading a Synapse dedicated SQL pool; it doesn't need external tables or file formats.