How do I loop exporting multiple tables to flat files (csv) in SQL Server 2017?

Question

I have a SQL database with 4 tables in SSMS 2017.

Currently I am exorting them one by one using Right Click > Tasks > Export data and following the pop-up boxes in SQL Server Import and Export Wizard.

Anyone know if I can write a query to loop the export of all of them to different named files?

What's the names of your tables

CurseStacker
– CurseStacker

2018-09-13 06:22:31 +00:00
Commented Sep 13, 2018 at 6:22 — CurseStacker
– CurseStacker, Commented Sep 13, 2018 at 6:22
dbo.x1; dbo.x2; dbo.x3; dbo.x4

Grant Levang
– Grant Levang

2018-09-13 11:38:56 +00:00
Commented Sep 13, 2018 at 11:38 — Grant Levang
– Grant Levang, Commented Sep 13, 2018 at 11:38

nosqltillcoffee · Accepted Answer · 2018-09-13 08:57:48Z

1

There are numerous way to export data from SQL Server, please see most(if not all) of the options here - http://www.sqlservercentral.com/articles/Export/147145/

I would personally go with automating it true PowerShell, below you can see how to export it for a single table:

Run in PowerShell:

Import-Module SQLPS
$SQLCommand = “SELECT * FROM [AdventureWorks].[Production].[Products]”
Invoke-Sqlcmd -query $SQLCommand | Export-Csv -Path C:\Export.csv -NoTypeInformation

You can of course work to automate it, prepare a list of the tables you need and go with a for each loop true all of them.

answered Sep 13, 2018 at 8:57

nosqltillcoffee

411 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I loop exporting multiple tables to flat files (csv) in SQL Server 2017?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related