question

SapnaGupta-1292 avatar image
0 Votes"
SapnaGupta-1292 asked HimanshuSinha-MSFT commented

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

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

azure-data-factoryazure-sql-database
· 3
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.

Hello @SapnaGupta-1292 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?

0 Votes 0 ·

Hello @SapnaGupta-1292 ,
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

0 Votes 0 ·

Hello @SapnaGupta-1292 ,
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

0 Votes 0 ·

1 Answer

HimanshuSinha-MSFT avatar image
0 Votes"
HimanshuSinha-MSFT answered

Hello @SapnaGupta-1292,
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 .

109960-image.png



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



image.png (27.8 KiB)
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.