TN - 1043 Using PowerShell to extract data from SQL Server DB (Historian) into a CSV file
Description
Using PowerShell to extract data from SQL Server DB (Historian or others) into a CSV file
This article from InSource shows how to use PowerShell to extract data from SQL Server DB (Historian) into a CSV file
- Author: Bruce Telford
- Published: 09/30/2020
- Applies to: All Versions
Details
There are many ways to extract data from SQL Databases to CSV, generally by coding in App Server, SSIS, VS and many others. PowerShell is now part of the Windows OS and makes it simple …