I am looking a fast option to transfer large data from Sql Server 2016 . I have tried bcp and some export happens . But I am not able to view data . Also for bcp, in command prompt, It prompts for entries. How to get rid of these manual prompts?
Can you please give an example for bcp ?
I followed the link for bcp