Choosing the Best dB for AWS vs AZURE

Robb Hill
Robb Hill used Ask the Experts™
on
I am looking for the best DB giving the following considerations.

1)  I will be deploying a .net /angular application into Azure via Docker / Kubernetes.

2)  I would want on prem and cloud capabilities..natively

3)  Finally we will be moving to AWS in the next year..so migration is important as well.


I will want to use relational database.  High availability, on prem and off prem  capabilities, as well as other great scaling capabilities.

Also having a hard time with the cost model here...so any knowledge there would be helpful.

I will be doing this in a CI/CD ...I am guessing I would have docker in my local enviornment (free)  then move to a dev / stage/ prod enviornment.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
I have found that AWS MSSQL server charges are (to put it mildly) excessive compared to Azure SQL pricing. They charged for the time that I added the sql server until I deleted it so I got a $500 bill for 0 usage  With Azure as long as you remember to turn off the vm which decommissions it rather than simply powering down the vm using the o/s turn off (the vm still is running just idle if you do it that way)
Robb HillSenior .Net Full Stack Developer

Author

Commented:
Very good info.thank you!
Robb HillSenior .Net Full Stack Developer

Author

Commented:
Did you setup your db in a container or just serverless.

Do you think there is value in putting db in a container or just leaving it outside of my application container is all that matters?  Speaking of Azure.

Also do you think using Maria on linuz versus MSSql on Windows will make a difference.
Again container versus no container .

My application will be in a docker container for sure.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial