Suljettu

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.

Taidot: Tietokannan hallinto, MySQL, Ostoskärryt, SQL

Näytä lisää: 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

Tietoa työnantajasta:
( 4 arvostelua ) Princeton, United States

Projektin tunnus: #14803463

33 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

$555 USD 10 päivässä
(30 arvostelua)
0.0
axiomswb

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

$400 USD 5 päivässä
(44 arvostelua)
0.0
$444 USD 10 päivässä
(0 arvostelua)
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 Lisää

$555 USD 10 päivässä
(22 arvostelua)
0.0
smurfimut

A proposal has not yet been provided

$550 USD 5 päivässä
(0 arvostelua)
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 Lisää

$789 USD 15 päivässä
(102 arvostelua)
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 Lisää

$555 USD 10 päivässä
(48 arvostelua)
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

$600 USD 7 päivässä
(17 arvostelua)
0.0
navinsuttle

A proposal has not yet been provided

$777 USD 10 päivässä
(0 arvostelua)
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 Lisää

$600 USD 7 päivässä
(0 arvostelua)
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 Lisää

$1500 USD 30 päivässä
(6 arvostelua)
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 Lisää

$500 USD 5 päivässä
(0 arvostelua)
0.0
$555 USD 10 päivässä
(9 arvostelua)
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 Lisää

$555 USD 10 päivässä
(2 arvostelua)
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 Lisää

$750 USD 30 päivässä
(26 arvostelua)
0.0
Mhidayat07

A proposal has not yet been provided

$555 USD 10 päivässä
(0 arvostelua)
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 Lisää

$800 USD 10 päivässä
(41 arvostelua)
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 Lisää

$400 USD 4 päivässä
(12 arvostelua)
0.0
$300 USD 10 päivässä
(3 arvostelua)
0.0
$1111 USD 10 päivässä
(0 arvostelua)
0.0