Azure SQL Database
An Azure relational database service.
5,600 questions
Run a MERGE SQL script?
Azure Pipeline Data Sync
![](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(80, 57.99999999999999%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFF%3C/text%3E%3C/svg%3E)
Fred Flintstone
21
Reputation points
We have a database in dev/test/stage/prod and there is a large amount of reference/look up data. We would like to be able to sync the data between environments using out azure pipeline. Schema changes happen automagically with our entity framework migrations. We have created a data compare in visual studio that we use to sync the data on demand, but we would like to automate this process. Is there an existing task that we can add to the pipeline to run this data compare and subsequent sync?
{count} votes
-
Mike Ubezzi 2,776 Reputation points2020-10-23T05:16:40.887+00:00 Please do let us know if the information provided does provide a solution you are looking for, @Fred Flintstone .
Sign in to comment
1 answer
Sort by: Most helpful
-
ErikEJ 341 Reputation points MVP2020-10-15T18:06:49.793+00:00 -
Fred Flintstone 21 Reputation points
2020-10-15T20:45:42.67+00:00 I don't understand. In Azure Devops, pipelines, is there a task where I can do a MERGE Sql Script? I am currently doing a data compare with visual studio, but that is a manual step each time we deploy. I would like to have a step in the pipeline that syncs data from one db to another.
-
ErikEJ 341 Reputation points MVP
2020-10-16T13:09:33.87+00:00 -
Mike Ubezzi 2,776 Reputation points
2020-10-16T17:08:54.797+00:00 @Fred Flintstone - Please see the SQL Scripts section of the referenced document by @ErikEJ . Just below that section are ARM and Classic PowerShell script examples for disabling and enabling the firewall for the deployment tasks to run successfully. Please let us know if you have any additional questions. Regards, Mike
Sign in to comment -