Forum Discussion

Sreej320's avatar
Sreej320
Copper Contributor
May 06, 2022

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 ...
Ronen_Ariely's avatar
Ronen_Ariely
MVP
May 30, 2022

Hi Sreej320 

You got great solutions so far and I would like to add another one to the party.

All the solutions till this point based on something that is installed but if you cannot install anything then there is a simple solution as well (which fit to any common operating system)

 

Use Azure Data Studio to execute a simple query which return whatever you need and export it directly to a text file. Azure Data Studio is a management studio application which is free and open source! It has version for any common operating system and there is no need to install anything or have any special permission to run it in the client side (obviously you connect the server so you will need the authentication to the SQL Server but this not related to execute the app but to the connection to the server/database. You can have the app files stored in external disk or disk-on-key and execute it directly from there

 

https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver16

 

With all this said and all solutions, my prefer option will be bcp for most cases

Resources