Click here to Skip to main content
15,881,381 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have one desktop application (c#). The database is mssql which is located in another system. It is working fine. Now i am curious about whether could i move the database to some webserver. I am not sure this question makes sense. Need some advice regarding this. Thank you.

What I have tried:

I have one desktop application (c#). The database is mssql which is located in another system. It is working fine. Now i am curious about whether could i move the database to some webserver. I am not sure this question makes sense. Need some advice regarding this. Thank you.
Posted
Updated 15-Aug-22 3:33am
v2

1 solution

That's not a question we can answer, or at least not directly.

It is possible - it's called "remote access" but it has to be enabled by the hosting service, and that's not too common because it's a huge security risk - you open up the whole DB Server to the internet, not just the single database you personally are interested in. And since most hosting services "share" an Sql Server instance between multiple users (it's too expensive for them to buy a new licence for each user) that means every client's DB is exposed and potentially vulnerable to exploitation and / or malicious activity.

Hence, it's a fairly rare thing - you'd nave to discuss this with the specific hosting company.

But ... you could put in a WCF "bridge" on the server which your app talks to and which accesses a DB "behind the firewall" - be a fair amount of work though and probably require a redesign of your whole app!
 
Share this answer
 
Comments
Member 11291660 15-Aug-22 10:11am    
Thank you Mr. OriginalGriff
OriginalGriff 15-Aug-22 10:34am    
You're welcome!
Member 11291660 15-Aug-22 23:29pm    
Is WCF bridge, the technique behind the desktop app for Facebook, Netflix, Amazon prime?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900