How to move small MS SQL database to the cloud

Question

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 4-Jan-22 5:04am

auguy

Updated 12-Jan-22 9:26am

Add a Solution

Comments

[no name] 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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Maciej Los · Answer 1 · 2022-01-12T09:26:00

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!