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.
2020-01-30
7,218 reads
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.
2020-01-30
7,218 reads
You have many options when exporting data from a database. In this article, Phil Factor compares several methods including XML and array-in-array JSON for speed and file size.
2019-01-17
3,509 reads
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.
2017-09-26
1,716 reads
This tip will show eight ways to export the results of a query to a text file.
2017-10-06 (first published: 2016-10-26)
332,638 reads
Using the power of SSIS and BCP to import MySQL Data and extract files from a BLOB(Varbinary) column.
2016-07-11
4,093 reads
2016-06-02 (first published: 2016-05-10)
828 reads
This script was designed to help make importing data from any SQL2008+ database to an APS much easier.
2015-08-12 (first published: 2015-07-14)
971 reads
When using format files to import data into SQL Server, the Integer(INT) data type needs special handling.
2012-02-16
4,689 reads
One CLR function and four CLR procedures for the import/export of JSON data to and from SQL Server are presented, with supporting performance metrics.
2011-07-18
15,595 reads
Getting errors and output messages when using xp_cmdshell can be tricky. This method can solve your problems.
2010-02-02
10,298 reads
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers