question

Kman-9406 avatar image
0 Votes"
Kman-9406 asked JRStern-6236 answered

Sync new records in Prod to QA in Azure SQL Managed Instance

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.

sql-server-generalazure-sql-databaseazure-sql-virtual-machines
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@KaisMalique-9406

Please do let us know if you need further help regarding this.

Thanks
Navtej S

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered Kman-9406 commented

I don't have access to Azure Managed Instance, but is Transactional Replication available?

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@ErlandSommarskog 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?

0 Votes 0 ·
AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered Kman-9406 commented

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.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@AmeliaGu-msft Is importing the tables as JSON format and exporting into the destination environment in Azure SQL Managed Instance using ADF possible?

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

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://docs.microsoft.com/answers/topics/azure-data-factory.html.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JRStern-6236 avatar image
0 Votes"
JRStern-6236 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.