Data Sync Between on Prem SQL Server and Azure SQL Managed Instance

Question

Data Sync Between on Prem SQL Server and Azure SQL Managed Instance

Sapna Gupta 1

Hi,

I Created a Copy Data Pipeline between on Prem SQL Server and Azure SQL Managed Instance using Integration Runtime(Self Hosted). Although the Pipeline ran successfully, I am not able to find the Tables that have been copied to the Azure SQL DB(linked with Azure SQL Managed Instance).
I want to know the location for the tables that were copied from on prem SQL Server.

Thanks

MartinJaffer-MSFT 26,236 Reputation points

2021-06-28T21:16:48.46+00:00

Hello @Sapna Gupta and welcome to Microsoft Q&A.

In the pipeline's copy activity, you can open the sink dataset. The sink dataset should contain the table name unless you parameterized it.

If you did parameterize it, then open the pipeline run in the monitoring section and check the copy activity's input. There you can find value passed in, and reconstruct the table name.

Does this help?
HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator

2021-07-01T23:22:01.097+00:00

Hello @Sapna Gupta ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator

2021-07-08T17:09:13.107+00:00

Hello @Sapna Gupta ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

1 answer

Your answer

MartinJaffer-MSFT 26,236 Reputation points

2021-06-28T21:16:48.46+00:00

Hello @Sapna Gupta and welcome to Microsoft Q&A.

In the pipeline's copy activity, you can open the sink dataset. The sink dataset should contain the table name unless you parameterized it.

If you did parameterize it, then open the pipeline run in the monitoring section and check the copy activity's input. There you can find value passed in, and reconstruct the table name.

Does this help?
HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator

2021-07-01T23:22:01.097+00:00

Hello @Sapna Gupta ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator

2021-07-08T17:09:13.107+00:00

Hello @Sapna Gupta ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

Answer 1

Hello @Sapna Gupta ,
Thanks for the ask and using the Microsoft Q&A platform .

Adding to what Martin said may be the server to which you are looking is not correct . To find the correct server name , Click on the sink ->
sink datastet ->Open - > Linked service -> edit and you should be able to see server name and the database name .

Please do let me know how it goes .
Thanks
Himanshu
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

Share via

Data Sync Between on Prem SQL Server and Azure SQL Managed Instance

1 answer

Your answer