Azure Data Share to Share data from Azure Managed Instance SQL Server

Balan Murugan 41

As part of my migration project requirements, I am looking to share data from my source system which is in Azure MI SQL Server and to the target system which is also in Azure MI SQL Server.

I need to share the source data which is in Azure MI SQL Server in one Azure Subscription (Subscriptio A) to Azure MI SQL Server in another Azure Subscription (Subscription B).

I understand from Azure Data Share documentation that, it supports Azure SQL Database as a source.

Can Azure Data Share supports Azure MI SQL server as data provider and consumer?

If it supports, can you please share the relevant docs for the pre-requisite and what are the steps to be followed for this?

PRADEEPCHEEKATLA-MSFT 77,901 Reputation points Microsoft Employee

2024-05-06T06:12:54.7266667+00:00

@Balan Murugan - Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

PRADEEPCHEEKATLA-MSFT 77,901 Reputation points Microsoft Employee

2024-04-26T08:07:12.29+00:00

@Balan Murugan - Thanks for the question and using MS Q&A platform.

Azure Data Share does support Azure SQL Managed Instance as a data provider and consumer.

According to the official documentation: Supported data stores in Azure Data Share, the following table explains the data stores that Azure Data Share supports.

Appreciate if you could share the feedback on our feedback channel. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Please sign in to rate this answer.
Balan Murugan 41 Reputation points

2024-04-26T10:47:38.6766667+00:00

@PRADEEPCHEEKATLA-MSFT -Thanks for your response.

Yes. I have gone through the above link from Microsoft documentation for Azure data share supported data store above. It says for Azure SQL Database.

Can you please confirm if Azure Data Share supports "Azure SQL Managed Instance" for both source and target?

If yes, as per the documentation it says that, Azure SQL Database does not support for Incremental snapshots. If this is the case, everytime the Azure Data Share consumer consumes the data (Target as Azure SQL Managed Instance) they needs to trigger "FULL SNAPSHOT" refresh in the target. Meaning it will be drop and load everytime in the target. Is this my understanding correct?

Balan Murugan 41 Reputation points

2024-04-26T10:50:29.0133333+00:00

Hi @PRADEEPCHEEKATLA-MSFT Thanks for your prompt response.

Yes. I have gone through the above Microsoft documentation for Azure Data Share supported Data stores. It says it supports for Azure SQL Database.

Can you please confirm if Azure Data Share supports "Azure SQL Managed Instance" for both source and target?

If yes, as per the documentation it says that, Azure SQL Database does not support for Incremental snapshots. If this is the case, everytime the Azure Data Share consumer consumes the data (in Azure SQL Managed Instance) they needs to trigger "FULL SNAPSHOT" refresh in the target. Meaning it will be drop and load everytime in the target. Is this my understanding correct?

PRADEEPCHEEKATLA-MSFT 77,901 Reputation points Microsoft Employee

2024-04-29T03:22:42.2566667+00:00

@Balan Murugan - According to the official documentation: Supported data stores in Azure Data Share, only Azure SQL Database is supported and not Azure SQL Managed Instance.

Can you please confirm if Azure Data Share supports "Azure SQL Managed Instance" for both source and target?

No, it's not supported.

If yes, as per the documentation it says that, Azure SQL Database does not support for Incremental snapshots. If this is the case, everytime the Azure Data Share consumer consumes the data (in Azure SQL Managed Instance) they needs to trigger "FULL SNAPSHOT" refresh in the target. Meaning it will be drop and load everytime in the target. Is this my understanding correct?

Yes, Azure SQL Database doesn't support Sharing based on incremental snapshots. An incremental snapshot is based on the last-modified time of the files. Existing files that have the same name as files in the received data are overwritten in a snapshot. Files that are deleted from the source aren't deleted on the target.

Hope this helps. Do let us know if you any further queries.
Sign in to comment