MySQL - Add new products from one database to another - repost

Closed

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. The database file of the live site is 120+ MB so keep this in consideration when posting bids.

Skills: Database Administration, MySQL, OSCommerce, UNIX

See more: old database, bash file, database building 2, appending, mysql append data, mysql append, import sql database mysql, mysql tables rows, common minor, bash script data, add tables sql, script import mysql file, building oscommerce, oscommerce sql script, oscommerce import sql database, oscommerce import data, add mysql database css html templates, mysql database orders, oscmax database, mysql output, database output code, oscommerce database script, work add posting, sql script oscommerce, import site oscommerce

Project ID: #4630514

Awarded to:

partsgr12

I can provide solution to this 'add new products' requirements. Please check Private Message and consider my bid.

$55 USD in 2 days
(0 Reviews)
0.0

13 freelancers are bidding on average $162 for this job

toinnisfree

quick pro help. ftp and milestone required.

$200 USD in 3 days
(305 Reviews)
7.4
meet2amitvw

Let me work for you. i will implement a standalone php script which will transfer your one mysql db record to other db. I am my self developer not any company or agency so you can directly communicate with me. Se More

$257 USD in 3 days
(37 Reviews)
5.7
techwelfare

Hi we checked your requirement,We could develop as per your need. u could check that out. we would work till your satisfaction. Thanks & Regards Techwelfare Please check inbox for our previous work.

$198 USD in 5 days
(23 Reviews)
5.2
drailean

hi, please check the PM

$168 USD in 2 days
(44 Reviews)
4.9
truongngocthanh

Hello, i can done this task quickly.

$200 USD in 2 days
(12 Reviews)
4.6
binhtq

I have throughly read your requirements. I'm a expert in Oscommerce. I can get this done for you. Best Regards,

$150 USD in 3 days
(13 Reviews)
4.6
yanotcook

I am ready to fix. Please check PM for details.

$128 USD in 5 days
(23 Reviews)
4.5
codeCrafter10

Hi, I can create a tool for this. Thanks, Emilian.

$222 USD in 3 days
(16 Reviews)
4.2
vnjoom

Let me do it.

$126 USD in 2 days
(4 Reviews)
2.9
MujtabaAwan

I can help you with this work.

$155 USD in 3 days
(3 Reviews)
1.5
pjssms

I can do it for you very quickly.

$100 USD in 1 day
(0 Reviews)
0.0
twimalasuriya

I can do this. I have linux admin experience over 4 years and mysql administration experience even more. I regularly work with mysql databases that are over 50 Gb

$111 USD in 3 days
(0 Reviews)
0.0
Praveenakumarad

Please check my Private Message

$166 USD in 2 days
(0 Reviews)
0.0