MySQL - Add new products from one database to another

  • Status Closed
  • Budget $30 - $250 USD
  • Total Bids 18

Project Description

The old database is still active for a live site. We are building a new site but has an old version of the database, since then it has got new orders, customers and products. We need to add this data to the sandbox site regularly as we develop.

We need a script that we can run that will append to our new database (oscmax 2.3.5) specific information from an old but still active database (oscommerce 2.2) starting from the common point of them both. You do not need to necessarily know oscommerce at all to make us what we are asking.

This is not a full port since we already did that. Repeat, we are not porting a full database, just taking new additions on specifically listed (below) tables from the old database and "appending" to the new. Since the new (oscmax) database has some minor differences, all rows that are new will have a null value. Below is tables we need appended with the column differences between databases.

customers - 6 vs 10

customers_info - 12 vs 22

orders - 45 vs 51

orders_products - 11 vs 13

orders_products_attributes : 7 vs 10

orders_products_download : same

orders_status : 3 vs 5

orders_status_history : same

orders_total : same

products - 15 vs 24

product_attributes - 7 vs 11

products_description - 9 vs 16

products_to_categories - same

This can be a bash script that compares two sql files and creates an output for import or any type of runnable code we can hit a button on and make work.

Get free quotes for a project like this

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online