Dump all of the tables in a given database into CSVs

DumpTablesSamplesInCSV.ps1

$database = 'MyDatabaseName'
$instance = 'localhost\SQLEXPRESS'

$tables = Invoke-SqlCmd -Query "SELECT TABLE_NAME FROM [$database].INFORMATION_SCHEMA.Tables" -ServerInstance $instance -Database 'msdb'
foreach ($table in $tables) {
  $tableName = $table.TABLE_NAME
  Invoke-SqlCmd -Query "SELECT TOP 50 * FROM [$tableName]" -ServerInstance $instance -Database $database |
  ConvertTo-Csv -Delimiter '|' -NoType |
  ForEach-Object {$_.Replace('"','')}|
  Out-file "C:\DATA\$tableName.csv"
}