We are running an application called Shipworks for our shipping solution. We have a database that is approximately 1gb in size and would like to host it in the cloud (example: Amazon RDS). Currently we store the DB on our lan but we have a requirement for multiple locations to connect to the database. So we want access to the DB from anywhere without using a VPN.
I need help to accomplish this. I know shipworks does not support it but they said it can be done and that customers have done this in the past.
The server needs to be compatible with SQL Server 2008 R2