Hi,
I want to fetch data from the Sql Azure db to our on-premises table. I was trying to accomplish by
- I. Running on-prem sql job using Sql login, which is different from sql server agents as windows credential. To achieve this I tried to using proxy account but it accepts only windows credential, tried back channeling with windows credential map to sql login. but I can't map proxy account for Job T-sql type.
- II. Xp_cmdshell utility to fetch data and output to the file, It hungs in the middle and delimeter is not formatted well even if we want to process further.
What is the best practice ?. Any pointers to achieve this task will be greatly appreciated.