No doubt, multiple users are using MS SQL Server for storing and retrieving the data in a safe & secure way. With this application, users can easily relationally manage a database of any size. However, there are times when the user faces the need to extract table from SQL Server to CSV format. This conversion of data can be done from the SQL Server Management Studio. But in some cases, due to lack of knowledge, users become unable to perform the task by themselves. Therefore, in this technical post, we are going to discuss a complete step-by-step guide on how to export table from SQL Server to CSV file without any loss of data.<\/p>\n
Before we proceed, let us see a real-life user query for the same:<\/strong><\/p>\n \u201cHello all, I have created a student database in SQL Server 2016. Now I want to export tables from SQL Server to CSV format. My friend told me that this conversion is possible but I do not know the exact procedure to do so. Can anyone share a simple and actually working technique to export table from SQL Server to CSV format?\u201d<\/em><\/p>\n Follow the steps to export data from SQL Server to CSV, but remember the database should be in a healthy state.<\/p>\n Step 1:<\/strong> Firstly, run SQL Server Management Studio in your system and connect to the database<\/strong>.How to Export Table From SQL Server to CSV?<\/h2>\n
\nStep 2:<\/strong> After that, go to Object Explorer<\/strong> and select the database from which you want to export data in CSV.
\nStep 3:<\/strong> Right-click on the selected database and go to Tasks<\/strong> then Export Data<\/strong> to export table in CSV format.
\nStep 4:<\/strong> Now, in the Import\/Export wizard, select SQL Server Native Client 11.0 in Data Source and select SQL Server instance in Server Name and use an authentication mode for Authentication.
\nStep 5:<\/strong> Here, select the database that you want to export and hit the Next<\/strong> button.
\nStep 6:<\/strong>\u00a0Under Choose a Destination Window, choose Flat File Destination<\/strong> to export data from SQL Server to CSV and click on Next<\/strong>.
\nStep 7:<\/strong> In the specify table copy or query page select either Copy data from one or more tables or views<\/strong> or Write a query to specify the data to transfer<\/strong> afterward click on Next<\/strong>.
\nStep 8:<\/strong> Select the desired table from the Source table or view option<\/strong>. You can also change the default settings of row delimiter<\/strong> or column delimiter<\/strong>.
\nStep 9:<\/strong> Now, you can either select Run immediately<\/strong> or Save SSIS package<\/strong> to export table as CSV from SQL Server and click on the Next<\/strong> button.
\nStep 10:<\/strong> In Complete the Wizard screen, preview the entire summary of export task. And finally, click on Finish<\/strong> to begin the process.<\/p>\nWhat to do if in case SQL database gets corrupt?<\/h2>\n