How to save data from all tables in SQL Server database into CSV files (using PowerShell)

  • Posted on: 23 September 2015
  • By: Michał Turecki

All it takes is to create the following PowerShell script (text file with .ps1 extension) and changing $server and $db variables to match the server's host and instance name (SERVER\INSTANCE) and a database name.

$destDir = Get-Location
$server = "localhost"
$db = "DatabaseToExport"

Import-Module -Name SQLPS
$tables = Invoke-Sqlcmd -query "SELECT name FROM sys.tables" -Database "$db" -ServerInstance "$server"
foreach ($table in $tables)
{
	$tableName = $table["name"]
	write-host -ForegroundColor Green "Creating File $tableName.csv"
	Invoke-Sqlcmd -Query "SELECT * FROM $tableName;" -Database "$db" -Server "$server" |
		Export-Csv -NoTypeInformation -Path "$destDir\$tableName.csv" -Encoding UTF8
}
Tags: 
powershell
sql-server
database
csv

Comments

Randcer (not verified)

Sat, 27/07/2019 - 19:21

Cialis Prezzo Ufficiale Acheter Cialis Sur Ordonnance

Randcer (not verified)

Sat, 27/07/2019 - 19:06

Cialis Prezzo Ufficiale Acheter Cialis Sur Ordonnance

LesKern (not verified)

Fri, 26/07/2019 - 18:26

buy now isotretinoin - isotretinoin cash delivery Vente Cialis 5 Mg viagra Autorizza Il Kamagra Г€ In Francia Viagra E Utilizzo Propecia Long Term Effects

LesKern (not verified)

Fri, 26/07/2019 - 18:24

buy now isotretinoin - isotretinoin cash delivery Vente Cialis 5 Mg viagra Autorizza Il Kamagra Г€ In Francia Viagra E Utilizzo Propecia Long Term Effects

LesKern (not verified)

Fri, 26/07/2019 - 18:19

buy now isotretinoin - isotretinoin cash delivery Vente Cialis 5 Mg viagra Autorizza Il Kamagra Г€ In Francia Viagra E Utilizzo Propecia Long Term Effects

LesKern (not verified)

Fri, 26/07/2019 - 18:12

buy now isotretinoin - isotretinoin cash delivery Vente Cialis 5 Mg viagra Autorizza Il Kamagra Г€ In Francia Viagra E Utilizzo Propecia Long Term Effects

Ellarem (not verified)

Wed, 24/07/2019 - 07:12

Canadian Pharmacies Top Best Cialis Generic Forum cheapest cialis Comprar Cialis Generico Sin Receta Kamagra Gelatina 100mg

Ellarem (not verified)

Wed, 24/07/2019 - 06:43

Canadian Pharmacies Top Best Cialis Generic Forum cheapest cialis Comprar Cialis Generico Sin Receta Kamagra Gelatina 100mg

RebImparf (not verified)

Thu, 18/07/2019 - 18:59

Amlodipine Besylate Levitra Se Puede Comprar Sin Receta Viagra Costo A Confezione cialis prices L'Ejaculation Rapide Viagra Achat Net Achat Slimex 15 Mg

Ellarem (not verified)

Mon, 15/07/2019 - 04:45

Best Canadian Pills cialis without prescription Achat Cialis Canada Compra Viagra Generico

Ellarem (not verified)

Mon, 15/07/2019 - 04:33

Best Canadian Pills cialis without prescription Achat Cialis Canada Compra Viagra Generico

LesKern (not verified)

Mon, 15/07/2019 - 03:25

Propecia Finasteride Cost Cilais And Priligy generic viagra Fish Amoxicillin Sales Viagra Products Online

RebImparf (not verified)

Sat, 06/07/2019 - 10:49

Is 25mg Viagra Enough Comment Acheter Cytotec Sans Ordonnance Great Online Pharmacy viagra Cialis Cost Per Pill Buy Wellbutrin Without A Perscrition Levitra Horsturz

RebImparf (not verified)

Sat, 06/07/2019 - 10:45

Is 25mg Viagra Enough Comment Acheter Cytotec Sans Ordonnance Great Online Pharmacy viagra Cialis Cost Per Pill Buy Wellbutrin Without A Perscrition Levitra Horsturz

RebImparf (not verified)

Sat, 06/07/2019 - 10:42

Is 25mg Viagra Enough Comment Acheter Cytotec Sans Ordonnance Great Online Pharmacy viagra Cialis Cost Per Pill Buy Wellbutrin Without A Perscrition Levitra Horsturz

Ellarem (not verified)

Fri, 05/07/2019 - 15:40

Vendo Cialis Generico Madrid horaires levitra Acheter Du Cialis Propecia Kvinder Generic Propecia Successful

Ellarem (not verified)

Fri, 05/07/2019 - 15:36

Vendo Cialis Generico Madrid horaires levitra Acheter Du Cialis Propecia Kvinder Generic Propecia Successful

Ellarem (not verified)

Fri, 05/07/2019 - 15:31

Vendo Cialis Generico Madrid horaires levitra Acheter Du Cialis Propecia Kvinder Generic Propecia Successful

LesKern (not verified)

Mon, 01/07/2019 - 18:17

Orlistat Effets Secondaires cheapest cialis 20mg Propecia Shop Levitra Paypal Accepted Cialis Es Mejor Que El Viagra

RebImparf (not verified)

Mon, 24/06/2019 - 17:17

Atenolol And Amoxicillin Cheap Xenical Online Australia Levitra Espanol order cialis online Diabetes Y Kamagra

Randcer (not verified)

Mon, 24/06/2019 - 11:58

Pharmacy Clomid Ne Marche Pas п»їcialis Can You Buy Orlistat

Ellarem (not verified)

Sun, 23/06/2019 - 10:49

Kamagra Viagra Erfahrungsberichte viagra online Doxycycline Monohydrate Canada Mail Order Fluoxetine

Ellarem (not verified)

Sun, 23/06/2019 - 10:31

Kamagra Viagra Erfahrungsberichte viagra online Doxycycline Monohydrate Canada Mail Order Fluoxetine

LesKern (not verified)

Mon, 17/06/2019 - 18:21

What Bacteria Does Amoxicillin Kill acheter cialis 20mg en pharmacie Buy Aldara Cream India Buy Clomiphene And Gonadotropins

LesKern (not verified)

Mon, 17/06/2019 - 18:16

What Bacteria Does Amoxicillin Kill acheter cialis 20mg en pharmacie Buy Aldara Cream India Buy Clomiphene And Gonadotropins

LesKern (not verified)

Mon, 17/06/2019 - 18:10

What Bacteria Does Amoxicillin Kill acheter cialis 20mg en pharmacie Buy Aldara Cream India Buy Clomiphene And Gonadotropins

LesKern (not verified)

Mon, 17/06/2019 - 18:03

What Bacteria Does Amoxicillin Kill acheter cialis 20mg en pharmacie Buy Aldara Cream India Buy Clomiphene And Gonadotropins

Ellarem (not verified)

Sat, 15/06/2019 - 05:40

Canadian Pills Buy Propranolol 40mg Keflex Pregnant generic cialis canada Buying Viagra In Canada Foro Kamagra Paypal

Ellarem (not verified)

Sat, 15/06/2019 - 05:25

Canadian Pills Buy Propranolol 40mg Keflex Pregnant generic cialis canada Buying Viagra In Canada Foro Kamagra Paypal

RebImparf (not verified)

Thu, 13/06/2019 - 12:00

Buying Prednisolone Uk Cephalexin Breast Feeding Prix Kamagra Avec Ordonnance generic cialis overnight delivery Discount Doryx Cialis 20 Mg Diabete

Randcer (not verified)

Wed, 12/06/2019 - 02:19

Le Cialis Efficace Ou Acheter Cialis Serieux Predisone Without Prescription viagra Cialis Ricetta Rossa Baclofene Arret Cigarette

Randcer (not verified)

Wed, 12/06/2019 - 02:17

Le Cialis Efficace Ou Acheter Cialis Serieux Predisone Without Prescription viagra Cialis Ricetta Rossa Baclofene Arret Cigarette

Ellarem (not verified)

Thu, 06/06/2019 - 19:08

Tadalis Sx En France En Ligne viagra Avis Achat Viagra Ligne

Ellarem (not verified)

Thu, 06/06/2019 - 18:55

Tadalis Sx En France En Ligne viagra Avis Achat Viagra Ligne

LesKern (not verified)

Mon, 03/06/2019 - 21:19

2275 93 Amoxicillin cialis Amoxicillin 850mg Side Effects

LesKern (not verified)

Mon, 03/06/2019 - 21:14

2275 93 Amoxicillin cialis Amoxicillin 850mg Side Effects

LesKern (not verified)

Mon, 03/06/2019 - 21:03

2275 93 Amoxicillin cialis Amoxicillin 850mg Side Effects

RebImparf (not verified)

Sun, 02/06/2019 - 01:16

Cialis 20 Mg Filmtabl 12 St cialis tablets for sale Zithromax At Walmart Venta Viagra Valencia

RebImparf (not verified)

Sun, 02/06/2019 - 01:12

Cialis 20 Mg Filmtabl 12 St cialis tablets for sale Zithromax At Walmart Venta Viagra Valencia