It generates sentences to export all database tables to a .csv file as this:
USE AdventureWorks
SELECT 'bcp ' + '"SELECT * FROM ' +
QUOTENAME(DB_NAME())
+ '.'
+QUOTENAME(SCHEMA_NAME(schema_id))
+ '.'
+QUOTENAME(name)
+ '"'+' queryout'+' '
+ 'c:\' + name + '.csv -c -t, -T -S '
+ @@servername
FROM sys.objects
WHERE TYPE='u'
AND is_ms_shipped=0 
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)
451,388 reads
The XportXML utility, will help you copy relational data (a bunch of related tables) to another SQL Server keeping the relational integrity intact, even when new primary keys are generated.
2009-07-08 (first published: 2009-06-22)
1,548 reads
With the combination of a few T-SQL commands this tip shows you a simple way to export data to text files.
2008-12-05
9,878 reads
The following tutorial will show how to export JSON data to a CSV file using SSIS
2016-11-15
5,069 reads
Many people want to create a customized migration process using SQL Server Integration Services (SSIS), but it is hard to start working with heterogeneous databases like MySQL, Postgres, DB2, etc. Check out this tip to learn about how to import data from heterogeneous databases like MySQL to SQL Server.
2012-04-20
3,717 reads