MySQL - Add new products from one database to another

Closed

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.

Skills: Database Administration, MySQL, OSCommerce, UNIX

See more: old database, database building 2, appending, mysql append data, mysql append, import sql database mysql, mysql tables rows, common minor, bash script data, add tables sql, 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, sql script oscommerce, import site oscommerce, oscommerce differences version, mysql additions, mvc3 add mysql database

About the Employer:
( 19 reviews ) Venice, United States

Project ID: #4553813

18 freelancers are bidding on average $130 for this job

SunrisePHP

Hi, We have throughly read your requirements and believe that we can deliver exceptional results. We hope you will consider using our services. Kind Regards,

$144 USD in 6 days
(377 Reviews)
6.9
SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$205 USD in 5 days
(62 Reviews)
6.7
ecartsolutions

I am an oscommerce expert. I can help you with a php script that will check for the difference in the tables and insert the data to the oscmax database. Please check message board for more details. Awaiting your reply, More

$64 USD in 2 days
(189 Reviews)
6.2
oscworker

I am ready to start.

$59 USD in 3 days
(36 Reviews)
5.9
allhen

Ready to help you with this.

$189 USD in 3 days
(45 Reviews)
5.5
trkr

Hi, check pmb please.

$205 USD in 3 days
(30 Reviews)
4.9
prominentsoft

I have expertise in database and I can get it done.

$206 USD in 3 days
(6 Reviews)
4.6
binhtq

I have throughly read your requirements. I am very well familiar with Oscommerce, Creloaded. I can get this done for you. Best Regards,

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

Placing bid

$66 USD in 14 days
(4 Reviews)
2.9
goelvivek

It will be a easy work.

$55 USD in 3 days
(1 Review)
1.6
dhruvjain92

I know SQL and can easily do this

$77 USD in 3 days
(0 Reviews)
0.0
heyram1

Please see your pm.

$144 USD in 3 days
(0 Reviews)
0.0
freelancersudip

I am expert on this job, Ready to start your work

$188 USD in 2 days
(0 Reviews)
0.0
rdelorier

I can write a script that will insert any rows without a matching primary key pretty easily

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

Ready to start and finish

$53 USD in 2 days
(1 Review)
0.0
nojnish

please refer PMB for details

$176 USD in 3 days
(0 Reviews)
0.0
shahrak7777

Check the details in PM

$57 USD in 5 days
(0 Reviews)
0.0
miniric3

Hi, We can give you the best and quick output. We have a professional team in your required area, they work sincerely. You will get your desired output from us. We are very much concerned about quality and customer sa More

$206 USD in 3 days
(1 Review)
0.0