Forum Discussion
Query from one Database and load to another Database
Hi there, I am trying to query from one dataset in Azure and load data into a local database (Local instance on my computer) on my machine using SSMS. This is the code I have written the code as fol...
but it's not working.
patwary8 , "not working" means what in detail? Have you setup & tested a linked server pointing to your Azure database?
- Thanks Olafhelper. I am trying to extract data from remote server (in Azure) and store that data on a local server on my computer. I tried to link these 2 servers, but it looks like I don't have the rigt to do that. Therefore, I want to retrieve data from Azure, store it on a table in my local server. Can you please suggest the script I need to fmollow in order to do that.
