RoR Website requiring databases synchro

$30-250 USD

Closed

Posted

about 6 years ago

$30-250 USD

Paid on delivery

Hi, 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. Dario

Database Development

Database Programming

Ruby on Rails

Software Architecture

Software Development

Project ID: 16665116

About the project

14 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

14 freelancers are bidding on average $183 USD for this job

@fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice

$166 USD in 3 days

5.0

(19 reviews)

5.7

@sandeepsrm23

Hi I will set up the local db (Postgres or MySql) and will replicate the subset of tables in MSSQL. I will set-up the background job, that will periodically (mind night every day) update the mssql in background. I am "Full Stack Developer" (Experience: 8+ years) having expertise in web development and I want handle this job for you. Thanks

$444 USD in 3 days

5.0

(28 reviews)

5.5

@bapixyrs

Dear Client, In my 5+ years as a full stack developer, I have successfully delivered numerous web solutions to my clients. I am confident I can do this project for you. Front End: HTML, CSS, Angular JS, React JS, jQuery, Javascript, Bootstrap Back End: ASP.NET, PHP, Laravel, Codeigniter, Node.js, Wordpress, Magento, Vue.js, Java E-Commerce: Prestashop Shopify, Woocommerce Database: MySQL, Oracle, MongoDB API Kindly initiate the conversation so that we can discuss about your requirements. Regards, Ritvik

$155 USD in 3 days

0.0

(0 reviews)

0.0

@vaibhavjiit128

Hi, I have gone through your requirement for local db to synch data. By keeping this thing in mind I am expressing my interest in doing this assignment. I am very happy to understand your complete requirement for sharing our thoughts to give you more realistic approach and SRS. Looking forward to hearing from you for further discussion. Cheers!!.

$140 USD in 10 days

0.0

(0 reviews)

0.0

@cmcolinh

I would propose make accessing the local DB as the default action, synchronizing the DB from the remote DB one or more times a day. I would want to use MySQL for the local DB (unless you are looking to pay for a DB). I would try to change the DB in a way that allows the code base to be as untouched as possible, only switching the default DB and then adding the synchronizing logic. I'm thinking this should be a fairly straightforward implementation. I look forward to hearing more about your requirements, and working on this project. Colin Horner

$125 USD in 3 days