In previous post I wrote about exporting data from Microsoft SQL server table to CSV file. Export to JSON format is similar:
1 2 3 4 | Invoke-Sqlcmd -ServerInstance . -Database AdventureWorks -Query "SELECT TOP 3 AccountNumber, Name, CreditRating FROM Purchasing.Vendor" ` | Select-Object AccountNumber, Name, CreditRating ` | ConvertTo-Json ` | Out-File -FilePath Vendor.json -Encoding utf8 |
Content of exported JSON file is:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | [ { "AccountNumber": "AUSTRALI0001", "Name": "Australia Bike Retailer", "CreditRating": 1 }, { "AccountNumber": "ALLENSON0001", "Name": "Allenson Cycles", "CreditRating": 2 }, { "AccountNumber": "ADVANCED0001", "Name": "Advanced Bicycles", "CreditRating": 1 }] |
If you are interested in PowerShell automation, take my Udemy course Improve your productivity with PowerShell.