Login
Remember
Register
Questions
Unanswered
Tags
Users
Ask a Question
Ask a Question
Export - SQL Server to File
0
votes
asked
Aug 21, 2021
by
billy
(
13.3k
points)
How can I export a file from SQL Server via PowerShell?
sql
Your comment on this question:
Upload image or document:
Preview:
Your name to display (optional):
Email me at this address if a comment is added after mine:
Email me if a comment is added after mine
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please
log in
or
register
.
Your answer
Upload image or document:
Preview:
Your name to display (optional):
Email me at this address if my answer is selected or commented on:
Email me if my answer is selected or commented on
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please
log in
or
register
.
1
Answer
0
votes
answered
Aug 21, 2021
by
billy
(
13.3k
points)
Invoke-Sqlcmd -Query "SELECT * FROM dbo.GLExportQuery" -Database di_prd_staging -Server EDI-Server | Export-Csv -NoTypeInformation -Path "c:\Temp\GLExportSQL.csv" -Encoding UTF8
Your comment on this answer:
Upload image or document:
Preview:
Your name to display (optional):
Email me at this address if a comment is added after mine:
Email me if a comment is added after mine
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please
log in
or
register
.
M3 and Related Technology
A place for me to remember the answers to questions I had to dig around to find. Please feel free to add questions and answers for anything related to Infor, M3, ION, and it's sprawling family.
Most popular tags
m3
mt
st
ion
widget
formwidget
ionapi
lso
enterprise-search
form
sql
mashup
sdk
mapper
datalake
ois120
...
