Click here to Skip to main content
15,558,865 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I need to move a small (< 3GB) MS SQL database to the cloud and access it from a local Windows .Net program.

What I have tried:

I have done some research but not sure where I should host the DB. I've briefly looked at Google, AWS, Azure but still confused. Especially pricing. Probably others should be considered. One issue I did find is that it seems more difficult to access the DB when you don't have fixed IP's which will be my case. How do they calculate the pricing?

I'm just looking for some general guidance at this point as to where to host and any pricing information.
Posted
Updated 12-Jan-22 10:26am
Comments
Gerry Schmitz 4-Jan-22 11:34am    
You need to create a "web service" if you expect to access a "database in the cloud" from a "local Windows .NET program". Which implies a web server.
0x01AA 4-Jan-22 12:01pm    
So your idea is simply to host the database in the cloud but access it in a conventional way? Not really a good idea, I think.
Maciej Los 6-Jan-22 14:45pm    
Why? MS Sql Server might be accessible from WAN. All what you need to do is to enable remote connections. See: Configure the remote access Server Configuration Option - SQL Server | Microsoft Docs[^]

1 solution

I have to repeat my comment:

Quote:
Why? MS Sql Server might be accessible from WAN. All what you need to do is to enable remote connections. See: Configure the remote access Server Configuration Option - SQL Server | Microsoft Docs[^]


The point is: you can use already existing database (and server), but you have to enable access to it via exposing your server to WAN and enabling remote connections. See:
Port forwarding - Wikipedia[^]
Configure Windows Firewall - SQL Server | Microsoft Docs[^]

Good luck!
 
Share this answer
 
Comments
auguy 18-Jan-22 13:57pm    
Thanks for the info.
Maciej Los 18-Jan-22 14:52pm    
You're very welcome.

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