-1

Scenario:

I need to:

1) Run a job on my sql server(Source) through Azure Data Factory.

2) Maintain consistency across Sql Server 2012 (Web Edition) and SQL Azure for 7 of my tables

Current Approach: I was opting to use azure data factory, but need to know the complete flow for my scenario.

Thanks for the help.

Anurag Raj
  • 1
  • 3
  • I would start with this article [Move data from an on-premise SQL server to SQL Azure with Azure Data Factory](https://learn.microsoft.com/en-us/azure/machine-learning/machine-learning-data-science-move-sql-azure-adf). Otherwise this question is a bit broad and will probably get closed. – wBob Feb 23 '17 at 13:43
  • This doesn't sound like a SO question as a result of an error. It sounds like you need an architect to come and design the solution for you! – Paul Andrew Feb 23 '17 at 14:07
  • Hey can you guide me to invoke stored procedure using "author and deploy" in azure data factory in my sql server 2012 web edition , copy the data from the aggregation and update it to sql azure. – Anurag Raj Feb 23 '17 at 18:12

1 Answers1

0

You would need to install and configure Data Management Gateway, then create the linked service for your SQL Server 2012, for more details, see https://learn.microsoft.com/en-us/azure/data-factory/data-factory-move-data-between-onprem-and-cloud .

Also you would need to create the linked service for Azure Blob Storage and Azure SQL database, for detailed steps, please review this similar blog:http://www.tenpoint7.com/2016/02/how-to-setup-azure-data-factory-adf/.

Lydia - MSFT
  • 51
  • 1
  • Hey! I have already done that, need help in writing the json part for Exec SP onPremise -> Copy to Storage -> Exec SP Azure SQL -> Copy to Azure SQl – Anurag Raj Feb 27 '17 at 13:47
  • The steps that create JSON files and create pipeline are well introduced in this official article:https://learn.microsoft.com/en-us/azure/machine-learning/machine-learning-data-science-move-sql-azure-adf, what issues do you get in the process? – Lydia - MSFT Feb 28 '17 at 09:51
  • The problem faced is in executing the stored procedure at source and sink, i cannot figure out how to provide credentials for stored procedure Thanks – Anurag Raj Mar 01 '17 at 09:42