I have a website built in RoR hosted on a dedicated linux server and connected to a remote MSSQL server.
We use website to collect orders and to show order's status.
Since MSSQL isn't always online we need website to be connected to a local db instance on linux server (MYSQL or whatever will fit our needs).
Additionally we will need local db to synch with remote MSSQL so that we always have same data on both databases.
We only need a subset of tables in MSSQL replicated in website db.
I'm open to suggestions and proposal.
Looking forward for an efficient solution, happy bidding.