Need to create large number of JSON files as migration from SQL Server to noSQL DB.
TSQL to JSON conversion scripts are authored, but cannot see any method to create a physical JSON file. Lots of articles on the web about FOR JSON AUTO output but none provide method to save it as a .JSON file to disk.
Can only see tSQL to XML to JSON conversion methodology or save results as file/text and the you would have additional step changing the file type.
Would Azure Data Factory been a better tool?