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...
Hi patwary8
your description is not clear to me. Please try to elaborate.
What is "[abcd.database.windows.net].[SOURCEDATABASE].[DBO].[COURCETABLE]"
Is this a linked server or you try to use a table in a remote server without even connect the server (which it is what seems you do and make no sense)?
In general, assuming I got what you need correctly, then you can use linked server and you can use SELECT from OPENROWSET for example.
Thanks Ronen_Ariely. 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.