Transfer data between azure managed instances using stored procedure names and their table definition in a source table

Question

I have in a table the stored procedure / view / table (they are multi step tuned procedures , for most cases simple table / or view exports do not work) and also the definition of that dataset when needed (for stored procs) (there are numerous records in this table with all kinds of different table definition)

I was thinking the easiest would be bcp export using native format from servera.databasea, then get the table definition from the table in servera.databasea then create the same structured staging table in serverb.databasea and use bcp native to import there.

I am not sure how I can implement this in Azure NOT using data factory local hosted runtime. The code should be generic to support any stored proc/view etc and not requiring any custom code / pipeline if input datasets differ

Any ideas?
Thank you

Answer 1

@Gokhan Varol

We apologize for the delay in response. From the looks of it you are looking for ways to transfer Data in from one managed instance to another.

Native Back up Restore definitely works for Managed Instance and is an option. Copy Only Back up and restoring them will be another option.

Additionally exporting and importing using BACPAC and also you can use replication with MI pub and sub architecture. There would be some testing required here to check what is best suited for your case. Please go through the documents. If you have any question regarding any of the cases, please revert.

Also if you think we are not able to answer to what you need, please elaborate your question further and we will be happy to help you.

Thanks
Navtej S