How to save data from all tables in SQL Server database into CSV files (using PowerShell)
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.