Automating BCP with PowerShell

I was talking with a good friend that has an environment with terabytes of information and to create a homolog or dev environment to him is a pain. He comes to me with a solution : A PowerShell script that gets only the first 1000 lines of each table, creates the inserts and schema files

Export/Import Data using BCP - SQL Server on Linux

In this article you will learn how to use BCP for SQL Server on Linux to export and import data using the BCP command line utility.

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.