I have an app that stores event data. We use SQL Azure. Right now it's very expensive. Over $800/month to host. Once the event is over, I want to move the data to a DB that has a lower cost. Thus this will keep my SQL Azure usage lighter, and allow me to downgrade to a cheaper plan.
What is the best option?
- Move data to a SQL Server Standard Edition (on-prem)
- Move data to an MySQL Server (on-prem)
- Use a new NoSQL DB?
The end-goal is to update our API, so it will pull data from both DBs in the results.