Azure DWH part 16: BCP to import and export data

In Azure SQL Data Warehouse we can use BCP to export or import the data. In this article, we will show how to do it.

Export table to file with bcp chunk

Export table to file with bcp chunk

Solving a Problem Importing Integers Using Format Files

When using format files to import data into SQL Server, the Integer(INT) data type needs special handling.

Bulk Loading Data

My favorite way to access Excel files

Using opendatasource to retrieve data from Excel files as if querying a table.

Bulk Copy All?Table Data into formatted files

Bulk copy table data into formatted files.

Binary Files Import and Export

Importing binary files is always a challenge in SQL Server. New Author Sergey Benner brings us a technique using bulk loading that has worked well for him.