SQL Server Work (Part of export solution to Magento)

This Project will run alongside another project (1098632 - Magento Uploader).

The overall aim of BOTH projects is to extract a list of products (normally just changed products) along with all the various categories and attributes from our stock control database, transmit them to our web server and upload them into Magento. We expect an upload cycle of every 15 minutes and we need some error handling to detect, report and retry records that fail to transmit and/or upload. We have already done some design work and the relevent documentation is attached

This particular project is concerned with the SQL server elements...

- create the relevant tables (Mage_flat_product, Mage_Lock, Mage_errors_log, Mage_success_log, Mage_Update_Index)

- create the relevant triggers to populate the tables and perform other required actions (eg handle tranmission failures)

- create the relevant stored procedures to populate/empty the tables

- ensure appropriate permissions/security are set to protect our data and servers (external processes or scripts from project 1098632 will need to read and extract product data and will need to write a few records such as the table lock and the success/failed flag.

This project will also need to collaborate with the Magento Uploader project for end-to-end testing and cover any fixes or adjustments resulting from the end-to-end testing.

More detailed information is contained within the attached documentation

This project should take no longer than 5 days (excluding end to end testing as we may need to wait a little while for project 1098632 to be ready) and start as soon as possible.

Skills: SQL

See more: sql server web, server scripts, project report cover design, lock&lock product design, list of web design projects, ensure data security, elements actions, stock categories, sql server or, list of web servers, write some sql for a project, stored procedures, stock control, SQL Server, sql server scripts, sql server c, sql projects, sql database report, server testing, report sql, protect database, minutes work, magento server, magento products export, extract tables

About the Employer:
( 6 reviews ) Swindon, United Kingdom

Project ID: #1099990

Awarded to:


Please check PMB.

$550 USD in 5 days
(17 Reviews)

5 freelancers are bidding on average $500 for this job


Hi! I have 11 years exp in MS SQL. I understand what do you need, but not all of it. I can create information migration between 2 MS SQL servers. But you need Mysql and MS SQL? Regards.

$500 USD in 5 days
(4 Reviews)

Please check PM. Thank you.

$400 USD in 5 days
(2 Reviews)

DBA Profile

$250 USD in 5 days
(1 Review)

This Project needs considerable amount of SQL Server related design and development work.

$700 USD in 5 days
(0 Reviews)

Requirement is beautifully explained, this is going to be the interesting work.

$500 USD in 5 days
(0 Reviews)