Search, Compare, Update MySQL / PostgreSQL DB

Hello, sir. I am very interested from your project. I have enough skills for your project. I'm TOP 6TH freelancer as you can see my profile (https://www.freelancer.com/u/kchg.html). Kind Regards

hi, i can do small python script for it. i hope that coping must be done in one direction and fileds set are the same in both databases.

A proposal has not yet been provided

Hi, I just saw your requirement and I would love to work on this since your requirement is very well specified. Regards, Azhar

compare values from 1 column in a MySQL db with 1m+ rows and a PostgreSQL with ~3k rows, then update one of the db's with the other's values. compare values from 1 column in a MySQL db with 1m+ rows and a PostgreSQL with ~3k rows, then update one of the db's with the other's values.

Tengo 4 años de experiencia con mysql y postgresql, ademas tengo conocimientos en plsql de postgres.

Hi! Oracle Certified Professional MySQL DBA here. Also, several years of Postgres experience in production environments. I can knock this out for you and provide an explanation of the exact steps taken to perform the task. My approach would be to export the Postgres data, import to a temporary table in MySQL so that the tables can be directly compared, then either directly update the MySQL DB or export and apply the changes to the Postgres DB, depending on which system should receive the updates.

I am database administrator. 4 years experience with mysql and postgresql. I can do it in sort time.

This is one of my favorite kinds of projects...But, realistically I'm not sure what kind of quality you'll get for a $30/budget. Here's how I would propose to go about the project: 1. If you like my proposal, we chat about your project requirements for 15-30 minutes to make sure I understand what data needs to be compared/migrated between the mysql and postgres database tables. 2. If we are in agreement at that point, you award me the project on Freelancer and I will accept it. 3. You provide the mysql and postgres data to me so I can test/work with it locally on my development system. This would be much better/safer than having me work on your "live" data while developing/testing the code. I'll probably spend 30-60 minutes importing your data. I already have both mysql and postgres. 4. Given that you have two different database platforms I do not think it's realistic to have a single "SQL script" that does this job. Instead, I would propose to write a small "command-line ruby application" packaged as a Ruby gem (1-2 hours). 5. You would be able to install/run this command line application on a linux system of your choosing so long as it supports Ruby v2.0 or better. 6. You test the application on your local system. No more than ~1 day. 6. From start-to-finish I'd guess we're looking at 2-3 days with back-and-forth communication, testing, etc. 7. One payment at the end of the project when we're all done. Let me know. Regards, -Rob