Csv | dbatools | Command-line superpowers for SQL Server automation

Export-DbaCsv

the dbatools team + Claude

Export-DbaCsv View Source the dbatools team + Claude Windows, Linux, macOS Synopsis Exports SQL Server query results or table data to CSV files with optional compression. Description Export-DbaCsv provides high-performance CSV export capabilities with support for multiple compression formats including GZip, Deflate, Brotli, and ZLib. The function can export data from SQL queries, tables, or piped objects to CSV files with configurable formatting options. Supports various output formats including custom delimiters, quoting behaviors, date formatting, and encoding options.

Import-DbaCsv Design Considerations

Chrissy LeMaire

This post is about Import-DbaCsv, a command within the dbatools PowerShell module for SQL Server. I’ve been writing about CSV imports using PowerShell for a pretty long time and in VBScript for even longer. Initially, my primary concerns were ease-of-use and speed. Over time, I realized that what mattered most was: Ease-of-use Reliability Data quality management I learned a ton about performance from my speed experiments but in the end, I threw most of that out in favor of a higher quality and mildly slower solution using a .