User Profile
patwary8
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Re: Query from one Database and load to another Database
Thanks Ronen_Ariely. FYI I can read data from Azure, which means I have read only access. I tried to link the server, but my permission on Azure restricts me to do that. Looks like you have described the alternate procedure very well and I should be able to connect and achieve what I want. I will try it today.1.4KViews0likes0CommentsRe: Query from one Database and load to another 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.1.5KViews0likes0CommentsRe: Query from one Database and load to another Database
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.1.5KViews0likes2CommentsQuery 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 follows, but it's not working. Can someone tell me what should be the correct script? Thanks. INSERT INTO [MYCOMPUTERNAME\DESTINATIONDATABASE].[DESTINATIONDATABASE].[DESTINATIONINSTANCE].[DESTINATIONTABLE] SELECT * FROM [abcd.database.windows.net].[SOURCEDATABASE].[DBO].[COURCETABLE]1.7KViews1like6Comments
Recent Blog Articles
No content to show