Peruttu

merge mySQL database entries

Hi there i have about 3000 products and about 250 product attributes across about 14 MYSQL databases and i have about 400 customer records with usernames/passwords & address details and order history.

I want all of these merged into one database please!

The estimated size of the MERGED DATABASE will be about 15MB

is this accpetable or too large for servers and web browsers to handle?

OR ALTERNATIVELY IS THERE ANY WAY THAT I CAN HAVE ONE DATABASE WHICH WILL STORE ALL MY CUSTOMERS USERNAMES AND PASSWORDS ETC SO THEY CAN LOG IN TO ANY OF THE STORES

AT THE MOMENT THEY HAVE TO REGISTER IN EACH INDIVIDUAL STORE WHICH IS A PAIN IN THE BUTT FOR THEM AND FOR ME!!

I DONT MIND HAVING SEPARATE DATABASES FOR EACH STORES PRODUCTS BUT ONE DATABASE FOR ALL CUSTOMER RECORDS WOULD BE NICE

IF THIS ISNT POSSIBLE THEN COMBINE ALL DATABASES INTO ONE

STRUCTURE

EACH STORE NAME WILL BE A PARENT CATEGORY AND ALSO EACH PRODUCT WILL HAVE TO BE LABELLED WITH THAT MANUFACTURER (STORE NAME)

SOME STORES WILL HAVE SIMIALR PRODCUT NAMES BUT USUALLY DIFFERENT PRICES

THIS MUST BE DONE TO A HIGH STANDARD

ALL PRODUCTS AND PRODUCT ATTRIBUTES MUST BE LINKED PROPERLY TO THE RELEVANT STORE

IF THIS IS TOO COMPLEX TELL ME AND MAYBE BETTER SOLUTION TO GO FOR PUTTING ALL CUSTOMERS IN ONE DATABASE

Taidot: tiedonsyöttö, PHP, Ostoskärryt

Näytä lisää: merge mysql, merge mysql databases, merge mysql database, mysql database merge, merge product mysql database, structure stores, mysql customer database, manufacturer register, manufacturer prices, manufacturer order, data structure solution, data entry pain, mysql data structure merge, merge database mysql, check database entries mysql, merge complete mysql databases, merge mysql data, mysql merging structures, database maitainence, parent, my entries, complex data entry, customer details database, combine order, mysql structure

About the Employer:
( 2 reviews ) Glasgow, United Kingdom

Projektin tunnus: #436157