Csv

A New CSV Library: Built for SQL Server

Chrissy LeMaire

This post is about a huge update to the CSV import (and now export!) capabilities in dbatools. If you’ve used Import-DbaCsv, you’ve been using the LumenWorks CSV library under the hood for years. It’s been rock solid and I’ve sung its praises many times. But LumenWorks was last updated 7-8 years ago, and .NET has come a long way since then. I’ve been using Claude Code for various projects and had a Max 20x account when Anthropic announced they’d be pretty much giving away Opus 4.

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 .