Solved

MySQL website to/from SQL in store

Posted on 2012-12-26
2
163 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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

760 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now