Solved

MySQL website to/from SQL in store

Posted on 2012-12-26
2
184 Views
Last Modified: 2013-02-14
Hello,

I run a magento storefront and my client asked if I could connect the website to the in store sql db to pull inventory and send orders to.

I am not familiar with how to do this and I am thinking that I could run a cron to send a csv file to a location on the website then tell the customers computer to pull that file and import it into the SQL server they have locally?

I would have to map the fields while doing this.

On a difficulty scale how hard would this be? I can easily have the file dumped to a folder no problem and can use php to map the fields but how to I get that file to their local sql server?

Matt
0
Comment
Question by:movieprodw
2 Comments
 
LVL 11

Accepted Solution

by:
sachiek earned 500 total points
ID: 38723761
You can configure a SQL Agent job to pick this particular files from specific folder - this agent can be configured to run every x time..In other words can run at specific times.

This SSIS package can pull the data from dump file and insert the data to SQL Server. This is one option.

Still you can write custom code with .net and run as windows service too.

Also powershell script is another option.
0
 
LVL 1

Author Closing Comment

by:movieprodw
ID: 38891421
thx
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how the fundamental information of how to create a table.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question