Export Huge Data to JSON File from SQL Server 2019

simmigang 41 Reputation points
2020-12-08T00:52:42.447+00:00

Hi Everyone,

I need to export a huge set of records into a file, maybe CSV or JSON. I have the data in SQL Server Table. I don't have any ETL tool to use. Please advise.

Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,547 questions
{count} votes

1 answer

Sort by: Most helpful
  1. MelissaMa-MSFT 24,176 Reputation points
    2020-12-08T01:26:14.35+00:00

    Hi @simmigang ,

    Thank you so much for posting here.

    SQL Server supports bulk exporting data from a SQL Server table by using below methods:

    • bcp utility
    • SQL Server Import and Export Wizard

    You could also use SQL Server Reporting Services (SSRS) or SQL Server Integration Services (SSIS) in SQL Server Data Tools (SSDT) within Visual Studio.

    Please refer detailed steps in below links and check whether any of them is helpful to you.
    How to export SQL Server data to a CSV file
    Using SQL Server Integration Services to Export Data in JSON Format

    Best regards
    Melissa


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Hot issues November--What can I do if my transaction log is full?
    Hot issues November--How to convert Profiler trace into a SQL Server table

    0 comments No comments