Hi, I need to export the data from my SQL server in JSON format (so that they can imported to a graph database).
When I have few data, this is no problem, I can even run the query and copy paste the result. But this works only when the output file is roughly less than 4MB.
When I have large dumps of data - in some instances can be up to 100MB, I am using the export technique from the SQL server.
You can find the documentation in the answer here: https://stackoverflow.com/questions/952247/sql-server-truncation-and-8192-limitation For the case of JSONs you just have to tick the Unicode box.
https://docs.microsoft.com/answers/storage/attachments/74251-jsonbug1.png
Then you add your query:
https://docs.microsoft.com/answers/storage/attachments/74235-jsonbug2.png
And finally you chose your delimiters:
https://docs.microsoft.com/answers/storage/attachments/74214-jsonbug3.png
The problem is that when the size of the dump is too large, the dump is corrupted. You get odd empty lines etc. see:
https://docs.microsoft.com/answers/storage/attachments/74197-jsonbug4.png
or this:
https://docs.microsoft.com/answers/storage/attachments/74236-jsonbug5.png
At times, in very large files (over 30MB) splits/new lines appear after the opening quotes of properties/attributes etc.
Has anyone here came across this issue?
How can we get a quick resolution? Just by writing here or need to open a case will it solve the issue in a reasonable amount of time? Any other approach in exporting JSON data? Thank you!
[1]: /answers/storage/attachments/74251-jsonbug1.png [2]: /answers/storage/attachments/74235-jsonbug2.png [3]: /answers/storage/attachments/74214-jsonbug3.png [4]: /answers/storage/attachments/74197-jsonbug4.png [5]: /answers/storage/attachments/74236-jsonbug5.png
