Fermé

Master DataBase Update Challenge

EXTREME NEED to UPDATE Website Master Database immediately. Here's what's needed:

1. Ensure that DB Master is backed up before Update process (for rollback / recovery/ reworking offline).

2. Run calculation sweep against existing Master DB for price increase of 15% on all pricing. (OPTIONAL -THIS COULD BE DONE LATER TIME).

3. Take New Supplier Products DB and MAP into existing website Master DB Schema to become New Supplier DB feed.

4. Delete existing Supplier Outdated products DB ONLY (Prune existing Supplier database from existing website Master DB)

5. Import into DB Master NEW Supplier Products from DataBase file (CSV/Excel format).

6. Automate or describe existing mapping process so that given input file can be imported into website Master DB so that it can be updated regularly to maintain currency.

7. Demonstrate website Master products DB has updated successfully.

The schema translation process can utilize off-the shelf package solutions for allowing multiple supplier products file schema types to be mapped into the website Database.

Whatever methods are used should not put in jeopardy the overall stability of active production website and preferably is automated to run after-hours on scheduled basis.

Perhaps pulling this data feed from a unique directory where prospective data file is located for ETL processing/importation into Master DB.

Complete documentation provided upon turn-over. Potential contract to maintain database currency on-going if interested and finish work is outstanding.

Compétences : Administration de Bases de données, MySQL, Paniers d'Achat, SQL

en voir plus : paypal ipn update database, zen cart update database ezpages, macro script update database excel, script update database, ultrawebgrid update database, linux script update database, update database vbulletin, magento update database, php script update database using drop list menu, mysql update database file, php message board reply update database, php update database hour, update database php, details file upload update database, access automatic update database

Concernant l'employeur :
( 4 commentaires ) Princeton, United States

Nº du projet : #14803463

33 freelance font une offre moyenne de $602 pour ce travail

polarjin2017

I am from china as a specialist in my software team, good in Desktop, Mobile and Website building and 5 years development experience. And I am experienced in Desktop and Web development with Microsoft technologies Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(30 Commentaires)
0.0
axiomswb

We have expertise in sql,mysql, dba, data processing. Client satisfaction is our main motto for long term relationship.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(44 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
mxicoders

Dear Sir/Ma'am, We possess 14 years of experience in I.T. Field and running MXI Coders Pvt Ltd (INDIA), Our strengths are in Web Designing, Web Development using -HTML 5, Flash, HTML/CSS/CSS3 web pages -Cloud c Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(22 Commentaires)
0.0
smurfimut

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0
SunFlowerBiz

Hi, we have read through your requirements of updating master db. We can start your project immediately. Please check our profile www.freelancer.com/u/SunFlowerBiz.html and be free to contact us if any questions. Regar Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(102 Commentaires)
0.0
VnBestSolutions

Dear Sir. I had read your descriptions about project. Kindly give me a chance, i would like to discuss more about project and sure everything clear. I am a developer very strong in below skills. Relevant Skills and Ex Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(48 Commentaires)
0.0
libxml1

Hi, I'm available and interested to work on this project. Feel free to contact me. Relevant Skills and Experience Full stack web developer Proposed Milestones $600 USD - Payment

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(17 Commentaires)
0.0
navinsuttle

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
MukeshPatel70

I have extensive industrial experience working for companies such as O2, Swisscom and Rolls-Royce Aerospace. I have decided to try out freelancing and this would be my first project. I have experience in all the areas Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
sphinxsolution

(From the makers of Vivino & Dah Makan) Hi, I hope you are doing well, We are 7 year young rapidly growing Website and Mobile App Development Company based out of New Jersey, USA, Gold coast, Australia & Pu Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(6 Commentaires)
0.0
abewickham

Hi, I am very used and comfortable with this kind of task. I have significant back-end , SQL and automation experience. Relevant Skills and Experience I have many years experience in MySQL / MS SQL and server adminis Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(9 Commentaires)
0.0
Nidhijain123

Hello, I have read and understood what has to be done in this task. I have sound experience in performing such kind of work Relevant Skills and Experience Database Administration, MySQL, Shopping Carts, SQL Propose Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(2 Commentaires)
0.0
njain0131

EXPERIENCED DATABASE DEVELOPERS AND ADMINISTRATORS ARE HERE!! PLEASE TELL THE DATABASE IS DEVELOPED ON WHICH PLATFORM! WILL MAINTAIN THE DATA AS MENTIONED IN THE PROPOSAL!! Relevant Skills and Experience VERY EXPERIEN Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(26 Commentaires)
0.0
Mhidayat07

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
bdsiddhi

Dear Employer, Have a Good Day!! I'm confident & interested for this Challenge. As you describe, We can surely help you to update your existing Master Database as quickly as possible with quality work. We hav Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(41 Commentaires)
0.0
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years of ex Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(12 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(3 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0