Timeline for How to make a remote SQL Server to pull local SQL Server data
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 20, 2023 at 22:00 | vote | accept | Skary | ||
| Sep 20, 2023 at 16:05 | answer | added | Aman Raiyyani | timeline score: -4 | |
| Sep 20, 2023 at 15:13 | comment | added | Skary | Ps : i prefer to clarify it further, when i say data sources change frequently I mean that SQL Server Express installation (PC) changes. Now i am quite sure I can't do much to change the fact that edge nodes have to proactively connect to central server, but maybe there is a way to let the edge node to request a data pull executed by central node instead of actually send data. | |
| Sep 20, 2023 at 15:05 | answer | added | Sean Gallardy | timeline score: 2 | |
| Sep 20, 2023 at 14:59 | comment | added | Skary | @J.D. sorry english isn't my mother tongue, probably I messed up my explanation. Data sources are SQL Server Express edition on normal PC inside customer network. Sometimes customer move PC, sometimes network change layout/IP (customer update it) and sometimes the product is installed to another new customer. Each customer may have many instance of the software, that collect and place data into the local SQL Express. When data are ready SQL Express istances send it to the cloud (a SQL Server SE on which they can connect) and push the data. But push is inefficient. Hope to have explained better | |
| Sep 20, 2023 at 14:01 | comment | added | J.D. | "data source change quite frequently" - Wouldn't that mean any solution you implement on the data source, you'll need to update every time the data source changes? (No different then if you had to manage it from the cloud instance?) | |
| Sep 20, 2023 at 13:19 | comment | added | Skary | @J.D. no I can't, this is the issue. Because data source change quite frequently and are behind firewall/NAT. So basically central SQL Server don't know how to reach data source until receive a connection from them | |
| Sep 20, 2023 at 12:26 | comment | added | J.D. | I don't really understand your problem. Can you create a Linked Server from the SQL Server instance in the cloud to the Express Edition instance data source? | |
| Sep 20, 2023 at 9:33 | history | asked | Skary | CC BY-SA 4.0 |