Timeline for ETL table from one SQL Server to another SQL Server
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 12, 2022 at 19:18 | vote | accept | xhr489 | ||
| Oct 12, 2022 at 18:24 | comment | added | J.D. |
When I commented on SSIS, it wasn't considering physical bottlenecks like network, only software bottlenecks. SSIS is designed to be an ETL tool. Linked Servers, External Tables, and OPENROWSET are not. So from a tool perspective, SSIS is the most relevant for ETL. From a physical bottleneck perspective, there shouldn't be any difference among the four options, the network speed will still be a constant for each option, generally speaking. Even if it is your biggest bottleneck.
|
|
| Oct 12, 2022 at 18:12 | comment | added | J.D. | @xhr489 Yes it's possible to configure a database in an Availability Group as a Publisher in Replication. | |
| Oct 12, 2022 at 16:26 | comment | added | xhr489 | Also the source is an AG. I guess it is possible right? | |
| Oct 12, 2022 at 16:18 | comment | added | xhr489 | If bottleneck is the network speed then I don't understand why SSIS is so superior... | |
| Oct 12, 2022 at 16:13 | comment | added | xhr489 | Can you add some information on why SSIS would be faster then the options mentioned in my question? | |
| Oct 12, 2022 at 14:25 | history | answered | J.D. | CC BY-SA 4.0 |