This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 8%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Hello,
We have an Azure SQL Database that we use as our target database (DB) for production use. We want to merge data from a new source DB into the target DB. The source and target are both SQL, but have different Schemas. The Source DB originates in a local environment.
Our plan coming in was to migrate the source into the cloud on the same server as the target and then use Insert statements to move the data into the target.
From what I have learned, this is not possible for Azure SQL.
My question is, how am I going to get the data from the source to the target in Azure? I will have to write queries to map specific columns in the source to the correct columns in the target as I go.
Thanks for your help!
You can use Azure Functions as intermediary layer and here you will find detailed instructions.
Alternatively, you can use DML triggers to do the same.
Thanks for your reply, @Alberto Morillo . I read through the documentation at the link you sent.
On the one hand, it looks like we could create a project in Visual Studio, somehow publish it to an Azure Function and run the operation. We encounter a lot of duplicate records in the databases we want to merge into ours. It appears the merge operations help eliminate many of these.
On the other hand, it looks like the Azure Functions have a lot of little quirks and settings to look out for, such as avoiding timeouts. I also can't imagine publishing from Visual Studio to an Azure function. We use Azure DevOps to create Pipelines and publish them to web apps. Do functions work the same way? How can I learn more?
You can do Azure Function deployments from Azure DevOps pipelines. Here you will find a short training module that focus on that.
Let me know if this helps.
Thanks for sharing the link. we have been reviewing Azure functions today. It looks like Azure Functions will work very similarly to an Asp.NetCore Api App. So, we're thinking we will just go that route.
Would an Azure function give me any benefits in comparison to an API app?
Azure Functions are most cost-effective and you can develop a robust API service with Azure Functions. You can develop using Visual Studio and using the Portal. Azure Functions are full REST you can call them from anywhere.
@Jim Derry Thank you for your reach out.
My understanding is that you are trying to migrate your local DB to an Azure SQL database. In addition to @Alberto Morillo answer you can use the copy activity tool in ADF or the Data Migration extension in Azure Data studio if you are not concerned about the downtime.
See link below on how that can be achieved.
Tutorial: Migrate SQL Server to Azure SQL Database (preview) offline in Azure Data Studio
Move data from a SQL Server database to SQL Database with Azure Data Factory
Create an Azure SQL assessment.
Please let us know if that answers your question.
Regards,
Oury
@Jim Derry Just checking in to see if the below answers helped. If that answers your query, do click Accept Answer and Yes for was this answer helpful for both answers provided. And, if you have any further query do let us know.
Hello @Oury Ba-MSFT , and thank you for your reply. We currently use the Data Migration Assistant to migrate the existing database to Azure so we can start transforming it to our Azure SQL from there. But I'm interested in learning more about using the Azure Data Factory. There are so many resources and references. I'll start with the links you sent.
Also, thanks for your help in responding that you answered my question. I didn't know I could reply that both answers were helpful.
jim