ETL from SQL Server into Azure SQL managed instance

%3CLINGO-SUB%20id%3D%22lingo-sub-1024951%22%20slang%3D%22en-US%22%3EETL%20from%20SQL%20Server%20into%20Azure%20SQL%20managed%20instance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1024951%22%20slang%3D%22en-US%22%3E%3CP%3ENormally%20I%20use%20linked%20servers%20to%20connect%20my%20datawarehouse%20database%20to%20other%20databases%20to%20do%20my%20ETL%20using%20stored%20procedures%20that%20were%20scheduled.%26nbsp%3B%20But%20now%2C%20we%20are%20moving%20to%20Azure%20managed%20SQL%20server.%26nbsp%3B%20Is%20there%20an%20easy%20way%20to%20do%20things%20like%20run%20stored%20procedures%20that%20will%20pick%20data%20from%20source%20and%20move%20into%20destination%20SQL%20data%20warehouse%20database%3F%26nbsp%3B%20If%20linked%20servers%20is%20not%20available%20then%20that%20makes%20it%20kind%20of%20hard%20to%20code%20SP's%20that%20pick%20from%20source.%26nbsp%3B%20I%20started%20looking%20into%20Azure%20pipes%2C%20but%20was%20wondering%20if%20there%20is%20an%20easier%20way%20that%20is%20more%20compatible%20with%20the%20way%20I%20have%20been%20doing%20it%20in%20the%20past....%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Normally I use linked servers to connect my datawarehouse database to other databases to do my ETL using stored procedures that were scheduled.  But now, we are moving to Azure managed SQL server.  Is there an easy way to do things like run stored procedures that will pick data from source and move into destination SQL data warehouse database?  If linked servers is not available then that makes it kind of hard to code SP's that pick from source.  I started looking into Azure pipes, but was wondering if there is an easier way that is more compatible with the way I have been doing it in the past....

0 Replies