c# - Access local DB on user pc from a remote application running on "Azure Server" -
i new ms azure , developing remote apps.
have read , viewed learning stuff.
i use c# developing language, , have understood, simple develop windows application run on azure server remote app, users anywhere on earth can run pc if installed locally on pc's. in reality, more like, rdp hiding behind app.
the problem database running on every users pc instead on azure server. suppose design, don't ask me why.
we tend use "ms access" local db, since have ms office.
anyway, problem. wondering is, how can make remote application on azure server communicate database installed locally on user(s) pc?
i have drawn simple figure explain mean.
back in days when people used modems connect pc's tubes, theoretically possible (although maybe not idea). nowadays, very few pc's connected directly internet.
in office, pc connected via company intranet external gateway , pc not visible outside gateway. same true @ home, gateway router.
it possible lot of work allow external access (from azure) individual pc, not easy set up. further, need write piece of software run on pc listen on correct port calls azure, run appropriate sql queries, , return data azure. might install sql server full edition on each pc.
even if that, no security professional going let open ports , firewalls internet; it's lot of work doing , might install random viruses on pc - you'll same point faster , less wasted time.
tl;dr: not easy without significant investment, , pc trashed if do.
Comments
Post a Comment