Convert JSON file to DB file

Question

Convert JSON file to DB file

Sela 126

Dear Sir or Madam,

Is it possible to convert a JSON file into a DB file? If yes, I would be very grateful for an answer with a possible solution.

Best regards

Yitzhak Khabinsky 26,586 Reputation points

2022-01-17T15:57:52.3+00:00

@Sela ,

While asking a question you need to provide a minimal reproducible example:
(1) DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.
(2) What you need to do, i.e. logic, and your attempt implementation of it in T-SQL.
(3) Desired output based on the sample data in the #1 above.
(4) Your SQL Server version (SELECT @@version;)

Accepted answer

1 additional answer

Your answer

Yitzhak Khabinsky 26,586 Reputation points

2022-01-17T15:57:52.3+00:00

@Sela ,

While asking a question you need to provide a minimal reproducible example:
(1) DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.
(2) What you need to do, i.e. logic, and your attempt implementation of it in T-SQL.
(3) Desired output based on the sample data in the #1 above.
(4) Your SQL Server version (SELECT @@version;)

Answer 1

Hi @Sela ,

In addition to the documentation provided by Olaf, I recommend you read this article, which includes screenshots for easy understanding.
See: Import JSON data into SQL Server

Best regards,
Seeya

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.

Answer 2

Olaf Helper 47,436

You can not directly "convert" JSON into somekind of database file.

But you can query JSON to get the data to insert into a database table.
See Parse and Transform JSON Data with OPENJSON (SQL Server)

Share via

Convert JSON file to DB file

1 additional answer

Your answer