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(134.4, 90%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
We have two Azure SQL Managed Instance QA and Prod they are in the same Subscription. Any new records in Prod (minus the identity column) we would like to include it into the QA as we don't want to replicate the table as the Prod has unique identity columns. We just want to append the any new data/records into the Prod (minus the identity column). Link server is not an option for us.
![](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(281.6, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
@KaisMalique-9406
Please do let us know if you need further help regarding this.
Thanks
Navtej S
I don't have access to Azure Managed Instance, but is Transactional Replication available?
@Erland Sommarskog No even Transnational Replication cannot happen. The Client won't allow any environments to talk to each other.
One option I considered is if I import the tables as JSON and exported into the destination environment Azure SQL Managed Instance using ADF? Is this possible?
![](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(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Hi @KaisMalique-9406,
Please refer to the following articles which might help:
Publish data changes from Azure SQL Managed Instance using transactional replication
Transactional replication with Azure SQL Managed Instance
Best Regards,
Amelia
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
@AmeliaGu-MSFT Is importing the tables as JSON format and exporting into the destination environment in Azure SQL Managed Instance using ADF possible?
If Transactional Replication is out, I guess ADF is the thing to try next. I did not suggest it of the simple reason I have very little clue about it myself. There is a tag for azure-data-factory, I think you should try there, https://learn.microsoft.com/answers/topics/azure-data-factory.html.
![](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(236.8, 80%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
This is very difficult, it is a problem everyone has, and there are no simple solutions.
An alternative approach is to take a fresh copy of production every day and make that available for QA or other development purposes. This is reasonably quick and easy in Azure.
If you want to go further, then you are probably better off coming up with a way to export your QA components to this fresh copy every day, than vice-versa.
J.