Forum Discussion
Data transferring from SQL server table to text file without using bcp
Hi friends, I have data in SQL server table and I need to transfer from it to the text file with specific name format and with column names and specific data size of the data types. I couldnt do ...
If you want to use something like PowerShell, dbatools has a few commands that can help with that as well.
For instance Export-DbaDbTableData can export the data for you: https://docs.dbatools.io/Export-DbaDbTableData